DBGrid component using ORACLE

Thread View: borland.public.cppbuilder.database.multi-tier

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Arie Gleizer Mon, 29 May 2000 00:00

#1060

Author: Arie Gleizer
Date: Mon, 29 May 2000 00:00

20 lines
1229 bytes

While working in C++Builder, version 4, we encountered
a problem in DBGrid component using ORACLE database.

The essence of the problem is:

If a number of lines in the DBGrid substantially
exceeds the visible number of the lines on the screen,
after alteration of the IndexName of one of the Key-Field
of the corresponding table, we watch the following confusing picture:

if  we try to move the selected string of the DBGrid to the end
of the list by  using  the right scroll-bar,
we see instead of the last line the line before the last one.

In case we use  the keyboard down the screen, this doesn't  occur.

Neither it occurs, when we use PARADOX database.

 We  would  kindly ask your urgent assistant !!!

Re: DBGrid component using ORACLE

#1063

Author: Mark Cashman (TeamB)
Date: Tue, 30 May 2000 00:00

17 lines
1264 bytes

Hi, Arie!

If you are populating the grid from a TQuery-based component, are you
closing and reopening the query? If not, do so. If you are using a
TTable-based component, consider switching to TQuery, because TTable has
ruinous network overhead, and may be the cause of your anomaly.

If the above doesn't work, try setting the DataSource property of the
grid to NULL prior to the change, and connecting the DataSource after
the change.

------
Mark Cashman, TeamB C++ Builder
http://www.temporaldoorway.com/programming/index.htm
C++ Builder, JBuilder programming information
Home of The C++ Builder Programmer's Webring - Join us!
------

Re: DBGrid component using ORACLE

#1070

Author: Relu Botinant
Date: Sun, 04 Jun 2000 00:00

84 lines
2561 bytes

Hi

I have a lot of problems with BCB and Oracle.
I worked with all BCB versions and I still canot work with Oracle.

I built a VERY small application which uses master-detail tables. That was
an absolute mess.

Conclusion: TTable doesn't work. I shoud say that it never worked (and I
guess that it never will). Even with Paradox and DBF's I have problems.Put,
I said then this is not a problem. I swicthed to TQuery. Everything looked
ok until:

select a.id id, a.nume proiect, b.nume furnizor
from proiecte a, finantator b
where a.id = b.proiect(+)
order by upper(proiect),upper(furnizor)

proiect contains
id      nume
===  =======
1       pr1
2       pr2

finantator contains
proiect    nume
=====   =======
1            f1
1            f2

Result:

proiect        finantator
=====       =======
pr1
pr1             f2
pr2

..... wrong !!!!!!!!   Missing f1 in first line.

The same query in SQLPLUS (I used copy-paste):

proiect        finantator
=====       =======
pr1             f1
pr1             f2
pr2

.... which is correct.

Does anyone can tell me if BCB 5.0 Enterprise can work in any way (without
such problems - without problems at all) with Oracle 8.0.5 / Oracle 8i ??

Thanks

Relu Botinant

Mark Cashman (TeamB) wrote:

> Hi, Arie!
>
> If you are populating the grid from a TQuery-based component, are you
> closing and reopening the query? If not, do so. If you are using a
> TTable-based component, consider switching to TQuery, because TTable has
> ruinous network overhead, and may be the cause of your anomaly.
>
> If the above doesn't work, try setting the DataSource property of the
> grid to NULL prior to the change, and connecting the DataSource after
> the change.
>
> ------
> Mark Cashman, TeamB C++ Builder
> http://www.temporaldoorway.com/programming/index.htm
> C++ Builder, JBuilder programming information
> Home of The C++ Builder Programmer's Webring - Join us!
> ------

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads