SQL
Home > IT Answers > Development > SQL
CathyS
0 pts.
0
Q:
SQL
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.
ASKED: Aug 4 2004  6:05 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
bruceworking
0 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: Aug 4 2004  6:11 PM GMT by bruceworking   0 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

bruceworking   0 pts.  |   Aug 4 2004  6:13PM GMT

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.

 

mcp111   0 pts.  |   Aug 5 2004  12:48PM GMT

IN FP2000 itself you should be able to bind the fields to the database.

 

MGaines   0 pts.  |   Aug 9 2004  2:27PM GMT

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.

 
0