peterjb31
23rd April 2008, 10:40
I have a database with several tables which I want to access through a form. I am trying to access different tables using different tabs in a mainwindow. The issue is that the second mapping listed within the class doesn't seem to respond.
I have the following fields defined at the top:
SUPID, SUPTITLEID, SUPCOMPNAME, SUPFORENAME, SUPSURNAME, SUPADDLINE1, SUPADDLINE2, SUPADDTOWN, SUPADDCOUNTY, SUPADDPOSTCODE, SUPPHONE, SUPEMAIL, CUSTITLEID, CUSNAME, CUSFORENAME, CUSSURNAME, CUSDELADDLINE1, CUSDELADDLINE2, CUSDELADDTOWN, CUSDELADDCOUNTY, CUSDELADDPOSTCODE, CUSBILLADDLINE1, CUSBILLADDLINE2, CUSBILLADDTOWN, CUSBILLADDCOUNTY, CUSBILLADDPOSTCODE, CUSPHONE, CUSEMAIL, ID, NAME, = range(32)
And then map to them using this syntax:
self.supplierMapper.addMapping(self.supplierSurnam eEdit, SUPSURNAME)
Is it because of the ordering for the fields at the top of the class. How do I make sure that one of the variables at the top of the class is mapped to the right field within the database.
Any help would be hugely appreciated.
I have the following fields defined at the top:
SUPID, SUPTITLEID, SUPCOMPNAME, SUPFORENAME, SUPSURNAME, SUPADDLINE1, SUPADDLINE2, SUPADDTOWN, SUPADDCOUNTY, SUPADDPOSTCODE, SUPPHONE, SUPEMAIL, CUSTITLEID, CUSNAME, CUSFORENAME, CUSSURNAME, CUSDELADDLINE1, CUSDELADDLINE2, CUSDELADDTOWN, CUSDELADDCOUNTY, CUSDELADDPOSTCODE, CUSBILLADDLINE1, CUSBILLADDLINE2, CUSBILLADDTOWN, CUSBILLADDCOUNTY, CUSBILLADDPOSTCODE, CUSPHONE, CUSEMAIL, ID, NAME, = range(32)
And then map to them using this syntax:
self.supplierMapper.addMapping(self.supplierSurnam eEdit, SUPSURNAME)
Is it because of the ordering for the fields at the top of the class. How do I make sure that one of the variables at the top of the class is mapped to the right field within the database.
Any help would be hugely appreciated.