On Mon, 16 Oct 2006 12:28:51 +0100, Stroller wrote
> 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
quotation marks are used to initiate an exact search. In order to do a
search for a name with quotation marks you'd have to specify the exact name
including the quotation marks.
Dieter Simader http://www.sql-ledger.com Tel: (408) 898-4421
DWS Systems Inc. Accounting Software Fax: (780) 478-5281
============== On a clear disk you can seek forever ================
-------------------------------------------------------------------------
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
