Hi All,
I have stored a sql script in text file which look like following:
I read contents of text file into a string and pass the string to a QueryTable object. StrCode is a string variable in my module.
If StrCode is '0034', how do I evalaute my sql string so that it reads :
Any help is much appreciated.
I have stored a sql script in text file which look like following:
Code:
Select Code, CodeDesc, EffDate from DTran where
Code =' StrCode '
I read contents of text file into a string and pass the string to a QueryTable object. StrCode is a string variable in my module.
If StrCode is '0034', how do I evalaute my sql string so that it reads :
Code:
Select Code, CodeDesc, EffDate from DTran where
Code ='0034 '
Any help is much appreciated.