Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to SKIP rows containing big numbers
Message
From
09/12/2005 17:34:01
 
 
To
09/12/2005 12:57:02
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01076668
Message ID:
01076778
Views:
21
>
CREATE TABLE test ( test numeric(10))
>INSERT INTO test VALUES (100000000000)
>
>Causes 1.000E+11 to be stored in test.dbf
>
>I have a lot of numeric fields which may have such issue.
>I load data to Postgres SQL server using VFP code and those rows cause
>the load process to be aborted.
>
>How to skip such rows when upsizing data using VFP code?

Which code ?

Do you want to discard these records ?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform