You've to check return values after SQLPREPARE() and SQLEXEC() to make sure that they executed w/o errors.

lnResult = SQLPREPARE(nHandle,cInsStr)
IF lnResult < 1    && Error
  * Use AERROR() to retrieve ODBC error
  * Process error
ENDIF
lnResult= SQLEXEC(nHandle)
IF lnResult < 1    && Error
  * Use AERROR() to retrieve ODBC error
  * Process error
ENDIF

>I am using SQLexec() with SQLprepare() function it gives me following error.
>
>SQL statemnt parameter is required for non-prepared SQLEXEC() calls.
>
>sample code is as follows

>cInsStr = "Insert into APPL values("+allt(str(m.MAppKey))+","+ ;	                         thisform.cmbBranch.value+","+;
>	                         allt(ThisForm.Text1.value)+","+;
>	                                                  "'',"+;
>		                                     "0,"+;
>		                                     "0,"+;
>		                                     "0,"+;
>		                                     "0,"+;
>		                                     "'1',"+;
>		                                     "'N',"+;
>		                                     m.DtStamp+")"
>		=sqlprepare(nHandle,cInsStr)
>		=sqlexec(nHandle)

>
>&& where APPL is remote table name
>&& mappkey is numeric
>&& cmbBranch is 3 digit code
>&& dtstamp is 01/29/2003 in character format.
>
>&& handle is frmm sqlconnect()