
Accessing the memo field of a DBase IV file
Quote:
>hi,
>I'm looking for a way to access the memo field of DBase IV file.
>I've tried Q+E database/VB and the grib of VB4. They work great for
>every kind of field except for the memo field. It looks like that they
>stop to scrool the database at the first memo it con't translate !!!?
>Does anybody know a way around this or another product that could do the
>job ?
>Nicholas
Hi Nicholas,
I've never play with VB and DBASE IV but I've already developped an application
with VB and FoxPro 2.6 which is DBF file like Dbase IV.
The way I've accessed the memo fields of my FoxPro database was by using Data
Controls.
DATA1.database = "database name" (odbc driver in my case)
DATA1.connect = "connect string" ("odbc;" in my case)
DATA1.RecordSource = "table name"
Then I've bound a TextBox control to DATA1 as follow:
TEXT1.data = DATA1 (I'm not sure about this property name)
TEXT1.Fields = "Memo Field" (of Table Name mentionned in DATA1.RecordSource)
After, you navigate accross the table and the memo field is updated at each
MoveNext, MoveFirst,..., methods.
Hope it would help you,
--------------------------------------------------------
Eric Theroux Bell-Northern Research
Software Designer Montreal, Quebec