I have asked this question here several times, but never get any replies. In fact my questions seem to be The Only ones that don't get a reply, which makes me think no one actually knows how to do this or my question is so remedial that no one is bothering. I'll try one more time.
/prays someone takes pity...
I have created a form that contains a subform with 4 text fields. The fields are read only and the form will be used only for printing. I have also connected to my Oracle database successfully and can populate the fields with data. My problem is I only get the first record. I have the subform set to repeat the data but am having no luck accomplishing this. I always just get the first record. Any suggestions would be more than appreciated as I have been fighting this for about a week now.
Thanks very much for your reply. I think you have misunderstood my problem however. I am not trying to add rows to my database, I am simply trying to read and display multiple rows from my database. The user will not be entering any data. I simply want to display data records from my database and I am currently only able to get the first record to display when I view the PDF.
The oledb data connection returns a record set, so the default functionality will show the first record in the fields, and when you go next() the fields get updated with the values from the second record, etc.
If you need to show multiple subforms each showing each record at once, you would have to write a script that loops through the record set and for each record manually create a subform using the instanceManager, and set the rawValue of the fields in the subform to the value of the fields in the record.
I'm also trying to do this - the PDF in no way knows what the key to pass to SQL is. The web page that calls this PDF does. I need to get ONE record from the DB and display it in the form. Again, I know the SQL, I can connect to the DB, but I need to be able to pass the key to the SQL to get the correct user.
Picture a user setup form. The user already exists in the DB. The web page knows what the userID in the DB (the key) is... it needs to pass that key to the PDF in some way, and have the PDF SQL use whatever was passed.
I'm currently playing around with the query string, but would think there should be a better way to do this.