Can you read/write FoxPro memo fields thru SQL?

[BlackburnKL]

I have been asked to write a VB front-end to a FoxPro database. The only problem I have encountered so far is a memo field.

The really odd thing is that when I set a watch on the code and see it load the field (as the last field in the SQL statement), it loads. I can see it in the watch window. However, as soon as the next command executes (either in the immediate window or in the program itself, the .Value property changes from the memo text to Null. It's really wierd.

What am I doing wrong?

Is there anybody out there that knows how to read and write FoxPro memo fields through SQL statements in VB?

Thanks, in advance, for your help and efforts. BlackburnKL

 

[vb5prgrmr]

Using ADO you will have to use the GetChunck method. A search of this site using all dates should get you an example.

Good Luck

 

[BlackburnKL]

A search of this site for the GetChunk method resulted in about 46 threads. I have reviewed them, but am still at a loss. I couldn't make the leap from them to my situation.

Does anyone have example code for reading and writing FoxPro memo fields? Please help!

Thanks! BlackburnKL

 

[CCLINT]

try my post in the MS DataBase forum under thread709-391834