I don't remember who asked this, but I responded and my message got lost somewhere in between power outages. The original question was about SQLEXEC returning -1 when a variable is used on the INSERT into Oracle7.1 database table, while when an actual value is used the INSERT was executed OK.
I use the combination of SQLPrepare/SQLExec/SQLCommit to take advantage of altering just the value of a variable instead of re-executing the entire SELECT/INSERT/UPDATE/DELETE statement. And I use this on both SyBase and Oracle7.1 databases. The variable name should be preceeded with ? (question mark): ?MyVar, and for each field that was created with NOT NULL clause the corresponding value (' ' or 0) has to be specified in the VALUES clause of the INSERT statement.
Hope it helps whoever was asking about it :)
Some things are better be left unknown...NOT!!!