SQL
I created forms in FP2000 (html)so a user can add, change or delete from a DB (Access 2000). I have an input form.html that users can use to modify
existing data in a table. There are about 13 columns of
information in the table. On the form I have input fields for the old
information and input field for the new information (for
13 different columns). How can I get the old information
field to populated from the DB? So the users can see the old information.
Thanks
I hope this makes sense.
Software/Hardware used:
Software/Hardware used:
ASKED:
August 4, 2004 6:05 PM
UPDATED:
August 9, 2004 2:27 PM
Answer Wiki:
I've always accomplished this using visual basic and ADO record sets. You need to query the database, fill an ado record set, and then input the fields into your form.
To see all answers submitted to the Answer Wiki: View Answer History.
I’ve always accomplished this using visual basic and ADO record sets. You need to query the database, fill an ado record set, and then input the fields into your form. Sorry, I’m not an access guru.
IN FP2000 itself you should be able to bind the fields to the database.
Depending on how you need to display the data, you may wish to look into using the FP menu option “Insert – Database – Results.”
As with your other reply, I usually use VB Script and ADO to extract and display the data.