Hello All:
Is there a setting I have to set for using sqlexec(), I am getting -1 from the following code:
SQL_STR = "UPDATE ClientType SET clEntity = '"+ m.entity +"',;
clFirst1 = '"+ m.clFirst1 +"',clMI1 = '"+ m.clMI1 +"',;
clLast1 = '"+ m.clLast1 +"', clFrist2 = '"+ m.clFirst2 +"',;
clMI2 = '"+ m.clMI2 +"',clLast2 = '"+ m.clLast2 +"',;
clName = '"+ m.clName +"',clDBA = '"+ m.clDBA +"';
clZip = '"+ m.zip +"' where clClientID = '"+ M.CLIENT_ID +"'"
OUTPUT=SQLEXEC(gnquoteConn,SQL_STR)
if I take out some of the fields from sql_str it will work:
SQL_STR = "UPDATE ClientType SET clEntity = '"+ m.entity +"',;
clFirst1 = '"+ m.clFirst1 +"',clMI1 = '"+ m.clMI1 +"',;
clLast1 = '"+ m.clLast1 +"',clCity = '"+ m.city +"',;
clState = '"+ m.State +"',clAddr2 = '"+ m.Addr2 +"',;
clAddr1 = '"+ m.addr1 +"',clZip = '"+ m.zip +"';
where clClientID = '"+ M.CLIENT_ID +"'"
The help file indicates that sqlexec() returns -1 there is a connection level error. what does it mean? The connection did not drop? help.
sherry
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only