Sherry,

What happens when you do the following:
>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 output < 0
  aError(laError)
  disp memo like lae*
endif

>
>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
>