I would like to have a form do a DB Read from another table but I can't find a good walkthrough for that. I did find the pdf download:
How to list table multiple rows and edit their data
In the last tutorial we have created a form which can load the data of one table record, now we are going
to create another form to list all records and give us the ability to edit any one of them:
I think I'm looking for the "last tutorial" that is mentioned above that "can load the data of one table record"
Hi jfascia,
What do you actually need to do?
The PDF is an old CFv4 tutorial, there's an updated version in [url=https://www.chronoengine.com/faqs/61-cfv4/cfv4-tutorials/2698-how-to-load-one-row-from-a-db-table-into-your-form.html]a FAQ here[ /url]. The action in CFv5 is similar though the WHERE box is now the Conditions box and has a different syntax (there's another FAQ about that).
Bob
Bob,
Is there a way to use a DB Record Loader to call data from a remote database?
This would be something like the DB Save action which can save to local/remote databases?
So while jfascia is looking to call from another table, I'm extending the question to another database!
Brendan
Hi Brendan,
Please check the DB Read action for an External Database tab where you can set that up. If you don't see it you may need to upgrade your ChronoForms v5 to the latest release.
Bob
Please:
1. set in "DB Read" the dafault value for "Multi Read" as "Yes" and
2. remove the error "Table selcted?" when you chose a table in external DB.
I spent an hour while I ocasionally found in a manual screenshot "Insert in Dropdown data from table by ID user" that this value was set to "Yes", however by default it has "No".
The second problem is that when you set up an external DB as source for your DB Read you always had an error in Designer, showing you that you have not selected a table.
I just made a double check. The problem was really in "Multi Read".