that application will soon be redesigned from scratch and the database too (i wish it would be like tomorrow)
thanks for the idea
that application will soon be redesigned from scratch and the database too (i wish it would be like tomorrow)
thanks for the idea
number of person in a vehicle
what I have right now is a form with about 1 to 300 little textbox that accept number (0 to 9) and sometime a "." to flag that textbox to exclude it from a formula
max length of the textbox is 1
the user can enter from 1 to 300 value with or without the flag.
in the database(SQL 2005) right now it's stored in a varchar(900) and it look like
'V4V8V.9V7V5V.1V8V9' (and it can continue until the maximum of 300 is reach)
1 important thing, it must keep the same order when it's loaded/saved
you can now see that it's use a concatenation and I would like to know another good way to do that and I cannot use a XML field and the "." character can change
the DB right now look like:
cellID integer (key)
cellValue varchar(900)
thanks...