hello everyone, im a newbie in pys60. i am trying to develop an application involving database using this code..
db.execute(u"CREATE TABLE test_table (id counter, fname VARCHAR, lname VARCHAR, age INTEGER )")
print "Table Created"
print "Error Creating table: "
db.execute(u"INSERT INTO test_table VALUES (1,f,gend[f],f)")
print "Data Inserted"
i am pretty sure that the data are correct since i printed them on screen...i used a form in this app. i am just wondering y it wont work whenever i assign the value to a variable. it is actually working using this (1,"Jane","Female",1)....any idea?