Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General Discussion » View Thread |
Messages 1 to 10 of 18 total |
Field formatting for display |
Sat, Dec 29 2007 7:05 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Currently I format phone numbers prior to storing them in the table with the format depending on the STD code.
eg of formatted phone numbers 01933 626285 0207 123 456 023 07 966 202885 I'd prefer to store in the database with no spaces and format on display. Any suggestions which would work for TDBText, TDBEdit and TDBGrid? Roy Lambert |
Sat, Dec 29 2007 12:35 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Currently I format phone numbers prior to storing them in the table with the format depending on the STD code. eg of formatted phone numbers 01933 626285 0207 123 456 023 07 966 202885 I'd prefer to store in the database with no spaces and format on display. Any suggestions which would work for TDBText, TDBEdit and TDBGrid? >> Sounds like a candidate for a function in an external module and a virtual computed column in the table. -- Tim Young Elevate Software www.elevatesoft.com |
Sun, Dec 30 2007 4:32 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
I can see that working for a TEDBQuery, but I'll have to experiment with a TEDBTable. Also how does it work for editing. References to the manual, or example or even just some hints appreciated. Roy Lambert |
Sun, Dec 30 2007 5:56 AM | Permanent Link |
"Rita" | The burning question Roy UK or planet Earth ?
Rita "Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message news:0B95DE2D-F27A-4F32-B278-5E577D6547DC@news.elevatesoft.com... > Tim > I can see that working for a TEDBQuery, but I'll have to experiment with a > TEDBTable. Also how does it work for editing. References to the manual, or > example or even just some hints appreciated. > > Roy Lambert > |
Sun, Dec 30 2007 6:37 AM | Permanent Link |
"Rita" | Hint its nearly impossible from the number to seperate
say 0204 from a valid number that may start 02045555 but if you know the place name then its simple but dont forget London it has 3 and some places like you will see in the list I'am posting to binaries in the newstd.txt file look at Bouremouth whatever way you edit that file dont forget to remove them commas or that will mess up your import. Rita "Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message news:0B95DE2D-F27A-4F32-B278-5E577D6547DC@news.elevatesoft.com... > Tim > I can see that working for a TEDBQuery, but I'll have to experiment with a > TEDBTable. Also how does it work for editing. References to the manual, or > example or even just some hints appreciated. > > Roy Lambert > |
Sun, Dec 30 2007 9:17 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Rita
The only way I know to drag the std code out of the phone number is grab the x characters, check against a validation file and peel back until you get a match eg 01933626285 used to be my business number if the validation file contains 0193362 it'll peel back to Raunds otherwise it'll peel back to 01933 Wellingborough. Roy Lambert |
Sun, Dec 30 2007 10:33 AM | Permanent Link |
"Rita" | Ok then use a MaskEdit that changes after your app queries the PlaceName .
5 numerics is the highest in the prefix so that would be easy enough. I think 4 is the lowest you could add a field something like PreFixCount containing either a boolean or an integer for the size of the prefix I would go for the int myself coz gov changes everything Liverpool doesnt even get a mention its known as Merseyside now coz of maggie freakin kill everyone thatcher. Not even going to mention that doggie killing twit who tucks his shirt in his knicks john major. Good luck Rita "Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message news:EED81D4A-70A8-4F02-9459-97C8A3371ED9@news.elevatesoft.com... > Rita > > > The only way I know to drag the std code out of the phone number is grab > the x characters, check against a validation file and peel back until you > get a match eg > > 01933626285 used to be my business number if the validation file contains > 0193362 it'll peel back to Raunds otherwise it'll peel back to 01933 > Wellingborough. > > Roy Lambert > |
Sun, Dec 30 2007 2:05 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Rita
OK if you don't mention the major I won't mention teflon Tony. Roy Lambert |
Sun, Dec 30 2007 10:43 PM | Permanent Link |
Sean McCall | You can use TField.OnGetText to format the value for display.
Sean Roy Lambert wrote: > Currently I format phone numbers prior to storing them in the table with the format depending on the STD code. > > eg of formatted phone numbers > > 01933 626285 > 0207 123 456 > 023 > 07 966 202885 > > I'd prefer to store in the database with no spaces and format on display. Any suggestions which would work for TDBText, TDBEdit and TDBGrid? > > Roy Lambert |
Tue, Jan 8 2008 7:27 AM | Permanent Link |
Roy,
> eg of formatted phone numbers > > 01933 626285 > 0207 123 456 > 023 > 07 966 202885 Watch out for London etc. When inserting spaces in a regular UK landline phone number, to my mind the first space goes after the STD code and before the local number. The idea being that if you are dialling the number from within the same STD area, you can leave off the STD code and dial just the local number. London has now been re-joined into one area, so the STD code is 020. If you want to dial a London number from within London, you have to leave off only the 020 and start with the 3, 7 or 8. (You are one digit short on your London example by the way. London numbers are 8 digits long after the 020.) So, my preferred format for London numbers is 020 1234 5678. The same applies to some other numbers starting with 02... Southampton and Portsmouth are one combined area and have 8-digit local numbers with the STD code 023. Rita's file has Southampton listed as 02380 and Portsmouth listed as 02392, but to dial a Portsmouth number from within Portsmouth or Southampton, you dial the 8 digits starting with 92. (I think this is correct. Maybe a local can confirm?) Similarly, (I believe) Northern Ireland is one combined area with the STD code 028, Coventry is 024 and Cardiff is 029. --Bill Sparrow-- Definition of insanity - doing the same thing day in day out, month in month out and expecting a different result - if you want to make a positive change go to www.sparetimebigbiz.com and watch our 15 minute "What's it all about" video clip - seriously you can make a difference! The company came top of the list in a Which report in October 2007! |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Thursday, March 28, 2024 at 08:36 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |