Hi Devrishi,
If you know the command is going to be SELECT, just store the parameters in the property, as in "* FROM anytable".
Then....
cCmdParms=myform.sqlstring
SELECT &cCmdParms
>Hi there!!
>
>i am designing a standard help form for my application with SqlString as a property.
>
>myform.sqlstring = "select * from anytable"
>
>my problem is how can i execute a sqlstatement stored in string.
>
>i tried evaluate() function but that didn't work.
>
>
>
>Regards
>
>Sunny
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05