Grabing Fields Names, Types, and number of records, without Select * 1

[Karl Blessing]

at the moment I have feature that only shows the list of fields, and their data types, but I use a Select * from.. to create the recordset, anyway I can get the number of records, the field's names, and their types, without loading the entire database (reason I ask is a Table of about 2000 record takes a few sec, imagine more than that) <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href=

http://kb244.8m.com>

</a><br>Experienced in , or have messed with : VC++, Borland C++ Builder, VJ++6(starting),VB-Dos, VB1 thru VB6, Delphi 3 pro, Borland C++ 3(DOS), Borland C++ 4.5, HTML,Visual InterDev 6, ASP(WebProgramming), QBasic(least i didnt start with COBOL)

 

[Karl Blessing]

<b><i>how many of you wana see me knock myself up the head :}</i></b><br><br>found out, I could just do RS.MaxRecords = 1 and only have it return a single record. <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href=

http://kb244.8m.com>

</a><br>Experienced in , or have messed with : VC++, Borland C++ Builder, VJ++6(starting),VB-Dos, VB1 thru VB6, Delphi 3 pro, Borland C++ 3(DOS), Borland C++ 4.5, HTML,Visual InterDev 6, ASP(WebProgramming), QBasic(least i didnt start with COBOL)

 

[Karl Blessing]

hmm but theres still the problem of getting the total number of records that exist on that table. <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href=

http://kb244.8m.com>

</a><br>Experienced in , or have messed with : VC++, Borland C++ Builder, VJ++6(starting),VB-Dos, VB1 thru VB6, Delphi 3 pro, Borland C++ 3(DOS), Borland C++ 4.5, HTML,Visual InterDev 6, ASP(WebProgramming), QBasic(least i didnt start with COBOL)

 

[palbano]

Select Count(*) as RecNo from blah<br><br>-pete

 

[Karl Blessing]

Thanks very much pete. now I assume thats just going to give me the recordcount, so I'm still going to need to run the other recordset with MaxRecords set to 1.<br><br>well anyways, Thanks. <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href=

http://kb244.8m.com>

</a><br>Experienced in , or have messed with : VC++, Borland C++ Builder, VJ++6(starting),VB-Dos, VB1 thru VB6, Delphi 3 pro, Borland C++ 3(DOS), Borland C++ 4.5, HTML,Visual InterDev 6, ASP(WebProgramming), QBasic(least i didnt start with COBOL)

 

[NickBulka]

Karl, check out the OpenSchema method.<br><br> <p>nick bulka<br><a href=mailto: > </a><br><a href= > </a><br>

 

[Karl Blessing]

hrm it had made retreval just a bit faster, but it's still taking time to load, for example a DB with 173928 , does SQL server normally just keep the number of rows per table somewhere, or must it actually go through and count each row(this must work with Access too btw) <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href=

http://kb244.8m.com>

</a><br>Experienced in , or have messed with : VC++, Borland C++ Builder, VJ++6(starting),VB-Dos, VB1 thru VB6, Delphi 3 pro, Borland C++ 3(DOS), Borland C++ 4.5, HTML,Visual InterDev 6, ASP(WebProgramming), QBasic(least i didnt start with COBOL)