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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What is the best way to populate a form with data from a DB?

Status
Not open for further replies.

campbere

Technical User
Oct 10, 2000
146
US
I am working with an Oracle 8i database. After executing a sql statement and having a recordset of multiple records, up to thousands I want to display the information to a form.

The method that I came up with was to write code so I build and populate the html form at the same time the Next or Previous Button is clicked. This seems rather ineffienct to me. Is there a better way of populating a form? So I don't regenerate the form each time? The form stays the same, ony the data changes.

I would think that I could generate the form once. Then populate the text boxes with the different values depending on where the user was on the recordset.

Does anyone know if this is possible? Any better suggestions/examples?

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top