>lnIID = MyTable.IID >lcQuery = "SELECT * FROM myBigTable WHERE iid=?lnIID" >IF SQLExec(lnHandle,lcQuery,"MyCursor") > 0 > BROW >ELSE > **** Use AERROR() function >ENDIF > > >ldInitialDate = DATE(2003,09,18) >ldFinalDate = DATE(2003,09,20) > >lcQuery = "SELECT * FROM Ventas WHERE dDate BETWEEN ?ldInitalDate AND ?ldFinalDate " >IF SQLExec(lnHandle,lcQuery,"MyCursor") > 0 > BROW >ELSE > *** Use AERROR() Function >ENDIF > >lcText = "Hello World" >ldDate = DATETIME() >lnID = MyTable.iID >lcQuery = "INSERT INTO myTable(nID,cText,dDate) VALUES (?lnID,?lcText,?ldDate)" >IF SQLEXEC(lnHandle, lcQuery) < 0 > **** Error, use AERROR() >ENDIF > >