Subject | In Grid editing |
---|---|
Author | Robert martin |
Post date | 2004-12-06T19:38:54Z |
Hi All
I am using FB, IBOQuery, TDataSet and a custom DBGrid component that is
pretty much the same as TDBGrid. I don't do a lot of in-grid entry normally
but in this case it makes sense. I have a complex (but fast) query that
returns sales information for items supplied by one supplier (essentially a
report), that shows in a grid. I want to add two columns that allow data
entry into a separate table. What do people think is the best option?
The one I can think of is to simply link the other table to the query and
provide customised Update / Edit SQL statements. Is this appropriate or is
there a better way to do it?
p.s. I really want to stick with my customised TDBGrid component, from both
a functionality and application consistency perspective.
Rob Martin
Software Engineer
phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com
Wild Software Ltd
I am using FB, IBOQuery, TDataSet and a custom DBGrid component that is
pretty much the same as TDBGrid. I don't do a lot of in-grid entry normally
but in this case it makes sense. I have a complex (but fast) query that
returns sales information for items supplied by one supplier (essentially a
report), that shows in a grid. I want to add two columns that allow data
entry into a separate table. What do people think is the best option?
The one I can think of is to simply link the other table to the query and
provide customised Update / Edit SQL statements. Is this appropriate or is
there a better way to do it?
p.s. I really want to stick with my customised TDBGrid component, from both
a functionality and application consistency perspective.
Rob Martin
Software Engineer
phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com
Wild Software Ltd