I have placed my BCB5 sample project and database at
http://www.mjfreelancing.com/download/IBOTest.zip

Can someone please have a look at this very simple problem.

Mal

-----Original Message-----
From: Jason Wharton [mailto:jwharton@...]
Sent: Tuesday, 20 August 2002 06:55
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Foreign key


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




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/