| Subject | RE: [IBO] Foreign key |
|---|---|
| Author | Malcolm Smith |
| Post date | 2002-08-20T00:48:17Z |
One last thing. After I add a new record in a grid I would like the record
to be committed and the contents of the grid refreshed.
* Which properties deal with post / commit (I don't see separate buttons on
the bars so I don't know when the data is being posted compared to being
committed.
* Which properties deal with refreshing the grid after a commit.
I have set the CommitAction to caRefresh on my query but the data is not
reflected - is there a transaction mode I need to change?
Malcolm Smith
MJ Freelancing
ABN: 30 671 763 146
http://www.mjfreelancing.com
CORintel
ABN: 30 336 110 329
-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Tuesday, 20 August 2002 10:06
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Foreign key
At 07:50 AM 20-08-02 +1000, you wrote:
Looking at your DFM (I don't have BCCPB) I see that you include the FOR
UPDATE clause in the select queries. Try removing that, and your EditSQL
sentence, and see whether it then works. Apart from that the setup looks
right.
Try explicitly listing the columns you want in the sets, rather than using
select *. This is a rule I recommend and follow, since it makes your app
easier to troubleshoot and maintain. (All data in IBO "boils down" to
TIB_Column).
Also, you don't need all those bars. If you set the property ReceiveFocus
to true on a Bar component, then the bar will operate on whichever dataset
has the focus...not that superfluous bar comps should cause any
problems...but it's just a thought that the extra bar comps might be
stepping on the masterlinking in some way.
Another possibility might be that the Keylinks in the detail set don't
uniquely identify a row. Is there any chance of that? Or that the linking
keys are somehow mismatched, e.g. by type, size or case?
Is it possible that your app is forgetting to open the detail set...?
Have you tested the two datasets in IB_SQL in a joined query, to see
whether the master keys actually find the foreign keys in the detail?
You don't say what database version you are using. If it's IB 6.x or
Firebird, could there be some quoted identifiers in there that you
overlooked?
Helen
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/
to be committed and the contents of the grid refreshed.
* Which properties deal with post / commit (I don't see separate buttons on
the bars so I don't know when the data is being posted compared to being
committed.
* Which properties deal with refreshing the grid after a commit.
I have set the CommitAction to caRefresh on my query but the data is not
reflected - is there a transaction mode I need to change?
Malcolm Smith
MJ Freelancing
ABN: 30 671 763 146
http://www.mjfreelancing.com
CORintel
ABN: 30 336 110 329
-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Tuesday, 20 August 2002 10:06
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Foreign key
At 07:50 AM 20-08-02 +1000, you wrote:
>I have placed my BCB5 sample project and database atSome suggestions:
>http://www.mjfreelancing.com/download/IBOTest.zip
>
>Can someone please have a look at this very simple problem.
>
>Mal
Looking at your DFM (I don't have BCCPB) I see that you include the FOR
UPDATE clause in the select queries. Try removing that, and your EditSQL
sentence, and see whether it then works. Apart from that the setup looks
right.
Try explicitly listing the columns you want in the sets, rather than using
select *. This is a rule I recommend and follow, since it makes your app
easier to troubleshoot and maintain. (All data in IBO "boils down" to
TIB_Column).
Also, you don't need all those bars. If you set the property ReceiveFocus
to true on a Bar component, then the bar will operate on whichever dataset
has the focus...not that superfluous bar comps should cause any
problems...but it's just a thought that the extra bar comps might be
stepping on the masterlinking in some way.
Another possibility might be that the Keylinks in the detail set don't
uniquely identify a row. Is there any chance of that? Or that the linking
keys are somehow mismatched, e.g. by type, size or case?
Is it possible that your app is forgetting to open the detail set...?
Have you tested the two datasets in IB_SQL in a joined query, to see
whether the master keys actually find the foreign keys in the detail?
You don't say what database version you are using. If it's IB 6.x or
Firebird, could there be some quoted identifiers in there that you
overlooked?
Helen
>-----Original Message-----bearing
>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
>on whether you can select data in a master-detail setup or not.could
>
>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
> > not work out why.EditSQL
> >
> > After looking at some other sources I found a sample that used an
> > statement. I could only get my application to work if I added:my
> >
> > 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
> > BDE experiences I thought I needed it. It is not used for anything elsepapers,
>(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
>keyword-searchable FAQ, community code contributions and more !papers,
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>___________________________________________________________________________
>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
>keyword-searchable FAQ, community code contributions and more !___________________________________________________________________________
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
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/