SQL

0 pts.
Tags:
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: August 4, 2004  6:05 PM
UPDATED: August 9, 2004  2:27 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Bruceworking
    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.
    0 pointsBadges:
    report
  • Mcp111
    IN FP2000 itself you should be able to bind the fields to the database.
    0 pointsBadges:
    report
  • MGaines
    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 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following