Re: [GENERAL] db question - dynamic fields in db

2006-07-02 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Correct, 3 tables. T_SALES_DETAIL records are "line items", the stuff the customer bought. There is only a T_SALES_CC_DETAIL record if the transaction happens to use a credit card. a wrote: > you mean there are 3 tables > the list of items purchase

Re: [GENERAL] db question - dynamic fields in db

2006-07-02 Thread a
you mean there are 3 tables the list of items purchased - this is what i am asking for the list of items purchased What is difference between T_SALES_CC_DETAIL and > T_SALES_DETAIL thanks a lot ron - > T_SALE

Re: [GENERAL] db question - dynamic fields in db

2006-07-01 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 a wrote: > hi > i want to know > how to add a list of items to a database > it is basically text, but different fields > but the problem is i dont know how many fields are there before hand > > so i m not sure how to store them in the db > sometime i

[GENERAL] db question - dynamic fields in db

2006-07-01 Thread a
hi i want to know how to add a list of items to a database it is basically text, but different fields but the problem is i dont know how many fields are there before hand so i m not sure how to store them in the db sometime i need to store 10 elements and some other times 5 thanks a lot a --