Is it possible to invoke an Access query from a page generated with FP? I have several Access forms in my fpdb that I use to update various tables used in my Web, but I would like to access the updates directly from a Web page.Can I create a Web page that would have a button that could be selected to invoke the queries. I thank you in advance for any and all help on this question.
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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Invoke Access Query from HTML page
- Thread starter ca268339
- Start date
Hi There-
I've been trying to do the same thing and from the research, reading and querying of people on line I've yet to discover you can get FP '00 to do this.
My understanding is that an access query is already "narrowing" the table search down. FP '00 doesn't allow you to query the query. When I've set it up what happens is that the program asks for a parameter for each table that is referenced in the query.
What I believe has to occur is that you would write a custom SQL query to examine the multiple tables and pull in the fields from each table that you require. I'm currently working on this myself.
Best of luck.
I've been trying to do the same thing and from the research, reading and querying of people on line I've yet to discover you can get FP '00 to do this.
My understanding is that an access query is already "narrowing" the table search down. FP '00 doesn't allow you to query the query. When I've set it up what happens is that the program asks for a parameter for each table that is referenced in the query.
What I believe has to occur is that you would write a custom SQL query to examine the multiple tables and pull in the fields from each table that you require. I'm currently working on this myself.
Best of luck.
- Thread starter
- #3
Hi-
I would write the customer query in the .asp. I'm currently doing that now although I have yet to be successful. I have a posting on that myself!
I'm having more difficulty with the coding aspect as I'm not a programmer and am learning as I go.
According to the documentation in FP and what I've found on the web this is how to do it. However, I don't know anything about CGI so this would be more sensible.
Sorry I couldn't be of more help-
Diana
I would write the customer query in the .asp. I'm currently doing that now although I have yet to be successful. I have a posting on that myself!
I'm having more difficulty with the coding aspect as I'm not a programmer and am learning as I go.According to the documentation in FP and what I've found on the web this is how to do it. However, I don't know anything about CGI so this would be more sensible.
Sorry I couldn't be of more help-
Diana
- Status
Similar threads
- Locked
- Question