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