ADO MS SQL

ADO MS SQL

Postby Jack » Fri May 09, 2008 7:51 am

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)
Jack
 
Posts: 288
Joined: Wed Jul 11, 2007 11:06 am

Postby Adolfo » Fri May 09, 2008 12:22 pm

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
----------
Asus TUF F15, 32GB Ram, 2 * 1 TB NVME M.2, GTX 1650
User avatar
Adolfo
 
Posts: 860
Joined: Tue Oct 11, 2005 11:57 am
Location: Chile

Postby fafi » Sat May 10, 2008 4:41 am

Yes I used it, nice :D

Thanks Adolfo

regards
Fafi
User avatar
fafi
 
Posts: 169
Joined: Mon Feb 25, 2008 2:42 am


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 55 guests