Board index » delphi » RecNo with MSSQL Server 6.5 and 7.0

David Roberge

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

RecNo with MSSQL Server 6.5 and 7.0

Is there a way to make RecNo work with SLQ Server using a TQuery or a
TTable....
HELP ME PLEASE!

--
David Roberge
Analyste/Programmeur
Micropro Novunix Lte
(819) 346-7000 tel
(819) 346-2215 fax

 
Brian Jone

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

Re:RecNo with MSSQL Server 6.5 and 7.0


No. This is for Parado only. To simulate a recno in proper SQL you need to
use an auto increment field, but even then it will not behave the same way.
I'm afraid you will need to change you approach from desktop to
client/server.

--
Adroit Software Ltd
------------------------------
Remove the nospam. to mail me direct

Quote
David Roberge <vt...@micropro.ca> wrote in message

news:7p9mmi$pe314@forums.borland.com...
Quote
> Is there a way to make RecNo work with SLQ Server using a TQuery or a
> TTable....
> HELP ME PLEASE!

> --
> David Roberge
> Analyste/Programmeur
> Micropro Novunix Lte
> (819) 346-7000 tel
> (819) 346-2215 fax

Gerrit Moelle

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

Re:RecNo with MSSQL Server 6.5 and 7.0


Yes, use my Components, and you will have Recno for all situations (table,
query, ...)

For SQL Sevrver you will need to connect via ODBC (either DAO or ADO).

www.gm-software.de

John Hai

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

Re:RecNo with MSSQL Server 6.5 and 7.0


Quote
>I'm afraid you will need to change you approach from desktop to
>client/server.

That's not entirely true.
I have created a TDataSet descendant that supports RecNo and RecordCount by
caching the results in memory (basically like an in-memory table).
You could do the same for TQuery and TStoredProc, although it is quite a bit
of work and will slow down the retrieval of your result sets.

Cheers
John Hair
Designer Systems Ltd

Tomislav Kard

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

Re:RecNo with MSSQL Server 6.5 and 7.0


Hi John!

On Tue, 17 Aug 1999 15:11:18 +0100, "John Hair"

Quote
<jo...@kinetic-solutions.co.uk> wrote:
>I have created a TDataSet descendant that supports RecNo and RecordCount by
>caching the results in memory (basically like an in-memory table).
>You could do the same for TQuery and TStoredProc, although it is quite a bit
>of work and will slow down the retrieval of your result sets.

As for the RecNo it's clear they could implement it because as you
move down the dataset you just have to count records and records
itself are cached in memory while once fetched so I realy do not see
any reason why delphi could not implement RecNo in a TQuery component
- at least in some situations (that are all situations that I use).

tomi.

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

Re:RecNo with MSSQL Server 6.5 and 7.0


Efren Abell

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

Re:RecNo with MSSQL Server 6.5 and 7.0


Help pls.

I just want to fill my TDBGrid column with RecNo.
Pls post if you have procedure
thanks

Quote
Tomislav Karda? wrote in message <37bd6efe.113708...@forums.inprise.com>...
>Hi John!

>On Tue, 17 Aug 1999 15:11:18 +0100, "John Hair"
><jo...@kinetic-solutions.co.uk> wrote:

>>I have created a TDataSet descendant that supports RecNo and RecordCount
by
>>caching the results in memory (basically like an in-memory table).
>>You could do the same for TQuery and TStoredProc, although it is quite a
bit
>>of work and will slow down the retrieval of your result sets.

>As for the RecNo it's clear they could implement it because as you
>move down the dataset you just have to count records and records
>itself are cached in memory while once fetched so I realy do not see
>any reason why delphi could not implement RecNo in a TQuery component
>- at least in some situations (that are all situations that I use).

>tomi.

Other Threads

1. Anybody can answer question on MsSql Server 6.5 Vs. 7.0

2. MSSQL 7.0 x MSSQL 6.5 (Inserted, Deleted)

3. Cursors in MSSQL 7.0 vs 6.5

4. Upgrading MSSQL 6.5 to 7.0 - TStoredProc problem!

5. Tables in SQL Server 6.5 and 7.0

6. SQL Server 6.5 SR2 and 7.0

7. SQL-Server 7.0 much slower than 6.5 with BDE

8. SQL Server 7.0 versus 6.5 index selection (poor performance)

9. Callback messages from MSSQL server 6.5 - Help please

10. Migrating a Delphi 3 - Paradox c/s app to MSSQL Server 6.5