SInce the results of Execute SQL are all stuffed into a single field, you can size the field to be many rows of text tall and give it a scroll bar. If you then use the Tab character as the field separator and returns as the record separator, you can use the Inspector's appearance tab to set tab stops for your columns of data to get what looks much like a portal--except that the data is read onlly.
Thanks phill this is what I want; however you didnt really answer my question. I was wondering if it is possible to use sql to extract data from multiple fields from many tables and table occurances in a database so I can display that data in a portal. Is there any other ways to that as well, like loop scripts etc? If so where can I find some info on this because I have never used sql.
I answered it as best I could from the information provided. You'll need to explain what you want in more detail before I can answer in kind.
I was wondering if it is possible to use sql to extract data from multiple fields from many tables and table occurances in a database so I can display that data in a portal.
What fields? In what tables? in what relationships? And why do you need a portal to display the results?
Okay I will attach a picture of the relationships I have in my database.
I have 5 tables:
1. Main- unique key=pk_main
2. Contacts (ignore this one)
3.treatment- foreign key=fk_main
4. diagnosis- foreign key=fk_main
5. laboratory results- foreign key=fk_main
I want a portal to display the related records from treatment, diagnosis and laboratory results in the layout linked to the "main" table
is this possible, i heard it can be done by using sql
I don't see how a portal becomes part of that. I do see how it might be possible to set up with a single multiple row field with a scroll bar. The results will look similar to a portal will not actually be a portal and the results will be read only, you won't be able to enter/edit data in this field.