trouble accessing fox pro memo fields

[salvatoredoria]

When i access a foxpro database (.dbc) via ODBC i am able to read all the data. But Memo field returns null.
i also tried GetChuck but it was worse
Any idea what i can do ?
p.s. that's my source code

If IsNull(MyRsSource("immagine_art&quot) = False Then
If MyRsSource(&quot;immagine_art&quot <> &quot;&quot; Then Percorso = Left(&quot;C:\Valves\OKEYWin\&quot; & MyRsSource(&quot;immagine_art&quot, 250)
Else
Percorso = Null
End If
Else
Percorso = Null
End If
where MyRsSource is the foxpro table

 

[vb5prgrmr]

Welcome to TT salvatoredoria, to get the most from these forums please read FAQ222-2244.

The easiest way would be to use DAO with ODBCDirect but with that said if you search this forum I belive you will find an ADO solution on how to use GetChunck.

Good Luck

 

[vb5prgrmr]

salvatoredoria, did you read FAQ222-2244 yet? Did you search this site or the web and get the answer you needed?

Good Luck

 

[salvatoredoria]

Thanks for tour hint, but either at Microsoft i didn't find anything on reading Fox Pro Memo fields via odbc.
i forgot to tell that i tried accesing with ADO

 

[vb5prgrmr]

Search this site for GetChunck and you will have one possible answer.

Good Luck