I'm storing this as a 15 character alpha field
On Sep 13, 2007, at 1:47 PM, Brad Perkins wrote:

Mike,

If you run String on an alpha value it will not apply the format. Unlike 4D it doesn't barf if the argument is a string. I mention this because I tried this yesterday for a similar purpose and it didn't work.

If he stores the phone as a strictly numeric string, he may be able to coerce it to a number first.

$phone:=String(Num([table]phoneField);"(###) ###-####")

-- Brad


Mike Erickson wrote:
How is your phone number stored in the database? If it is all numbers (10 digit phone), you can do something like:

   $phone:=String([table]phoneField;"(###) ###-####")

<%=String([table]phoneField;"(###) ###-####")%>

Regards

Mike Erickson
Automated Solutions Group
On Sep 13, 2007, at 10:35 AM, James Mccarthy wrote:

What is the code for displayng phone numbers in A4d (603) 482-8998
[Salespeople]PhoneNum:$phone

_______________________________________________
Active4D-dev mailing list
[email protected]
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/


_______________________________________________
Active4D-dev mailing list
[email protected]
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/


_______________________________________________
Active4D-dev mailing list
[email protected]
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/

Reply via email to