How to let DA Schema Modeler remember the parameter type

Data Abstract
1

How to let DA Schema Modeler remember the parameter type

We use da schemas with custom SQLs and some integer parameters

The SQL might look like this
SELECT * FROM [NarcoregUploads]
LEFT JOIN vProductDetailLightML ON nru_prd_primkey=prd_primkey
AND ( (:pnm_frans=-1) OR (pnm_frans=:pnm_frans) )
AND ( (:pnm_nederlands=-1) OR (pnm_nederlands=:pnm_nederlands) )
WHERE
{WHERE}

To test the SQL, create the fields and update the mapping we use the preview button.
However we have to specify the parameter type each time.
This does not get persisted (see screenshot)
How can we persist this?

afbeelding
afbeelding999×383 8.03 KB

2

Hi,

Have you specifed parameter type in Parameters node ?

Untitled
Untitled984×805 28.3 KB

3

When I define it there I it appears to persist now.
However, I believe I have done this in the past and the info was forgotten.
We get many errors in the schema modeler, maybe after some errors the data gets wiped.
I’ll keep an eye on it for now

4

FYI: At the moment I am having this error again.

afbeelding
afbeelding995×361 22 KB

Does the schema modeler cache DB metadata? How can we refresh?

5

Hi,

What DB driver (Delphi or .NET) are you using?

6

mssql.net

afbeelding
afbeelding1413×676 57 KB

7

Hi,

do you have this error with persistent DB metadata or DB metadata was changed after starting Schema Modeller?

Yes, it caches such info

8

I am assuming I only have it when I add data to the DB when the modeler is open.
How do I refresh?

9

Hi,

You can try to use this trick:

  • change something in connection string so it will be invalid
  • it should reset cache for this connection
  • change it back
10

Thanks, I’ll do that or restart the app