Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Script to count fields in an sql 2000 database TABLE
- Thread starter snipesnab
- Start date
ralphtrent
Programmer
fields are referred to as columns, if you mean rows then you can do this
function CountRows
dim rowcount
[connection open]
connection.execute("select 'Total' = count(*) from table")
rowcount = connection("Total")
[connection close]
if rowcount => 5000 then
CountRows = true
else
countRows = False
end if
end function
function CountRows
dim rowcount
[connection open]
connection.execute("select 'Total' = count(*) from table")
rowcount = connection("Total")
[connection close]
if rowcount => 5000 then
CountRows = true
else
countRows = False
end if
end function
SeniorGuru
MIS
If you've got more that 5000 columns in a table, you've got issues. 
- Status
