Hi,

I used the following code to insert some data to a Lianja table through Lianja ODBC

Code:
lnconn = SQLCONNECT("LianjaODBC")

? SQLEXEC(lnconn,"CREATE table ctemp (cDesc c(200))")

? SQLEXEC(lnconn,"insert into ctemp (cDesc) values ('hello testing a question mark in a string value like ? and get error')")
I got this error

Connectivity error: COUNT field incorrect


1) Why it's counting from my string during insert?


and after this error any command via this same ODBC connection gave this error

Connectivity error: Function sequence error

I had to close the ODBC connection and reconnect again to issue any new command to Lianja server.

How can these be avoided ?

Regards
Naeem