Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Vfp->sqlserver
Message
From
22/02/2020 05:36:54
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
21/02/2020 13:25:00
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
01673150
Message ID:
01673159
Views:
101
>If I'm not mistaken you could run into snag during the upsizing if any records in the original DBFs contain values that aren't strictly OK (e.g. invalid dates). Additionally blank values could might not transfer if the SQL dataabase specifies NOT NULL for osme of fieldes in the table.

Additionally, any *******.** is not a number in SQL-speak, it will also break the conversion. It also includes the cases where fox will stuff 3456.7 into a n(6,4) field - SQL doesn't use that trick, and if you have such numbers you must make the target column n(9,4) at least. The upsizing wizard usually adds 2 to the number of places, which helps but not always.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform