Accessing the memo field of a DBase IV file 
Author Message
 Accessing the memo field of a DBase IV file

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



Mon, 03 Aug 1998 03:00:00 GMT  
 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



Tue, 04 Aug 1998 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. dBase IV memo field corruptions

2. DBase IV Memo field corruptions - multiuser

3. Reading fields from a dbase IV file

4. VB/Access and dBASE IV mdx files?

5. Accessing dBASE IV file in VB3

6. VB dBase Clipper Access memo field problem

7. Import/Export to/from dBase IV looses time in DateTime field

8. Dbase IV : listing of fields in a combo/listbox

9. Adding Fields to Dbase IV

10. Dbase IV : listing of fields in a combo/listbox

11. DAO w/ dBASE IV Null Character Fields

12. dBASE IV table into Access Database table?

 

 
Powered by phpBB® Forum Software