>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.
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