Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using field values to format SQL output
Message
 
 
To
27/08/2008 11:57:50
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01342035
Message ID:
01342247
Views:
11
See this thread Strange problem with RAT Thread #1168771

>Good stuff, but much of the issue is that the value in the field for the example is "W9N", but it could just as easily be "ABC10AN" or something else. I'm trying to write something that will parse it apart not knowing exactly what it will be. There could be required alpha, then numeric (ABC10N), or there could be required numeric and alpha (12310A) or alpha and alphanumeric (ABC5AN). I can't see a way to handle it without knowing the values ahead of time.
>
>I have control of these values, so if there is a way to enter them that would make it better, please tell me.
>
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform