Embedded SQL???

Javier Lacla

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Embedded SQL???

Hi!

We have Delphi 3.02 C/S and we would like to work with InterBase.
We are going to write batch programs to update a lot of rows
of many tables.
The question is: Which is the best way to do it?
We are looking for embedded SQL with a preproccesor or something like
that.
Can anybody help us?.

We appreciate.

Thanks in advance.

Javier.

Boutwell, Georg

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Embedded SQL???

Javier,

Interbase does come with I embedded SQL preproccessor. It's a
commandline utility installed in the Bin directory.

Quote

Javier Laclau wrote:

> Hi!

> We have Delphi 3.02 C/S and we would like to work with InterBase.
> We are going to write batch programs to update a lot of rows
> of many tables.
> The question is: Which is the best way to do it?
> We are looking for embedded SQL with a preproccesor or something like
> that.
> Can anybody help us?.

> We appreciate.

> Thanks in advance.

> Javier.

Team

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Embedded SQL???

Quote

Javier Laclau wrote:

> Hi!

> We have Delphi 3.02 C/S and we would like to work with InterBase.
> We are going to write batch programs to update a lot of rows
> of many tables.
> The question is: Which is the best way to do it?
> We are looking for embedded SQL with a preproccesor or something like
> that.
> Can anybody help us?.

Use a Stored Procedure on your server to do the work. It will be faster
than almost anything else by a wide margin.

InterBase does not have a preprocess that supports Delphi only
pascal....

Robert Schieck
------------------------------------------------------------
MER Systems Inc. voice - 416-410-5166 1-888-MER-TRAIN
fax - 416-410-5167
------------------------------------------------------------
Master Certified Delphi 3 Instructor
Master Certified C++ Builder Instructor
Master Certified JBuilder Instructor
http://www.mers.com
rschi...@mers.com

Javier Lacla

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Embedded SQL???

Hi George, hi all.

Thanks, but we wonder if that preprocessor can be used with delphi
units; because we are working with Delphi (3.02 C/S).
We go on looking for an embedded SQL preprocessor that works with
Delphi.

We can not believe that we must work with C/C++.

If we are wrong, please, tell us.

Javier.

Quote

Boutwell, George wrote:

> Javier,

> Interbase does come with I embedded SQL preproccessor. It's a
> commandline utility installed in the Bin directory.

> Javier Laclau wrote:

> > Hi!

> > We have Delphi 3.02 C/S and we would like to work with InterBase.
> > We are going to write batch programs to update a lot of rows
> > of many tables.
> > The question is: Which is the best way to do it?
> > We are looking for embedded SQL with a preproccesor or something like
> > that.
> > Can anybody help us?.

> > We appreciate.

> > Thanks in advance.

> > Javier.

Javier Lacla

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Embedded SQL???

Hi Robert,

We know about stored procedures, we have had bad experiences with them,
for example because they are not "standard" like SQL is.

We are looking for another solution without using stored procedures.

Thanks.

Javier.

Quote

Robert Schieck (TeamB) wrote:

> Javier Laclau wrote:

> > Hi!

> > We have Delphi 3.02 C/S and we would like to work with InterBase.
> > We are going to write batch programs to update a lot of rows
> > of many tables.
> > The question is: Which is the best way to do it?
> > We are looking for embedded SQL with a preproccesor or something like
> > that.
> > Can anybody help us?.

> Use a Stored Procedure on your server to do the work. It will be faster
> than almost anything else by a wide margin.

> InterBase does not have a preprocess that supports Delphi only
> pascal....

> --

> Robert Schieck
> ------------------------------------------------------------
> MER Systems Inc. voice - 416-410-5166 1-888-MER-TRAIN
> fax - 416-410-5167
> ------------------------------------------------------------
> Master Certified Delphi 3 Instructor
> Master Certified C++ Builder Instructor
> Master Certified JBuilder Instructor
> http://www.mers.com
> rschi...@mers.com

Other Threads

1. HELP!! Using Embedded SQL with Interbase Local Server

2. Embedded SQL & StoredProcs

3. Embed SQL program compiling,how?

4. Embedded SQL...

5. Is prepared statement only for Embedded SQL?

6. How to use Embedded SQL in Delphi 3

7. embedded sql in c++builder project

8. Embedded SQL + C++Builder: the easy way

9. Embedded SQL 3rd party tool DataBase

10. Sybase Adaptive Server and embedded SQL