Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursortoXML
Message
 
To
07/02/2005 17:32:38
Joel Hokanson
Services Integration Group
Bellaire, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00984592
Message ID:
00984595
Views:
16
>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.
>
>Any thoughts or suggestions?


Joel,

Why don't use either UPPER() or LOWER() in the stored proc to force the field names to one case or the other for value testing?

Laterness,
Jon
Jon Rosenbaum
Devcon Drummer
Previous
Reply
Map
View

Click here to load this message in the networking platform