xbase/VFP - Memo field

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
halsdk
Posts: 4
Joined: Mon 23 Sep 2019 14:24

xbase/VFP - Memo field

Post by halsdk » Tue 05 Nov 2019 17:36

Hopefully someone can help me- Devart tech support has apparently given up and is no longer responding. Submitted a support ticket and work

My problem is that if I query (From SQL Openquery) a Foxpro table (.dbf) that contains an empty memo field the query returns an error that the data.

An unexpected NULL value was returned for column "[MSDASQL].MEMO1" from OLE DB provider "MSDASQL" for linked server "TEST". This column cannot be NULL.

If I add text to the memo field, it still doesn't work as I get an error:
Cannot get the current row value of column "[MSDASQL].MEMO1" from OLE DB provider "MSDASQL" for linked server "TEST". The provider cannot allocate memory or open another storage object on this column.


So basically, my problem is that I cannot include memo fields in a query which is one of the main reason for purchasing the odbc driver.

Can anyone provide assistance?

Stellar
Devart Team
Posts: 333
Joined: Tue 03 Oct 2017 11:00

Re: xbase/VFP - Memo field

Post by Stellar » Mon 11 Nov 2019 15:11

Thank you for the information.
We fixed the DBF tables locking issue, as well as the issue with reading data from tables that contain Memo fields in MSSMS.
The fixes will be included in the next ODBC Driver for xBase build.

As a workaround, we can provide you with a nightly build of ODBC Driver for xBase.
For this, you should send the appropriate request via the e-support form. (https://www.devart.com the "Support"\"Request Support" menu)

halsdk
Posts: 4
Joined: Mon 23 Sep 2019 14:24

Re: xbase/VFP - Memo field

Post by halsdk » Mon 11 Nov 2019 15:54

Received the link for the nightly build (Nov 6). Installed but none of the issues I am having are resolved.

So still the same 2 issues:
1- Cannot query a table where the result includes a memo field that is empty
2- Cannot query a table if any other table is open in that same folder- Not just the table being queried, but ANY table.

Stellar
Devart Team
Posts: 333
Joined: Tue 03 Oct 2017 11:00

Re: xbase/VFP - Memo field

Post by Stellar » Wed 13 Nov 2019 11:25

We've replied to your ticket in E-Support, please check your inbox.

Post Reply