Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Huge SDF
Message
From
05/06/2001 12:31:25
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00515172
Message ID:
00515209
Views:
14
This message has been marked as the solution to the initial question of the thread.
>>>Hi everybody,
>>>
>>>I have this problem, which I'm seeking the best solution. I want to extract ~2mln. records from database into SDF file. I can do it in one SQL, but it produces first line with Field names. I don't want them. What's the best way to get rid on field names? Do I need to go SQL into table then copy to file?
>>
>>What's wrong with copy to .. SDF ?
>>Cetin
>
>Oops again, would not work. In our database we have address field and we don't have busres field. Customer wants StNum, Street fields and BusRes field.
>So, I have to create SQL like this:
>
>select lastname, firstname, padr(substr(Address,1,at(' ',Address)),6) as StNum, ;
>padr(ltrim(substr(Address,at(' ',Address))),25) as Street, State, ;
>Zip, Phone, 'R' as BusRes
>
>So I think I have to use two steps here. It would be easier, though job would run quite long... It's one in year job, so that's not a big deal.
>
>Thanks again.

Then 'set heading off'
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
Next
Reply
Map
View

Click here to load this message in the networking platform