Skip to Content
0
May 27, 2008 at 07:10 PM

Can a Data Store value be used in a Data Source SQL statement?

28 Views

I have a Form in my iView that has a VSlider. This VSlider outputs a Number to a DataStore

I would like to use this number in a SQL statement for a Data Source. Is this possible? If so

how is it done?

for example......

Select * from MyTable where MyField1 between ( Current_Date - STORE@DataStoreField ) and Current_Date

This SQL gives error that states ' STORE@DataStoreField' is invalid identifier. How can I reference the DataStore value within my SQL ?

Thank You

MPersson