Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server upsize - Logical to Bit error
Message
From
25/05/2007 17:16:42
 
 
To
25/05/2007 03:21:23
Aman Bains
Jaguar Computers
Jalandhar, India
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01228418
Message ID:
01228613
Views:
58
This message has been marked as a message which has helped to the initial question of the thread.
>Upsizing a database causes error:
>
>Error # 11 in ConvertVfpLogicalToSqlServerBit(0). Function argument value, type or count is Invalid.
>
>This error is shown when a logical field is present in the table and the data is being sent to SQL Server.
>
>The Sedna Feb 2007 CTP upsizing is also showing same error. What should I do to upsize the Data?

Check for the following:
1. Do you have this character, "~", inside any character field in that particular table?
2. Is your SET NULLDISPLAY set to the "~" as well.

If any the above is true, make sure you replace the "~" data and retry.

This is based on the current Upsizing code found in VFP8SP1 as noted.
* Use tilde rather than comma in case commas in char fields
#define BULK_INSERT_FIELD_DELIMITER ~

This is long shot but regardless, having a "~" inside a character field will make the final text file bad form. This is an example of a badformed text file.
*create table (tcTargetDbfFile) (fld1 i, fld2 l null, fld3 c(5) null, fld4 d)
*insert into test (fld1,fld2,fld3 ) values (1,.t.,null)
*insert into test (fld1,fld2,fld3 ) values (1,.t.,"~")
*insert into test (fld1,fld2,fld3 ) values (1,.t.,null)
*Final text file content:
1~1~~01/01/1900
1~1~~~01/01/1900 <-- the fdl3,record#2 data caused a bad STUFF().
1~T~~01/01/1900  <-- the .T. wasn't translated to 1 properly.
ramil
~~ learning to stand still
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform