[Pythoncard-users] Re: creating SQL insert/Update stmts

[ralph h. <1st...@1I...>]

I am looking for an easy way to create the insert/update SQL statements and how to reference self.components.<TextField>.text objects.

Is there a programatic way to do a for fieldname in self.components.fields???

How would I handle date columns?

insstmt="INSERT INTO MEMBER ("
            for colname in self.rowsDict: insstmt=insstmt+colname+","
            insstmt=insstmt[1:len(insstmt)-1]+") VALUES ("
            ##for textvalue in self.components: 
            insstmt=insstmt+"'"+self.components.SSN.text+"',"
            insstmt=insstmt+"'"+self.components.FirstName.text+"',"
            ... (60+fields)




_____________________________________________________________
 
 
 
=======================================
    www.StrictlyEmail.com ...our name says it all!