Board index » delphi » Executing SQL-Statements serial

Sven Weiberg

Delphi Developer
Fri, 17 Oct 2003 22:33:37 GMT

Executing SQL-Statements serial

Sorry! I forgot to specify the server! It's MS SQLSERVER 2000.

Hi!
Is there a way to ensure that a defined block of sql-statements(e.g.
Returning an integer field and then increasing its value) are executed
strictly one after another on the server!
Would be pleased about some hints

Sven

 
accma

Delphi Developer
Sun, 19 Oct 2003 11:28:36 GMT

Re:Executing SQL-Statements serial


Put them in a proc.
But I also believe that they would be executed serially anyway.

Quote
"Sven Weiberg" <sweib...@hitchhiker.com> wrote in message

news:3aed7816_2@dnews...
Quote
> Sorry! I forgot to specify the server! It's MS SQLSERVER 2000.

> Hi!
> Is there a way to ensure that a defined block of sql-statements(e.g.
> Returning an integer field and then increasing its value) are executed
> strictly one after another on the server!
> Would be pleased about some hints

> Sven

Sunil Furtad

Delphi Developer
Sun, 19 Oct 2003 13:29:05 GMT

Re:Executing SQL-Statements serial


    Not sure what you want but if you are looking at generating a value from
a seed table, take a look at this procedure.

CREATE PROCEDURE generatekey
@tablename char(20),
@resultval integer OUTPUT
 AS
 update keys set @resultval=keyvalue=keyvalue+1
    where tablename=@tablename

return
--
Sunil Furtado
New Mangalore Port Trust

Quote
Sven Weiberg <sweib...@hitchhiker.com> wrote in message

news:3aed7816_2@dnews...
Quote
> Sorry! I forgot to specify the server! It's MS SQLSERVER 2000.

> Hi!
> Is there a way to ensure that a defined block of sql-statements(e.g.
> Returning an integer field and then increasing its value) are executed
> strictly one after another on the server!
> Would be pleased about some hints

> Sven

Other Threads

1. Executing SQL Commands serial

2. SQL statement vs Delphi Code: Which is executes fastest

3. execute SQL statement

4. Several SQL Statements In one TADOConnection.Execute

5. Access violation executing a Sql statement

6. re-executing the sql-statement

7. Retrieve SQL Statement after execute

8. Building and executing a SQL Statement

9. Executing Select stored procedures in a SQL statement

10. Looking for Component executing more than one SQL Statement