Board index » delphi » Live result set - MS SQL 6.0

Live result set - MS SQL 6.0

I have a TQUERY with the following SQL statement :

Select * from Articles
Where number = 1184

If a want a LIVE RESULT SET I get the error

  OBJECT NOT FOUND.

When I use the QUERY without the WHERE clause it works fine.

Do you have the solution ?

--
Peter De Ranter

Pete...@Glo.be
http://shell.glo.be/~peterdr

 

Re:Live result set - MS SQL 6.0


Try to use the visual query builder and see the syntax of it's SQL output.

I've found MSSQL to be very funny about specifying the FROM clause for live
result sets.  Try replacing your Articles FROM clause to "dbo.Articles"
(including the quotes, dbo is the default owner)

Try this :
SELECT *
FROM "dbo.Articles" Art
WHERE (Art.Number = 1184)

Hope this helps, Merry Christmas !
Mark

Peter De Ranter <Pete...@glo.be> wrote in article <32BEF6C7....@glo.be>...

Quote
> I have a TQUERY with the following SQL statement :

> Select * from Articles
> Where number = 1184

> If a want a LIVE RESULT SET I get the error

>   OBJECT NOT FOUND.

> When I use the QUERY without the WHERE clause it works fine.

> Do you have the solution ?

> --
> Peter De Ranter

> Pete...@Glo.be
> http://shell.glo.be/~peterdr

Re:Live result set - MS SQL 6.0


Quote
Mark Pattison wrote:

> result sets.  Try replacing your Articles FROM clause to "dbo.Articles"
> (including the quotes, dbo is the default owner)

> Try this :
> SELECT *
> FROM "dbo.Articles" Art
> WHERE (Art.Number = 1184)

> Hope this helps, Merry Christmas !
> Mark

Thanks for the tip, but : No cure :-(
But  a Happy Newyear to !!

Quote

> Peter De Ranter <Pete...@glo.be> wrote in article <32BEF6C7....@glo.be>...
> > I have a TQUERY with the following SQL statement :

> > Select * from Articles
> > Where number = 1184

> > If a want a LIVE RESULT SET I get the error

> >   OBJECT NOT FOUND.

> > When I use the QUERY without the WHERE clause it works fine.

> > Do you have the solution ?

> > --

--
Peter De Ranter

Pete...@Glo.be
http://shell.glo.be/~peterdr

11111111111111111111111111111111
11111111111111111111111111111
11111111111111111111111111111111
11111111111111111111111111111
11111111111111111111111111111111
11111111111111111111111111111
11111111111111111111111111111111
11111111111111111111111111111
11111111111111111111111111111111
11111111111111111111111111111
11111111111111111111111111111111
11111111111111111111111111111
11111111111111111111111111111111
11111111111111111111111111111
11111111111111111111111111111111
11111111111111111111111111111
L%11111111111111111111111111111111
11111111111111111111111111111
11111111111111111111111111111111
11111111111111111111111111111
11111111111111111111111111111111
11111111111111111111111111111
.11111111111111111111111111111111
11111111111111111111111111111
11111111111111111111111111111111
11111111111111111111111111111
11111111111111111111111111111111
11111111111111111111111111111

Re:Live result set - MS SQL 6.0


Quote
Mark Pattison wrote:

> result sets.  Try replacing your Articles FROM clause to "dbo.Articles"
> (including the quotes, dbo is the default owner)

> Try this :
> SELECT *
> FROM "dbo.Articles" Art
> WHERE (Art.Number = 1184)

> Hope this helps, Merry Christmas !
> Mark

Thanks for the tip, but : No cure :-(
But  a Happy Newyear to !!

Quote

> Peter De Ranter <Pete...@glo.be> wrote in article <32BEF6C7....@glo.be>...
> > I have a TQUERY with the following SQL statement :

> > Select * from Articles
> > Where number = 1184

> > If a want a LIVE RESULT SET I get the error

> >   OBJECT NOT FOUND.

> > When I use the QUERY without the WHERE clause it works fine.

> > Do you have the solution ?

> > --

--
Peter De Ranter

Pete...@Glo.be
http://shell.glo.be/~peterdr

11111111111111111111111111111111
11111111111111111111111111111
11111111111111111111111111111111
11111111111111111111111111111
11111111111111111111111111111111
11111111111111111111111111111
11111111111111111111111111111111
11111111111111111111111111111
11111111111111111111111111111111
11111111111111111111111111111
11111111111111111111111111111111
11111111111111111111111111111
11111111111111111111111111111111
11111111111111111111111111111
11111111111111111111111111111111
11111111111111111111111111111
L%11111111111111111111111111111111
11111111111111111111111111111
11111111111111111111111111111111
11111111111111111111111111111
11111111111111111111111111111111
11111111111111111111111111111
.11111111111111111111111111111111
11111111111111111111111111111
11111111111111111111111111111111
11111111111111111111111111111
11111111111111111111111111111111
11111111111111111111111111111

Other Threads