Board index » delphi » Can I use TTable with Oracle?

Can I use TTable with Oracle?

I would like to use TTable component with an oracle database, or
do I relly have to learn myself SQL?

Could you recommend a good book for delphi database programming.
I have some programming experience (ASM, OOP pascal, c++)

I would be gratefull to hear your opinion.

Vesa

--
Vesa Suontama            
address:                                mail:                  
Harakkamyllyntie 18                     vsuon...@snakemail.hut.fi
00920 Helsinki Finland                  phone:3492062

 

Re:Can I use TTable with Oracle?


vsuon...@niksula.hut.fi (Vesa M Suontama) wrote:

Quote

> I would like to use TTable component with an oracle database, or
> do I relly have to learn myself SQL?

> Could you recommend a good book for delphi database programming.
> I have some programming experience (ASM, OOP pascal, c++)

> I would be gratefull to hear your opinion.

The general advice for getting infromation from an Oracle DB (and any
true SQL-server) is to use TQueries, because by doing that, you have
full control over the SQL-statements issued and possible optimization
of them.

With your experience of Assembler, Object Pascal and C++, learning SQL
should be a piece of cake (but learning to master all features of
Oracle's DB is another story...). In fact, the best books to start
with SQL are, imho, Oracle's own SQL reference and quick reference,
plus the sql online reference coming with Interbase.

Jasper

PS: please take into consideration
- when replying, I just think I know;
- when asking, be sure that I don't.

Re:Can I use TTable with Oracle?


vsuon...@niksula.hut.fi (Vesa M Suontama) wrote:

Quote

> I would like to use TTable component with an oracle database, or
> do I relly have to learn myself SQL?

No you don't have to learn SQL, but in the end you'll probably
end up learning it.  While you can use TTable's with Oracle you'll
often (I'm not going to say always) pay a price in performance and
efficiency.  The Oracle RDBMS just doesn't function the way the
Paradox engine does  ;-)  Just bring up SQL Monitor (should be
on your Database Menu) and watch what happens when you start
playing with that TTable!

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Chris Kasten
Programmer/Analyst

#include <std/disclaimer.h>
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Other Threads