Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Upsizing to SQL error
Message
De
16/05/2007 05:45:21
 
 
À
16/05/2007 05:40:57
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:
01225892
Vues:
10
>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.......
>
>Best,
>Viv

Hi Viv,

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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform