But I still need to be able to access those columns to input data, even
though they are empty.
>>Why don't you do a count on the number of records in the table first. If
>>the recordcount = 0 don't run the CF ColumnList program.
Ryan
_
he CF ColumnList works
as long as there is data in the table, but otherwise I get an error. If
anyone has anymore ideas, I would appreciate it.
Ryan Block
-Original Message-
From: Bryan LaPlante [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 17, 2001 11:48 AM
To: [EMAIL PROTECTED]
Subject: Re: [KCF
This is what I have modified from what Bryan LaPlante sent me the other day.
You'll have to modify some of this SQL statement to whatever it should be
for SQL Server. This works with Access.
Ryan Block
SELECT name
FROM msysobjects
WHERE type =1
AND name NOT LIKE 'MSys%'
Bel
s
and SQL references, but can't find out how to get column names within a
table. Someone please tell me what I am missing.
Thanks again,
Ryan Block
Click the back button on your browser and select a valid table name.
SELECT TOP 1 *
FROM #tablename#
Below is
that.
select * from msysobjects
#ColumnName#
#Evaluate("QryResult." & "#CellValue#")#
- Original Message -
From: "Ryan Block" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 15, 2001 11:01 AM
Sub
I can't remember how to query a database to just return the names of the
tables in a database (just using Access for now). I know that I have seen
the syntax to do this somewhere, but can't find it. Thanks in advance.