Hi i have 3 variables one say Columnname tells about the database column names ,other two variable2 & variable3 tells about timestamp for eg( 03-Apr-2012 12:25:00 ).
Columnname = abcd variable2 = 03-Apr-2012 12:25:00 variable3 = 10-Apr-2012 12:25:00
after connecting to database & building query like this
data=exec(connection,'SELECT Columnname FROM TABLENMAE WHERE Columnname >= (''variable2 '') AND Columnname < (''variable3 '') ');
but i am getting data as blank.feels some issues while building query
Thanks in advance
Best Answer