Hi!

Add the '?' before each memory variable in the query:

SQL_STR = "UPDATE ClientType SET clEntity = ?m.entity,"+;
"clFirst1 = ?m.clFirst1,clMI1 = ?m.clMI1,clLast1 = ?m.clLast1,"+;
"clFirst2 = ?m.clFirst2,clMI2 = ?m.clMI2,clLast2 = ?m.clLast2,"+;
"clZip = ?m.zip where clClientID = ?M.CLIENT_ID"
Note that memory variables referenced should exist and contain a valid values before you run the SQLEXEC command.

>Hi Vlad:
> these are the codes that I am getting the connectivity error on:
>
>SQL_STR = "UPDATE ClientType SET clEntity = m.entity,"+;
> "clFirst1 = m.clFirst1,clMI1 = m.clMI1,clLast1 = m.clLast1,"+;
> "clFirst2 = m.clFirst2,clMI2 = m.clMI2,clLast2 = m.clLast2,"+;
> "clZip = m.zip where clClientID = ?M.CLIENT_ID"
>
>OUTPUT=SQLEXEC(gnquoteConn,SQL_STR)
>thanks
>sherry