Im lost, SQLITE3 and the WX LISTCTRL Create a program that reads a table from a
ID: 3592292 • Letter: I
Question
Im lost, SQLITE3 and the WX LISTCTRL
Create a program that reads a table from a database into a wx.ListCtrl. The database will be named college.sqlite and the table is to be named students. A link to a copy of the students data in the form of a CSV file is given later in this document. The CSV file contains a row of 9 heading and then 50 rows of student records. A single record and the proper field names for the table should look like this. The id is the primary key
Your interface will need a wx Frame and a wx ListCtrl and 3 buttons. A display button loads all of the student table into the list control. An insert button will open a wx Dialog that allows the user to enter the 9 data items used for a student record. When the user closes the dialog the new record will be SQL INSERTED to the student's table and the list control re-populated so as to display the inserted record. You also need a close button to close the program.
example output:
Insert Into List Control Students Last Name First Name Hrs Co..Hrs Att. GPA PtsMajorAdv. ID Email 6 8 inez 2 7 bpalla@tru.ec zrowe@tru.ec avonna@tru. varez seldorodo@tr 2 1 Display CancelExplanation / Answer
See the MySQL manual for more information on these data types.
To view indexes created in PM table fields, access ProcessMaker's database and check the indexes of pmt_namePMTable: