ODBC Updates

[benjoyner]

I'm using VFP 7.0 to access a Sybase SQL Anywhere 8.0.2 database via ODBC (remote views). I have to use an sql insert command to add records. But when using either an update statement on a button click, or by modifying data
in a grid, the update does not occur? The view is set to update all. Any clues?

 

[mkrausnick]

Add code to call AERROR() to see if a SQL error is occuring. It could be as simple as a syntax error or data type mismatch:

FUNCTION  GetSqlError()    && SQL Error code/text from AERROR()
private aErrArray     && Error message array for AERROR()
dimension aErrArray(10)
aErrArray[1] = -1
aErrArray[2] = 'Unrecognized Error'
=AERROR(aErrArray)
return STR(aErrArray[1],5) + " - " + aErrArray[2]
ENDFUNC

Mike Krausnick
Dublin, California

 

[benjoyner]

Thanks. I'll take any offers for assistance. I'll
plug in the script and test it over the next few days
as I'm out of town.