Board index » delphi » MS SQL Server - getting read-only query with requestlive=true

Adi

Delphi Developer
Tue, 26 Jul 2005 02:02:43 GMT

MS SQL Server - getting read-only query with requestlive=true

Hello
I am using a tquery component with requestlive=true for both live results
and read-only queries.
In Paradox this works fine, but with ms sql server I get an exception and no
results.
Is there a way to disable the exception the sql server raises when the query
is read only?
 
Oliver Townshen

Delphi Developer
Wed, 27 Jul 2005 16:29:32 GMT

Re:MS SQL Server - getting read-only query with requestlive=true


Quote
> Is there a way to disable the exception the sql server raises when the
query
> is read only?

It is probably better to know when to use Requestlive, and when not, however
you could also do the following in your Open statements:

    try
        Open
    except
        on E: EDBEngineError do begin
            //you should probably check here that you have the Requestlive
error by checking E.Message
            RequestLive:=False;
            Open;
        end;
    end;

Oliver

Adi

Delphi Developer
Wed, 27 Jul 2005 19:13:43 GMT

Re:MS SQL Server - getting read-only query with requestlive=true


I use a C/S structure, the error is received at the client, so how do I set
the server's query requestlive from the client?

Quote
"Oliver Townshend" <oli...@zip.com.au> wrote in message

news:3e44c041@newsgroups.borland.com...
Quote
> > Is there a way to disable the exception the sql server raises when the
> > query is read only?

> It is probably better to know when to use Requestlive, and when not,
however
> you could also do the following in your Open statements:

>     try
>         Open
>     except
>         on E: EDBEngineError do begin
>             //you should probably check here that you have the Requestlive
> error by checking E.Message
>             RequestLive:=False;
>             Open;
>         end;
>     end;

> Oliver

Oliver Townshen

Delphi Developer
Wed, 27 Jul 2005 20:13:10 GMT

Re:MS SQL Server - getting read-only query with requestlive=true


Quote
> I use a C/S structure, the error is received at the client, so how do I
set
> the server's query requestlive from the client?

This is just a dataset property isn't it?

Oliver

Adi

Delphi Developer
Wed, 27 Jul 2005 22:16:32 GMT

Re:MS SQL Server - getting read-only query with requestlive=true


well, found a way of doing it by checking if certain words (like 'join' or
'distinct') appear in the sql.

Quote
"Oliver Townshend" <oli...@zip.com.au> wrote in message

news:3e44f4ab@newsgroups.borland.com...
Quote
> > I use a C/S structure, the error is received at the client, so how do I
> set
> > the server's query requestlive from the client?

> This is just a dataset property isn't it?

> Oliver

Other Threads

1. Requestlive and MS SQL Server

2. read-only result set when requestlive = TRUE

3. RequestLive=FALSE vs RequestLive=TRUE

4. RequestLive=TRUE vs RequestLive=FALSE

5. ADO MS-SQL locks on TempDB from read-only SQL Queries via TADOQuery

6. Delphi 5+Oracle 8i +BDE 5.11 Two query master-Detail (Requestlive=true)

7. TQuery(RequestLive=True) x TQuery.ExceSql (Update Query)

8. Getting a read/write SQL query result using a TQuery and a TTable

9. can't set RequestLive to a SQL Server SQL

10. Getting database userid from MS SQL Server, 7.0 and higher