Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CursortoXML
Message
De
08/02/2005 14:50:43
Joel Leach
Memorial Business Systems, Inc.
Tennessie, États-Unis
 
 
À
07/02/2005 17:32:38
Joel Hokanson
Services Integration Group
Bellaire, Texas, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00984592
Message ID:
00984859
Vues:
22
Hi Joel,

>When I use =Cursortoxml("mytable","myxml") the field names from Mytable.dbf are all converted to lower case in myxml.
>
>The problem is that if I use a stored procedure in SQL, the field names are case sensitive. Naturally the fix is to simply use lower case in the SQL Stored prodedure, but it would be good if I could control the case in the XML.
>

Actually, VFP stores the field names in lower case, which is why they are lower case in the XML. If you use XMLAdapter, there is a property (Alias?) for each field where you can set the case. West Wind wwXML might be another option, but I'm not sure. Otherwise, you can use StrTran() to convert the case. That's what I've done for VFP7 stuff, but it can be a lot of code. Note that this problem can also occur when passing XML to .NET classes/web services, which are case-sensitive as well.
Joel Leach
Microsoft Certified Professional
Blog: http://www.joelleach.net
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform