Search options (Page 27 of 34)

the same to me, the comment are not understandable in the script

Hi,

yes, it works but it makes a step more in designing the tablegrid (we all are lazy guys)

Thanks Dmitry,

for some reason, the "frxReport" works only on main form, I had to adapt the script to point to main form (SelectForm) so it looked like

SelectForm.frxReport.blablabla

I could manage 16 different reports on the same page which is the purpose of a database for me, getting dashboard reports in a snap. The report designer is just not very user friendly, though!

I have an error while transposing your example to my project, see attached picture

The last script does not work in 1.51.

Oh great! I think, this is something I could use to create some kind of wizard Thanks Dmitry

Please find a simple example with one Table Employee and one table logs.

To see and edit the triggers, you will have to use an external tool SQLStudio
Have fun!!

There is a very interesting solution in this topic: http://myvisualdatabase.com/forum/viewt … p?id=1484. Reply 13
You would not have to use any SQL query at all

Otherwise a join is done using a relationship field in the tables

For example

Author                                   Origin                                            Title
id                                           id                                                   id
Name                                    Country                                         Title
Title                                       id_Name                                       Year
                                                                                                   id_Name
                                                                                                   id_Country

Select Title, Country, Name

from Title,
Author a,
Origin o
where
id_Name=a.id
and id_Country=o.id
and Title=something

But honestly, the solution from derek is the simpliest one

Hi Derek,

the idea is there, thanks for the project.

The best would still be the "Wizard" mode where the user is guided through steps to limit input errors. I got feedbacks from the users after a beta release that there would be more tables, relations and fields needed...