Subject | Locate and Master Detail |
---|---|
Author | waynef123456 <waynef@webonline.co.za> |
Post date | 2002-12-18T07:30:10Z |
I have two TIB_Queries
set up in a Master Detail.
I then do a locate on the master Query
and if found
I put the Master in Edit mode, then the detail in
edit mode ( 1:1 relation ).
My problem is that the Detail never goes into edit mode.
so it seems I have to do a locate on that query as well
Here are the details
(1)
qryAcc.prepare; // Open
qryEnq.prepare; // Open
(2)
if qryAcc.Locate('ID', id, []) then
begin
qryAcc.Edit;
qryEnq.Edit;
I have noticed that if I do not use prepare but Open,,
it works ...
waht is the best way of doing this, I would hate to have to use
'OPEN'.
Thanks
Wayne.
set up in a Master Detail.
I then do a locate on the master Query
and if found
I put the Master in Edit mode, then the detail in
edit mode ( 1:1 relation ).
My problem is that the Detail never goes into edit mode.
so it seems I have to do a locate on that query as well
Here are the details
(1)
qryAcc.prepare; // Open
qryEnq.prepare; // Open
(2)
if qryAcc.Locate('ID', id, []) then
begin
qryAcc.Edit;
qryEnq.Edit;
I have noticed that if I do not use prepare but Open,,
it works ...
waht is the best way of doing this, I would hate to have to use
'OPEN'.
Thanks
Wayne.