BorlandTalk.com

Raul Trasvina · Guest

Hi, I am starting using MS-SQL Server with delphi I have just programmed
using Paradox and DBase Tables using TDataSet, so from now I would be here
for some time.

Well, my first question is which is the most simple way to handle this
MS-SQL table.

(I have no problem using MS-SQL Coporative, and SQL Query Manager, I maen I
can create databases, tables, etc).

I think it could be using ADO am I right ?

Is this the more natural way to handle this kind of Database ?

I don't want to use MIDAS and some other multi-tier squeme, I just want to
use Client-Server squeme.

Does anybody know a link to some sample using MS-SQL. My other question is,
lets suposses the table that result from a query has two thousand million of
rows, and you are using a Client that was connected to a server using
internet. You want to browse this table, but want to see teen rows at one
time, the question is , is it posible in delphi or with some special
omponent (I mean that not comes with delphi original components set) to
browse the table with out wait the server sends the two thousnad rows, If I
have to do it manually making anothers sql query to bring the table by
parts, my question is I have to make my own dataset so when the user want to
go to the end of the table (TDataset.last) I execute the sql query that get
that part of the table. It could seems I put the question and the answer or
posible answer, by example probably overrinding the TDataset I could browse
a Big Table in a remote server, But It may not be the more used way to doit.

So my questions are :

1.- Which components I must use to start using MS-SQL,
ADOConnection,ADODataset,ClientDataSet or which.

Which Connection and Which Dataset.

2.- Which is the more natural way to handle Big Tables in a Remote MS SQL
Server.

I would aprecciate any help, thank you.

Hanefi TEL · Guest

Hi...

I am also in the same situation. I will use MS-SQL but i do not know
which components are the best for ms-sql. I do not want to use ODBC. I need
components that they can access the database directly within delphi.
Thanks in advance...
"Crazy Horse's crazier little brother" <cshannon (AT) d4sw (DOT) com> wrote

Lee-Z · Guest

ADO works really well with MSSQL, you can use the components on Delphi's ADO
toolbar for connections and datasets....

Super easy deployment: just give the client the executable (and optionally
an UDL file if you want to use that for the connection) and Bob's your uncle
Surprised

)
No more BDE installations!!!!

(by the way ADO 2.6 has some trouble with triggers in MsSql...but ADO 2.5 or
2.7 (and up) are just fine)

regards,

Lee-Z

"Hanefi TEL" <mhanefi (AT) yahoo (DOT) com> wrote

Kevin Frevert · Guest

"Lee-Z" <Lee-Z.spam (AT) zonnet (DOT) nl> wrote

Lee-Z · Guest

Well, if you made a sloppy trigger like me Surprised

)

I use triggers (SQL 7) because cascade updates don't work with constraints;
and so I use triggers too to prevent updates when parent record doesn't
exist....than the triggers gives a message ("Parent doesn't exist")

this message appeared to be a problem for D5 application with ADO 2.6
installed (application didn't return message from trigger, but some weirdo
message)

ofcourse, when I neatly put SET NOCOUNT ON in the trigger everything goes
well, but ADO 2.5 (en 2.7 en over didn't have the same problem....)

so I'm a bit anti-ADO 2.6

:o)

greets, Lee-Z

"Kevin Frevert" <drinkingdietcoke (AT) work (DOT) com> wrote

Kevin Frevert · Guest

"Lee-Z" <Lee-Z.spam (AT) zonnet (DOT) nl> wrote