Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing CLipper Database into VFP
Message
From
22/06/1999 12:27:06
 
 
To
22/06/1999 11:10:41
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00232397
Message ID:
00232556
Views:
20
>>Am trying to import a clipper database into VPF
>>but VFP is having problems with any clipper table
>>that includes memos ...
>>
>>Any ideas ?
>
>You shouldn't have to import the table... you can open it in VFP and the memo field should be converted automatically. You can work with a copy if you don't want you originaly file converted.
>
>From the VFP docs:
>
>Before you can append from a table created in dBASE IV or dBASE V that contains a memo field, you must first open the table in Visual FoxPro with USE. When you are prompted to convert the file, choose Yes.
>
>If you append from a Visual FoxPro table or a table created in an earlier version of FoxPro, the table you append from can be open in another work area. Records marked for deletion in the table you are appending from are unmarked once the records are appended.
>
>

>
>BOb

FWIW: Are you sure these are really Clipper DBF files and not using some replaceable database drivers (RDDs) that break the standard dBASE rules (including that all fields are less than 255 characters wide)? Native Clipper and some RDDs for Clipper can have field widths wider than FP, so that could be the problem. If so, your only alternative is to use Clipper to generate some intermediate file format and/or structure to match the limits in FP, and then APPEND or just USE from there...

HTH

Rob
Previous
Reply
Map
View

Click here to load this message in the networking platform