Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: displaying a table's column name
Started 1 month ago by redhat22
Hi!! tnx for the info that uve given me before with regards to databases.. i just want to know if there is a way to display a table's column name using vb6.. my database is in access 2003 format tnx!
Site: VBForums - Visual Basic and VB .NET Discussions and More!  VBForums - Visual Basic and VB .NET Discussions and More! - site profile
Forum: Database Development  Database Development - forum profile
Total authors: 3 authors
Total thread posts: 5 posts
Thread activity: no new posts during last week
Domain info for: vbforums.com

Other posts in this thread:

si_the_geek replied 1 month ago
There are several ways, but like with most things to do with database related code, which one(s) are valid depend on which connection technology you are using - such as ADO code/ADO control/DAO control/...
Size: 205 bytes
Customize:  Customize "<b>Reply 1</b>: displaying a table's column name :: Database Development :: VBForums - Visual Basic and VB .NET Discussions an..."

redhat22 replied 1 month ago
Im using Ado Code..
Size: 19 bytes
Customize:  Customize "<b>Reply 2</b>: displaying a table's column name :: Database Development :: VBForums - Visual Basic and VB .NET Discussions an..."

si_the_geek replied 1 month ago
One way is to open a recordset containing all columns, but no rows: Code: Dim strSQL as String Dim intField as Integer Dim objRS as ADODB.Recordset strSQL = "SELECT * FROM Table1 WHERE False" objRS.Open strSQL, objCN , adOpenForwardOnly, adLockReadOnly, adCmdText For intField = 0 To objRS.Fields.Count -1 MsgBox objRS.Fields(intField).Name Next intField objRS.Close ...
Size: 889 bytes
Customize:  Customize "<b>Reply 3</b>: displaying a table's column name :: Database Development :: VBForums - Visual Basic and VB .NET Discussions an..."

abhijit replied 1 month ago
Querying the data dictionary is helpful, if you're using Oracle. sql Code: SELECT column_name FROM dba_tab_columns WHERE table_name = 'TABLE'
Size: 897 bytes
Customize:  Customize "<b>Reply 4</b>: displaying a table's column name :: Database Development :: VBForums - Visual Basic and VB .NET Discussions an..."

 

Top contributing authors

Name
Posts
redhat22
2
user's latest post:
displaying a table's column...
Published (2009-11-13 09:05:00)
Im using Ado Code..
si_the_geek
2
user's latest post:
displaying a table's column...
Published (2009-11-13 09:13:00)
One way is to open a recordset containing all columns, but no rows: Code: Dim strSQL as String Dim intField as Integer Dim objRS as ADODB.Recordset strSQL = &quot;SELECT * FROM Table1 WHERE False&quot; objRS.Open strSQL, objCN , adOpenForwardOnly, adLockReadOnly, adCmdText For intField = 0 To objRS.Fields.Count -1 MsgBox objRS.Fields(intField).Name Next intField objRS.Close Set objRS = Nothing Another is to use OpenSchema. You can see...
abhijit
1
user's latest post:
displaying a table's column...
Published (2009-11-13 10:57:00)
Querying the data dictionary is helpful, if you're using Oracle. sql Code: SELECT column_name FROM dba_tab_columns WHERE table_name = 'TABLE'

Related threads on "VBForums - Visual Basic and VB .NET Discussions and More!":

Stored Procedure: passing as parameters the column name,...  VBForums - Visual Basic and VB .NET Discussions and More! - site profile Database Development - forum profile Stored Procedure: passing as parameters the column name, table and criteria?
Stored Procedure: passing as parameters the column name, table and criteria?
Selecting from Table with Special Characters in Column Name  VBForums - Visual Basic and VB .NET Discussions and More! - site profile Database Development - forum profile Selecting from Table with Special Characters in Column Name
Selecting from Table with Special Characters in Column Name
Update table where criteria depends on other table column...  VBForums - Visual Basic and VB .NET Discussions and More! - site profile Database Development - forum profile Update table where criteria depends on other table column for Access 2000
Update table where criteria depends on other table column for Access 2000
ODBC: How to get all table names and table column names ?  VBForums - Visual Basic and VB .NET Discussions and More! - site profile Database Development - forum profile ODBC: How to get all table names and table column names ?
ODBC: How to get all table names and table column names ?
Gridview - how to find a column by it's column name...  VBForums - Visual Basic and VB .NET Discussions and More! - site profile ASP.NET - forum profile Gridview - how to find a column by it's column name rather than it's Cellindex
Gridview - how to find a column by it's column name rather than it's Cellindex
[RESOLVED] Help displaying "correct" file name  VBForums - Visual Basic and VB .NET Discussions and More! - site profile Classic Visual Basic - forum profile [RESOLVED] Help displaying "correct" file name
[RESOLVED] Help displaying "correct" file name
Sql command for alter table column definition  VBForums - Visual Basic and VB .NET Discussions and More! - site profile Database Development - forum profile Sql command for alter table column definition
Sql command for alter table column definition
[2005]Need help with Database Table Column incrementation  VBForums - Visual Basic and VB .NET Discussions and More! - site profile Visual Basic .NET - forum profile [2005]Need help with Database Table Column incrementation
[2005]Need help with Database Table Column incrementation
How to hide a table column in ASP 2.0  VBForums - Visual Basic and VB .NET Discussions and More! - site profile ASP.NET - forum profile How to hide a table column in ASP 2.0
How to hide a table column in ASP 2.0
[2005]how get values from sql server table column to...  VBForums - Visual Basic and VB .NET Discussions and More! - site profile ASP.NET - forum profile [2005]how get values from sql server table column to dropdown list
[2005]how get values from sql server table column to dropdown list

Related threads on other sites:

Displaying same column name in the same column - TechNet...  TechNet Forums - site profile Transact-SQL - forum profile Displaying same column name in the same column - TechNet Forums
Displaying same column name in the same column - TechNet Forums
Copy table - column name escaping `  HeidiSQL User Forum - site profile Usage - forum profile Copy table - column name escaping `
Copy table - column name escaping `
I can't use controller names as table column name in DB...  Twitter / fl00r - site profile fl00r - forum profile I can't use controller names as table column name in DB (using SQLite3!? Why so? I',m angry. 1:28 AM Oct 30th from web
I can't use controller names as table column name in DB (using SQLite3!? Why so? I',m angry. 1:28 AM Oct 30th from web
10.1B and "Default" keyword as table column name.  PSDN Online Forums - site profile OpenEdge Principles & OpenEdge Reference Architecture - forum profile 10.1B and "Default" keyword as table column name.
10.1B and "Default" keyword as table column name.
Displaying the Column Name for JTabel  JavaRanch Big Moose Saloon - site profile Swing / AWT / SWT / JFace - forum profile Displaying the Column Name for JTabel
Displaying the Column Name for JTabel
Table & Column Name in microsoft.public.sqlserver.server  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.server - site profile microsoft.public.sqlserver.server - forum profile Table & Column Name in microsoft.public.sqlserver.server
Table & Column Name in microsoft.public.sqlserver.server
How to change the drill through table column name?  Pentaho Community Forums - site profile Mondrian [Pentaho Analysis Services] - forum profile How to change the drill through table column name?
How to change the drill through table column name?
FRx export to Pivot Table - column name in...  Discussions in microsoft.public.greatplains - site profile microsoft.public.greatplains - forum profile FRx export to Pivot Table - column name in microsoft.public.greatplains
FRx export to Pivot Table - column name in microsoft.public.greatplains
Pivot table -> column name to row  BOB: BusinessObjects Board - site profile WebIntelligence XI - forum profile Pivot table -> column name to row
Pivot table -> column name to row
Get table column name using vb.net  www.daniweb.com - IT Tech Talk - site profile VB.NET - forum profile Get table column name using vb.net
Get table column name using vb.net
Thread profile page for "displaying a table's column name" on http://www.vbforums.com. This report page is a snippet summary view from a single thread "displaying a table's column name", located on the Message Board at http://www.vbforums.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity