reference fields by index

[ken2834]

Is there a way I can retrieve a list of fields in a table, without having to hard code each field name?

 

[firefytr]

Can you be a *little* bit more specific?? (Please.)

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[ken2834]

What I mean is, if I have a table called TABLE_TEST, and I have three fields, say first_name, last_name,and phone.

Can I do something like select field(3) from table_test where last_name = "Smith", and expect to retrieve the phone number? I believe I have seen this in Oracle or somewhere.

Alternatively, is there a way to retrieve the table definition from somewhere?

 

[firefytr]

And the application is ... ???

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[LFB]

I know this sounds pretty basic but do you mean something as simple as:

Select * from Table_test where field3 = 'Smith'

This would return you all fields without having to hardcode them where your field(3) = Smith.

 

[fredericofonseca]

A TABLE using VBA can be many things.

From what you have said so far it seems you are trying to access a table on a DATABASE, using SQL statements.

If so search these (all VB related) for "ADO", "tables" and "fields", together with "select".

There have been many threads about that subject.
This is one of them. thread709-474678

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com