Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Upsizing to SQL error
Message
De
16/05/2007 12:34:21
 
 
À
16/05/2007 05:45:21
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows 2000 SP4
Database:
MS SQL Server
Divers
Thread ID:
01225443
Message ID:
01226075
Vues:
18
>>Hi,
>>
>>>One problem that can be ellusive with SQL Server is if a char field has an apostrophe in it, you need to double the apostrophe before inserting into SQL Server. So Jone's becomes Jone''s.
>>
>>Thanks Jim (and Jordan)
>>In fact the problem seems to be a one character field name in the VFP table - viz. 'i'
>>I changed this to 'ix' and the export suceeded. Oddly enough other one character field names, such as 'k', did *not* cause a problem.......

>I would call this a bug. But since single letter variables from a to j are not recommended, they may be excluded for field names also in the upsizing wizard.

It does seem to be specific to 'i' - I tried a field named 'a' and that didn't cause a problem. Oh well....
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform