Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Writing data from date, time, boolean and number fields
Message
From
05/10/2005 12:28:22
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
05/10/2005 12:04:40
Susan Pelto
Da Vinci Seclorum, Inc.
Pueblo, Colorado, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 3
OS:
Windows '98
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01056331
Message ID:
01056343
Views:
15
>I'm using a database in VFP 3. I'm trying to pull data out of the tables into a text file. What low-level calls are there to write data from date, time, boolean and number fields in a VFP table to a file? Something similar to the FWRITE and FPUT functions.
>
>I'd like to pull all the data out at once: memo fields as well as the others.
>
>Thanks.

There are fopen(),fcreate(),fwrite(),fread(),fgets(),fputs(),fchsize(),fclose(),...
Quickest would be:
Copy to myFile.txt type delimited
but that doesn't copy memo fields (and general of course).
There are commands like "set textmerge", "set alternate".
There is VFPOLEDB which you could utilize to create an XML with memo included.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform