>lnSqlHndl = sqlconnect('mydsn')
>lcSql = 'update mysqltable set myfield1 = "value1" where myfield2 = "value2"'
>sqlExec(lnSqlHndl,lcSql)
>
>SqlExec keeps returning -1 even though lnSqlHndl represents a valid handle. MyDsn uses windows authentication. The table permissions are set so everyone has rights to everything. I checked my sql syntax in the query analyser and it works in there. I can't figure out what's going on.
>
>I'm useing Win2k server with Sql Server 7.0.

---

Rip,

Use AERROR(laError) to get error information into array laError.
If laError[1,1] = 1526 than ODBC error message will be in laError[1,3].