Page 1 of 1

"[Devart][ODBC][xBase]Invalid variant type cast" on UPDATE

Posted: Wed 12 Sep 2018 17:01
by 600886402
I am currently evaluating Devart xBase ODBC Driver on Linux.

I receive message "[S1000][Devart][ODBC][xBase]Invalid variant type cast" when attempting to execute an UPDATE statement on one particular table, regardless of number of rows and which columns I attempt to UPDATE.

I can INSERT records and DELETE records into this table, but UPDATE fails in all cases, but only on one particular table.

What is the cause of this exception and what can be done to work around and/or prevent?

Thanks

Re: [S1000][Devart][ODBC][xBase]Invalid variant type cast

Posted: Thu 13 Sep 2018 05:51
by azyk
Please send us all the table files to reproduce the issue. For example, if a table is named one_particular_table, then you should one_particular_table.* files (one_particular_table.dbf and one_particular_table.* index files). Also provide us with the UPDATE SQL query to reproduce the error.

You can send us the files and SQL query using the contact form at our site: http://www.devart.com/company/contactform.html

Re: "[Devart][ODBC][xBase]Invalid variant type cast" on UPDATE

Posted: Thu 13 Sep 2018 13:21
by 600886402
Thank you for responding. I have submitted the files and SQL query as requested.

Re: "[Devart][ODBC][xBase]Invalid variant type cast" on UPDATE

Posted: Fri 14 Sep 2018 09:40
by azyk
Thank you for the information. We reproduced the issue and are investigating it now. We will let you know the results.