On Fri, 30 Aug 2002 07:33, Ho-Sheng Hsiao wrote:
> > lines as required, I think the use of SL would be much improved.
>
> Huh? Dunno what you mean by "check". A lot of the caculation happens
> server-side because that's where the database is.

Some can be done on the client without hitting the server. If, for example, I 
decide my invoice numbers follow this patterm, "XXX-9999" then I could 
customise the JS to verify that it follows that pattern. If my part numbers 
somehow encode the class of product then it could very the "unit" column is 
valid, so I don't have five days of disk drives.

When I learned my computing back in the 70s, we learned to check data items 
for correct characters so that numeric fields contain valid numbers, 
pensioner numbers are valid pensioner numbers (within range, correct check 
digit) and so on, and that individual transactions were internally 
consistent.

Records that pass those checks are then validated against data files. We could 
have a valid pensioner number, but no pensioner with that number, and that's 
the kind of error this validation would catch.

A standard check that _could_ be included is that an email is syntactically 
valid. Other checks might be added as customisations by us, the users.


-- 
Cheers
John Summerfield


Microsoft's most solid OS: http://www.geocities.com/rcwoolley/






-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
-------------------------------------------------------
(un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users
Archive: http://www.mail-archive.com/[email protected]/

Reply via email to