Re: [users] Special formats in Base
Understandable. If you want to store the extra characters, as far as I know, you will have to make the fields in the database char or varchar fields and type the data in as you want to store it. I seem to recall that Access allowed one to specify storage of telephone numbers as formatted data, but I'm sure MySQL doesn't. I haven't worked with dBase or FoxPro in so many years that I don't know if either of them allow storage of formatted data. Perhaps someone else knows a way, but I rather think you'll have to type the entire text you want to save. Otherwise, you'll have to change your workflow to minimize editing raw data. John On Sat, Oct 17, 2009 at 3:35 PM, <71234.3...@compuserve.com> wrote: > > Hi jomali, > > > > Why would you want to waste space in the database to store the > parentheses, spaces and dash < > > > > At least in my case, because I often modify data in the raw stored database > format, and it is easier if the format is easy to read, and storage space > and computer speed to scan it are now _very_ cheap. > > > > I'm mostly speaking of use in dBase and FoxPro as I am just slowly learning > / converting to OO Base. > > > > Bob >
Re: [users] Special formats in Base
Hi jomali, > Why would you want to waste space in the database to store the parentheses, > spaces and dash < At least in my case, because I often modify data in the raw stored database format, and it is easier if the format is easy to read, and storage space and computer speed to scan it are now _very_ cheap. I'm mostly speaking of use in dBase and FoxPro as I am just slowly learning / converting to OO Base. Bob
Re: [users] Special formats in Base
You're doing nothing wrong, Arnold. The display format of the data is one thing and the data in the database is another. Why would you want to waste space in the database to store the parentheses, spaces and dash in the phone number when you can interpret it as you wish on output? John On Fri, Oct 16, 2009 at 7:47 PM, Arnold Roth wrote: > I have created a form to enter data where one of the fields is a telephone > number. In setting up the table, I entered a custom format as > "("xxx")"xxx"-". This shows as I expected (area code in parentheses > followed by the digits) in the format box. > > When I enter phone numbers in the form, they simply appear in the table as > a string of numbers without the formatting. > > Can anyone tell me what I'm doing wrong? Thanks > > Arnold Roth > > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.org > For additional commands, e-mail: users-h...@openoffice.org > >
[users] Special formats in Base
I have created a form to enter data where one of the fields is a telephone number. In setting up the table, I entered a custom format as "("xxx")"xxx"-". This shows as I expected (area code in parentheses followed by the digits) in the format box. When I enter phone numbers in the form, they simply appear in the table as a string of numbers without the formatting. Can anyone tell me what I'm doing wrong? Thanks Arnold Roth - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org