SQL insert fails and subsequent commands give same error

[naeempk]

Hi,

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

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

[CGibson]

Hi Naeem,

I too have had issues with using a ? in a string.
The problem is that a ? is a special lianja character for displaying items in the console.

I don't believe my issue was ever fully resolved although you could try to a substitution, as recommended by Lianja staff for a similar issue.

//  ** This is untested **
strSQL = "insert into ctemp (cDesc) values ('hello testing a question mark in a string value like ? and get error')"
strSQL = str_replace("?", '"' + chr(63) + '"', strSQL)
SQLEXEC(lnconn,"&strSQL")

Cory

[naeempk]

Hi Cory,

Thank you for sharing a solution. I also want a solution from Lianja Team. I am more interested about the second part of my query of constant ODBC commands failure after this error.

Every error should be specific to its own command as in other databases access via their ODBC. It should not effect the other commands. It forces me to close that ODBC connection handle as this makes it useless.

Regards
Naeem