Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting data from Clipper 5.2
Message
From
11/09/2001 05:08:25
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00554602
Message ID:
00555020
Views:
15
Thanks Bob,
Problem is that this is version 5.2 Clipper file not prior and 5.2 lets more than 255 fields to exist. Once in a fox believe me I have no problem playing with it :)
Anyway I'm dropping this question assuming solved the hard way. Left my computer open at night and got them via SQL pass through.
Cetin

>Not that I worked with Clipper, but I did work with a differnt version of Xbase prior to moving into the VFP world.(many of us did)
>I used a little known version called dBman, and the first time I opened up the files dbf files inside VFP, VFP knew exactally what to do with them, I had complete access to the data therein. (sure I worked on copy of those files) becuase I knew or figured that I didnt know what VFP would do with them...
>
>But once the files were opened, using the standard use bla in 0. I could then copy the records, save as, didnt matter, the data was now VFP data. Something.
>The indexes were not converted properly. So in VFP I did have to recreate the index's) but then again, indexes were not all that tough to recreate.
>
>Is your problem or concern that you don't know about how the indexes were created, and dont know the keys, ... to recreate them. ?
>
>Bob Lee
>
>>What could be an efficient and fast way of getting data from a Clipper 5.2 table for one time only. Table has too many records. Is there a faster solution than SQL pass through preferably not lowlevel ? TIA.
>>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