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

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
600886402
Posts: 2
Joined: Wed 12 Sep 2018 16:51

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

Post by 600886402 » Wed 12 Sep 2018 17:01

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
Last edited by 600886402 on Thu 13 Sep 2018 13:17, edited 1 time in total.

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

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

Post by azyk » Thu 13 Sep 2018 05:51

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

600886402
Posts: 2
Joined: Wed 12 Sep 2018 16:51

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

Post by 600886402 » Thu 13 Sep 2018 13:21

Thank you for responding. I have submitted the files and SQL query as requested.

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

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

Post by azyk » Fri 14 Sep 2018 09:40

Thank you for the information. We reproduced the issue and are investigating it now. We will let you know the results.

Post Reply