Changing Form Controls Database association programatically (AREV32)
At 08 AUG 2011 03:17:44AM Arsath Ahammed wrote:
Hi,
I want to know how to create controls programmatically with their database association specified. I have a form which I connect to different tables each having the same dictionary. So I want to change the table name property for all the controls in the form. I see that this property is read only.
Ideally I would want to just read all the controls in the form, delete them, restore them with the table property changed.
How can I change database association programatically?
Thanks
Arsath Ahammed
At 08 AUG 2011 07:47AM keith alvey wrote:
Have you considered a 'hot-table', create the window on this table which wont ever be used, delete the table and then in the procedure that call the window run an Alias to the hot-table name … I've not tried this so just a thought …
At 08 AUG 2011 05:48PM Matthew Crozier wrote:
Have you considered a 'hot-table', create the window on this table which wont ever be used, delete the table and then in the procedure that call the window run an Alias to the hot-table name … I've not tried this so just a thought …
That's what we do and it works well. We just have to Alias_table() to the master dictionary whenever maintaining the window template.
Cheers, M@
[img]http://www.vernonsystems.com/images/logo_main_ani.gif[/img]
At 15 AUG 2011 03:40AM Arsath Ahammed wrote:
The Alias option sounds good. I tried to use it, but I had some errors because I was trying to Alias tables within the same volume. I tried Alias on a table from another volume, it said Alias successful, But no Data inside the table.
I think the problem is because I use U2 Tables and I specified the location as the location of the shadow tables. Have you tried using Alias on a U2 table?
Thanks
Arsath Ahammed
At 15 AUG 2011 04:09PM Matthew Crozier wrote:
Have you tried using Alias on a U2 table?
No, sorry - haven't tried U2 tables.
Cheers, M@
[img]http://www.vernonsystems.com/images/logo_main_ani.gif[/img]
At 19 AUG 2011 01:43PM Andrew McAuley wrote:
As this is in the AREV32 category then adding DATAFILE=NewDataFile to the command line should work.
If this was intended to be a query about OpenInsight then checkout our blog entry on this subject.
World leaders in all things RevSoft
At 19 AUG 2011 03:06PM Sean FitzSimons wrote:
Andrew,
Very nice.
Sean FitzSimons
Revelation Software