Subject | Re: Philosophy of using IBObjects |
---|---|
Author | wm@top-sa.com.pl |
Post date | 2001-07-10T09:28:53Z |
Thank You for Your reply, Helen!
I am of course using TIBOTable.
First problems I solve after Your message. All troubles with
positioning in records were from bad primary index.
Thank You once again.
Second problem I am working about is (not clear to You in my first
message):
I have to write to one table for ex. customer order like:
first item:
symbol='ORD'
number= ???? - this must be next number for selected symbol
('ORD' in this example - in table there are different symbols)
item_no=1
and rest of this position (ex. name of item, quantity etc)
second item:
symbol='ORD'
number= ???? - same like first item of this order
item_no=2
and rest of this position (ex. name of item, quantity etc)
and more items
Every order must have unique symbol and number combinantion ex
ORD 1
ORD 2
ORD 3 etc
So, can You show the best way to do this mechanism. Maybe create
stored procedure was best. Now I am trying simple algoritm when every
user checks bigger number for own symbol then posts it to table. If
posting is unsuccesful (primary key not unique) I try to increase
number. I think that it is maybe good method by really not fast.
Any suggestions?
Last question.
I am writing applications few Years but now from 3 weeks (try) using
IB. Can I ask for something (maybe stupid) in this place, maybe You,
maybe elsewhere? Can You send me suggestion ?
Regards
Materna Wojciech
I am of course using TIBOTable.
First problems I solve after Your message. All troubles with
positioning in records were from bad primary index.
Thank You once again.
Second problem I am working about is (not clear to You in my first
message):
I have to write to one table for ex. customer order like:
first item:
symbol='ORD'
number= ???? - this must be next number for selected symbol
('ORD' in this example - in table there are different symbols)
item_no=1
and rest of this position (ex. name of item, quantity etc)
second item:
symbol='ORD'
number= ???? - same like first item of this order
item_no=2
and rest of this position (ex. name of item, quantity etc)
and more items
Every order must have unique symbol and number combinantion ex
ORD 1
ORD 2
ORD 3 etc
So, can You show the best way to do this mechanism. Maybe create
stored procedure was best. Now I am trying simple algoritm when every
user checks bigger number for own symbol then posts it to table. If
posting is unsuccesful (primary key not unique) I try to increase
number. I think that it is maybe good method by really not fast.
Any suggestions?
Last question.
I am writing applications few Years but now from 3 weeks (try) using
IB. Can I ask for something (maybe stupid) in this place, maybe You,
maybe elsewhere? Can You send me suggestion ?
Regards
Materna Wojciech