Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread DBISAM ERROR
Sat, Mar 4 2006 6:03 PMPermanent Link

Paul Waegemans
I use the following code to make a master detail between 2 tables.

with dm.tblhoofdjournaal do
    begin
    if active=true then close;
    end;
with sqljournaalnummers do
    begin
    sql.clear;
    sql.add('select distinct journaal_nr into hoofdjournaal from journaal ');
    prepare;
    open;
    close;
    unprepare;
    end;
with dm.tblJournaal do
    begin
    if active=true then close;
    mastersource:=dm.srchoofdjournaal;
    masterfields:='journaal_nr';
    open;
    end;
with dm.tblhoofdjournaal do
    begin
    if active=false then open;
    end;

THIS RAISES THE ERROR IN ATTACHMENT.

What is the problem?  I do not use the index RECORDID

Paul;



Attachments: error.jpg
Mon, Mar 6 2006 12:02 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Paul,

<< I use the following code to make a master detail between 2 tables. >>

You cannot use the system RecordID column in a master-detail link or with a
Locate method call.  It has to do with the fact that the RecordID column is
not surfaced as a TField object.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image