Hi all,
Im looking at getting some user information loaded on my form when it initialises using a DQL adaptor.
Once I have it there it will be used to pass parameters to an addition adaptor to populate a read only table.
When the form initialises I need to set the value of two controls and Im looking at the best option at how to do this
in a efficient manner.
If the controls are both set up to execute the same adaptor when a form initialises will that adaptor be run twice?
For example, my form needs to display the current user (user_os_name) and the description of the default group
so the query could look something like this:
select u.user_os_name, g.description from dm_user u, dm_group g where u.user_name = USER and u.user_group_name = g.group_name
Are the forms clever enough to know that this only needs to run once or should I split it into two adaptors as follows?
1) get User - select user_name , user_group_name from dm_user where user_name = USER;
and then pass the result into a second adpator
2) getGroupDescription - select description from dm_group where group_name = %user_group_name%
any thoughts?
Thanks
Hoo
