David, I have emailed a screenshot to you as i don't have anywhere to upload one to.
I will definitely be putting bounds checking in but i just needed to get over that "get data and display" hurdle.
I like the idea of wxListBox.Insert(). My first thought is to put this in the DatabaseTypes.bmx but that may not work (i will try later tonight).
I only get the data as i need it. So populate the lists on startup and update relevant lists on each click where relevant, using the "SELECT * FROM otherTable WHERE selectortypeid = ?" format. I haven't put those queries in yet but i planned to give them their own types. That should make Add/Edit and Delete easier too.
Brucey - i had seen that clientData option in the docs but hadn't figured out how to use it. The way you describe it makes it sound like what i want. Some reading and test apps to go...:)
In my Database types i like the idea of having the list for each type (table or query) so that i have the foreign key available to help build up the queries for Main Task and Sub Task. Other than that i probably don't need it.
I will open Access and see about dropping out the schema, although i haven't done it before. Can either of you just drop my database into a folder and use the FileDSN to make the code us it? i don't think you need Access to be installed, just the odbc driver?
I really appreciate your help.
oh and i better check that MVC link too.
Cheers
Glenn
I will definitely be putting bounds checking in but i just needed to get over that "get data and display" hurdle.
I like the idea of wxListBox.Insert(). My first thought is to put this in the DatabaseTypes.bmx but that may not work (i will try later tonight).
I only get the data as i need it. So populate the lists on startup and update relevant lists on each click where relevant, using the "SELECT * FROM otherTable WHERE selectortypeid = ?" format. I haven't put those queries in yet but i planned to give them their own types. That should make Add/Edit and Delete easier too.
Brucey - i had seen that clientData option in the docs but hadn't figured out how to use it. The way you describe it makes it sound like what i want. Some reading and test apps to go...:)
In my Database types i like the idea of having the list for each type (table or query) so that i have the foreign key available to help build up the queries for Main Task and Sub Task. Other than that i probably don't need it.
I will open Access and see about dropping out the schema, although i haven't done it before. Can either of you just drop my database into a folder and use the FileDSN to make the code us it? i don't think you need Access to be installed, just the odbc driver?
I really appreciate your help.
oh and i better check that MVC link too.
Cheers
Glenn