What backend are you using? What error do you get (AERROR())? Are you sure you're running query in correct database?

>
>I have sql schemas when I issue the statement with a "new query" as follow:-
>
>select * from ams.amaster
>
>But when i try the same way with exec. Command does not work, the statement as follows:-
>
>=SQLExec (K_NCONNECTHANDLE,'SELECT * FROM [ams].AMASTER','amaster')
>