On 13 Oct 2006, at 22:06, R Pennington wrote:
> Is there any restrictions on which characters can be used in alpha
> numeric fields like the part description ?
> ... Are / and " ok ?
I don't know what characters are supposed to be ok or not, but I can
tell you that regular quotes (") don't work in the company name field.
If I save a customer called George "Dubya" Bush then create a new
sales invoice only `George` (without the quotes) will display in the
customer field of the invoice entry page.
I would imagine there are very few people who are affected by this
feature in the way I am, however I have a database of several hundred
customers, mostly individuals, some of whom might not call me for 2
years. When preparing the invoice it would be easier to search for
"Dubya", because I might not remember his real name - he'll call me
up and say, "Hey, this is Dubya here, can you come round & do some
work for me?" I can't make the invoice out to "Dubya", but equally
I'd prefer not to have to admit to not remembering a pertinent detail
about one of my customers (most of whom treat me like a great, long-
lost friend).
Like I say, there are probably few customers affected by this the way
I am, they're probably all sole traders like me who will not be
investing in adding quotes as a feature to SL, and it's not a big
deal anyway as I can work around finding the guy's name by first
searching for his address. But ,y experience does help answer your
question, I think.
I seem to recall that slashes have the same problem, but you can
check this on one of the demo installations of SL linked to from
Dieter's website - just create a new part, and try making a new
invoice in which it features.
Stroller.
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sql-ledger-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users