ADO MS SQL

Post Reply
Jack
Posts: 249
Joined: Wed Jul 11, 2007 11:06 am

ADO MS SQL

Post by Jack »

I use sql and ado to talk to a database on MS Sql Server
I need some info :
I need an instruction to put in a array the name of all the tables (files) located in one database .

For a table, i want to know the number of records .

I also want to know the number of fields, name of fields , type ans size .

How to with ado syntax ?

Thanks
Ph Jacquet (Belgium)
User avatar
Adolfo
Posts: 815
Joined: Tue Oct 11, 2005 11:57 am
Location: Chile
Contact:

Post by Adolfo »

JACK

Take a look at my CLASS, "ADOBASE".
There you have all you want to do.
There's an exe with its source code, and the class.

Download it from
http://200.72.140.34/privado

The file is ADOBASE.RAR

From Chile
Adolfo
;-) Ji,ji,ji... buena la cosa... "all you need is code"

http://www.xdata.cl - Desarrollo Inteligente
----------
Lenovo Legion Y520, 16GB Ram, 1 TB NVME M.2, 1 TB SSD, GTX 1050
User avatar
fafi
Posts: 169
Joined: Mon Feb 25, 2008 2:42 am

Post by fafi »

Yes I used it, nice :D

Thanks Adolfo

regards
Fafi
Post Reply