Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement