Forums

How do I retrieve retrieve and display one piece of data?

snelson 20 Jan, 2019
I'm brand new to ChronoForms6. Over the last couple days, I've been trying to learn by playing around with the nine pre-installed Demos, the ChronoForms v6 Manual, and this How To forum. However, none of the demos demonstrate how to retrieve a value from the database and then display that value in the form. Even that area of the manual is confusing me about how to display the data.

For starters, I created a very simple table with only two fields (fld_id and fld_val). So far, I've figured out how to enter an ID number into the Chrono form. But, I'm at a loss trying to figure out how to query the database table with that ID and then display what's in the fld_val when a record match is found.

It's something so simple and common that I am surprised that none of the nine demos show anything about database record retrieval and display.

Can someone explain how to do this?
GreyHead 21 Jan, 2019
Hi snelson.

Please check the section in the manual on Reading Data - from page 20 on. Adding a Debugger action to your form will then show you exactly what data is being loaded from the table.

Bob
snelson 22 Jan, 2019
Bob,
Thank you. It worked.
I had read that section on Database Management already and had referred to it several times without success. But, I went back again and followed it in step-by-step detail and got it going. My problem was syntax in my Where Conditions.
Thanks again.
This topic is locked and no more replies can be posted.