Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Zip Code Format
Message
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Title:
Miscellaneous
Thread ID:
00236707
Message ID:
00236716
Views:
13
>Why does this not work?
>
>The ZipZode field is C(10) and contains
> "12345-6789"
>
>I use
>
> cZipCode = TRANSFORM(Addresses.ZipCode, "99999-9999")
>
>And I get back:
>
> "12345-789"
>
>What am I doing wrong?
I am not sure, but I just did the following in the command window, and got back the correct values:

x = '12345-6789'
y = transform(x, '99999-9999')
? y && returns 12345-6789

I also tried it on a phone number field in one of my tables with a mask of 999-999-9999, and it returned the phone number properly. I am using VFP 6 SP3.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform