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 Ryness
International Falls, MN