Dynamic SQL View not saving default @PARn@ value

[shearerg]

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 5381 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

[Carsten Sørensen]

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

[shearerg]

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