Board index » delphi » TUpdateSQL and Stored Procedures on SQL Server 6.5

Greg Dameron

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

TUpdateSQL and Stored Procedures on SQL Server 6.5

Does anyone know if there is a way where I can call SQL Server 6.5
stored procedures from the TUpdateSQL Insert, Modify, and Delete
properties?  I have a ton of Stored Procedures already in the DB but I
need to use the TUpdateSQL due to the read only dataset thing.  I am
also looking into getting into a DCOM implementation.

Greg

 
Mikael Nilsso

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:TUpdateSQL and Stored Procedures on SQL Server 6.5


I have the same problem. I only want to use Stored Procs.
I haven't solved it yet. But i think you should use OnUpdateRecord event
insted of TUpdateSql. TUpdateSql sems to use dynamic SQL and
i dont like that.

Greg Dameron skrev i meddelandet <35D84667.FEB93...@authentix.net>...

Quote
>Does anyone know if there is a way where I can call SQL Server 6.5
>stored procedures from the TUpdateSQL Insert, Modify, and Delete
>properties?  I have a ton of Stored Procedures already in the DB but I
>need to use the TUpdateSQL due to the read only dataset thing.  I am
>also looking into getting into a DCOM implementation.

>Greg

Simon Thomps

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:TUpdateSQL and Stored Procedures on SQL Server 6.5


On Tue, 18 Aug 1998 18:56:27, "Mikael Nilsson"

Quote
<mikael.nils...@infodata.sema.se> wrote:
> I have the same problem. I only want to use Stored Procs.
> I haven't solved it yet. But i think you should use OnUpdateRecord event
> insted of TUpdateSql. TUpdateSql sems to use dynamic SQL and
> i dont like that.

I think you will find that you can call stored procedures from
TUpdateSQL. You will have to write the code for each action yourself.

I think (as I have not tried it) the syntax is:
  execute procedure xyz

-----------------------------------------
Simon Thompson
Christchurch
New Zealand

Jim Jackso

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:TUpdateSQL and Stored Procedures on SQL Server 6.5


Quote
Greg Dameron wrote:
> Does anyone know if there is a way where I can call SQL Server 6.5
> stored procedures from the TUpdateSQL Insert, Modify, and Delete
> properties?  I have a ton of Stored Procedures already in the DB but I
> need to use the TUpdateSQL due to the read only dataset thing.  I am
> also looking into getting into a DCOM implementation.

> Greg

  I have the same problem with Sybase. What is the best method if you are
only using Stored Procs and you don't want to populate all your windows
controls manually (bad not RAD)?
Thanks,
Jim
Peter Leitc

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:TUpdateSQL and Stored Procedures on SQL Server 6.5


Why not just replace the SQL text it generates via the editor (double
click on the UpdateSQL component) with the stored procedure you want to
use?  ie: exec sp_myproc :value1, :value2, :old_value3 ...
Quote
Greg Dameron wrote:
> Does anyone know if there is a way where I can call SQL Server 6.5
> stored procedures from the TUpdateSQL Insert, Modify, and Delete
> properties?  I have a ton of Stored Procedures already in the DB but I
> need to use the TUpdateSQL due to the read only dataset thing.  I am
> also looking into getting into a DCOM implementation.

> Greg

Philip Ca

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:TUpdateSQL and Stored Procedures on SQL Server 6.5


Why not use the TStoredProc component instead of TUpdateSQL?

Phil Cain

Quote
Jim Jackson <jackso...@ghc.ord> wrote:

>Greg Dameron wrote:

>> Does anyone know if there is a way where I can call SQL Server 6.5
>> stored procedures from the TUpdateSQL Insert, Modify, and Delete
>> properties?  I have a ton of Stored Procedures already in the DB but I
>> need to use the TUpdateSQL due to the read only dataset thing.  I am
>> also looking into getting into a DCOM implementation.

>> Greg

>  I have the same problem with Sybase. What is the best method if you are
>only using Stored Procs and you don't want to populate all your windows
>controls manually (bad not RAD)?
>Thanks,
>Jim

Other Threads

1. Stored Procedure MS Sql Server 6.5 and Delphi 2.0

2. Missing Records with Stored Procedures and SQL Server 6.5

3. Error Stored Procedure (SQL server 6.5)

4. Exectuting a Stored procedure within delphi - SQL SERVER 6.5 - I NEED SOME HELP

5. MS SQL Server 6.5, Stored Procedures, Temp Tables and Delphi 4 C/S

6. SQL Server 6.5 and Views & Store Procedures

7. Delphi TUpdateSQL object against SQL Server 6.5 db

8. TUpdateSQL and defaults on MS SQL Server 6.5

9. Calling a stored procedure in another stored procedure in SQL Server 7.0

10. stored procedure with MS SQL 6.5