PDA

View Full Version : AS400 Table Information

Tek707
09-12-02, 14:39
Is there a way I can get the field names of an AS400 table via ASP coding.
JonathanB
09-13-02, 05:31
All depends on what database access layer your using...

Once you have the data in a recordset you can retrieve the field names using:
for f = 0 to data_rs.fields.count-1
response.write(data_rs.fields(f).name)
next
Tek707
09-13-02, 13:56
Originally posted by JonathanB
All depends on what database access layer your using...

Once you have the data in a recordset you can retrieve the field names using:

Thanks...That helped alot.