Subject | A Correct way for browse and detail queries with IBO |
---|---|
Author | Mark Pickersgill |
Post date | 2003-11-12T14:14:25Z |
Hello,
I've been playing around with IB Objects lately, evaluating it
for an up and coming project. Once you get past the shock factor
of the x number of properties and realise there's an in-built
component editor, things start looking a little better! :)
Anyway, to keep in-line with minimizing network traffic, I'm
planning to have browse screens with grids containing maybe 2-5
columns containing some useful information for the user to pick
a particular record to view the details of. The actual detailed
view of the record may contain 20 odd fields for editing/adding
or perusing.
So, I have a basic query for the browse screen such as:
SELECT BuyerCode, BuyerName
FROM Buyers
My question is, once a user selects a record to get the details
for, is there a smarter way of getting the other details for
that record (for adding/editing/browsing) than having a second
query's MasterSource set to the first query and executing a
query such as:
SELECT * FROM Buyers
FOR UPDATE
WHERE BuyerCode = :BuyerCode
Is this the way to go about it, or is there some "magic" that
IBO has?
I've come from the crude BDE background of SELECT * FROM table,
and only show the particular columns in the grid.
Thanks in advance,
Mark
I've been playing around with IB Objects lately, evaluating it
for an up and coming project. Once you get past the shock factor
of the x number of properties and realise there's an in-built
component editor, things start looking a little better! :)
Anyway, to keep in-line with minimizing network traffic, I'm
planning to have browse screens with grids containing maybe 2-5
columns containing some useful information for the user to pick
a particular record to view the details of. The actual detailed
view of the record may contain 20 odd fields for editing/adding
or perusing.
So, I have a basic query for the browse screen such as:
SELECT BuyerCode, BuyerName
FROM Buyers
My question is, once a user selects a record to get the details
for, is there a smarter way of getting the other details for
that record (for adding/editing/browsing) than having a second
query's MasterSource set to the first query and executing a
query such as:
SELECT * FROM Buyers
FOR UPDATE
WHERE BuyerCode = :BuyerCode
Is this the way to go about it, or is there some "magic" that
IBO has?
I've come from the crude BDE background of SELECT * FROM table,
and only show the particular columns in the grid.
Thanks in advance,
Mark