There is simply something confusing you here. EditSQL should have no bearing
on whether you can select data in a master-detail setup or not.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Malcolm Smith" <mjfreelancing@...>
To: "IBObjects List (E-mail)" <IBObjects@yahoogroups.com>
Sent: Monday, August 19, 2002 1:42 AM
Subject: [IBO] Foreign key


> I'm starting out with IBO.
>
> I created my first sample master-detail table today in BCB5 and was
getting
> a 'cannot use blank SQL statement' (or similar). Looking at demos I could
> not work out why.
>
> After looking at some other sources I found a sample that used an EditSQL
> statement. I could only get my application to work if I added:
>
> update GROUPS
> set
> GRP_DESCRIPTION = :GRP_DESCRIPTION
> where
> GRP_DESCRIPTION = :OLD_GRP_DESCRIPTION
>
> to the EditSQL string in my master query.
>
> Why is this ?
>
> My database is very basic and I only added the foreign key because from my
> BDE experiences I thought I needed it. It is not used for anything else
(at
> the moment). Can I get rid of it and hence the above SQL statement.
>
>
>
> Malcolm Smith
> MJ Freelancing
> ABN: 30 671 763 146
> http://www.mjfreelancing.com
>
> CORintel
> ABN: 30 336 110 329