Dynamic AI Support Forum

Posted: **Wed Sep 08, 2010 5:12 am**

Hi,

I'm trying to use a parameterised Dynamic SQL View in Personal Edition which I have working already in the Server edition. The definition tests OK in design mode, but when I save the definition the @PAR1@ entry and default value (@DATE:NOW()) is not saved. This means that when the View is browsed or specified for a report a database error results.

: ScreenShot094.jpg (31.37 KiB) Viewed 5382 times

Am I doing something wrong? It doesn't seem likely to me that this could be a real bug, as it would have already been noticed by other users. Any advice will be appreciated.

Regards,
Greg Shearer

Posted: **Wed Sep 08, 2010 6:22 am**

Hi Greg,

Dictionary functionality is not part of the personal edition. @PAR's are stored and maintained through the dictionary which is a Server edition function only.

It is a bug that you can define them.

Best regards,
Carsten

Posted: **Wed Sep 08, 2010 6:53 am**

Understood. Must admit the process for defining @PAR1@ did seem a little odd, as the means was not presented within the initial definition screen. Trust me to find a way :wink:

Dynamic AI Support Forum

Dynamic SQL View not saving default @PARn@ value

Dynamic SQL View not saving default @PARn@ value

Re: Dynamic SQL View not saving default @PARn@ value

Re: Dynamic SQL View not saving default @PARn@ value