Board index » delphi » Interbase + TQuery.recNo

:: Sébastien Roche ::

Delphi Developer
Wed, 12 May 2004 19:09:06 GMT

Interbase + TQuery.recNo

I have a problem since I've moved my Delphi 5 app from Paradox to Interbase
(v5.5.0.742 shipped with Delphi on Win2000).
The recNo property of my TQueries always return -1 !
It still works fine if I connect to Paradox instead of IB, so my queries are
OK.

Any Ideas ?

--
Seb, Webmaster Pharmespace
--------------------------
Votre portail Pharmaceutique
http://www.pharmespace.com

 
Paul Lineh

Delphi Developer
Thu, 13 May 2004 02:01:42 GMT

Re:Interbase + TQuery.recNo


":: Sbastien Roche ::" <webmas...@pharmespace.com> wrote:

Quote
> I have a problem since I've moved my Delphi 5 app from Paradox to Interbase
> (v5.5.0.742 shipped with Delphi on Win2000).
> The recNo property of my TQueries always return -1 !
> It still works fine if I connect to Paradox instead of IB, so my queries are
> OK.
> Any Ideas ?

Cher Sbastien,

Va plutot aux groupes borland - "newsgroups.borland.com" pour toutes
tes questions sur Interbase.

Il me semble, cependant, que 5.5 n'est pas stable et tu devrais
chercher 5.6 (gratos pour ceux qui ont 5.5 a ce que je sache).

Je pense que le proprit recNo n'est pas valable pour une base de
donnes client/serveur.

Sinceres salutations de Dublin.

Paul...

Quote
> Seb, Webmaster Pharmespace

--
Paul Linehan

plinehan at yahoo dot com/linehanp at tcd dot ie

I drink to keep body and
soul apart - O. Wilde.

"Mens sana in campari soda" - anon.

Paul Lineh

Delphi Developer
Thu, 13 May 2004 02:07:17 GMT

Re:Interbase + TQuery.recNo


Quote
lineh...@tcd.ie (Paul Linehan) wrote:
> ":: Sbastien Roche ::" <webmas...@pharmespace.com> wrote:
> Il me semble, cependant, que 5.5 n'est pas stable et tu devrais
> chercher 5.6 (gratos pour ceux qui ont 5.5 a ce que je sache).

Va voir www.ibphoenix.com pour la version ouverte d'Interbase 6 avec
source et completement gratuit.

Paul...

Quote
> Paul...

--
Paul Linehan

plinehan at yahoo dot com/linehanp at tcd dot ie

I drink to keep body and
soul apart - O. Wilde.

"Mens sana in campari soda" - anon.

peter

Delphi Developer
Thu, 13 May 2004 13:46:41 GMT

Re:Interbase + TQuery.recNo


Quote
Paul Linehan <lineh...@tcd.ie> wrote in message

news:3bffdfb0.22963930@news.tcd.ie...

Quote

> ":: Sbastien Roche ::" <webmas...@pharmespace.com> wrote:

> > I have a problem since I've moved my Delphi 5 app from Paradox to
Interbase
> > (v5.5.0.742 shipped with Delphi on Win2000).
> > The recNo property of my TQueries always return -1 !
> > It still works fine if I connect to Paradox instead of IB, so my
queries are
> > OK.

> > Any Ideas ?
> Je pense que le proprit recNo n'est pas valable pour une base de
> donnes client/serveur.

Yes, quite correct (and I can figure out the french).

Peter Reber

Sundial Service

Delphi Developer
Fri, 14 May 2004 01:04:00 GMT

Re:Interbase + TQuery.recNo


A client/server database has no notion of a "record number."  

So when the database connected-to is client/server of any kind, the
record-number property will return "-1."

Also:  a client/server database has can return the rows to you in any
order, unless you specify ORDER BY.  This is quite a bit different from,
say, Paradox or dBase.

Quote
peterr wrote:

> Paul Linehan <lineh...@tcd.ie> wrote in message
> news:3bffdfb0.22963930@news.tcd.ie...

> > ":: Sbastien Roche ::" <webmas...@pharmespace.com> wrote:

> > > I have a problem since I've moved my Delphi 5 app from Paradox to
> Interbase
> > > (v5.5.0.742 shipped with Delphi on Win2000).
> > > The recNo property of my TQueries always return -1 !
> > > It still works fine if I connect to Paradox instead of IB, so my
> queries are
> > > OK.

> > > Any Ideas ?

> > Je pense que le proprit recNo n'est pas valable pour une base de
> > donnes client/serveur.

> Yes, quite correct (and I can figure out the french).

> Peter Reber

--
----------------------------------------------------------------
Sundial Services :: Scottsdale, AZ (USA) :: (480) 946-8259
mailto:i...@sundialservices.com  (PGP public key available.)

- Show quoted text -

Quote
> Fast(!), automatic table-repair with two clicks of the mouse!
> ChimneySweep(R):  Release 4.0 is here!!
> http://www.sundialservices.com/products/chimneysweep

:: Sébastien Roche :

Delphi Developer
Fri, 14 May 2004 04:49:48 GMT

Re:Interbase + TQuery.recNo


[Sundial Services <info_...@sundialservices.com>] a crit:

Quote
> A client/server database has no notion of a "record number."  

> So when the database connected-to is client/server of any kind, the
> record-number property will return "-1."

> Also:  a client/server database has can return the rows to you in any
> order, unless you specify ORDER BY.  This is quite a bit different from,
> say, Paradox or dBase.

Thanks to all...

I got this answer after I posted here... and I'm OK with that.

My trouble was that it used to work with Paradox and stop working only by
selecting the BDE Alias with IB.

--
Seb, Webmaster Pharmespace
--------------------------
Votre portail Pharmaceutique
http://www.pharmespace.com

Other Threads

1. property TQuery.RecNo always return -1

2. TQuery.Recno always -1

3. : TQuery RecNo & RecordCount

4. QUESTION : Finding the REAL RecNo in a TQUERY.

5. RecNo in TQuery?

6. TQuery and RecNo

7. TQuery recno value in runtime

8. tquery recno problem

9. TQuery.RecNo with MS Access 97

10. Getting invalid recno in tquery