>Sorry for late answer, the backend I am using MS SQL 2005, The error i got "alis not found"
This is VFP error not SQL Server one. What is the result of this:
IF SQLExec(K_NCONNECTHANDLE,'SELECT * FROM [ams].AMASTER','amaster') < 0
AERROR(laError)
MessageBox(laError[2])
ENDIF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.