General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only