Sorry i start thread for only this topic i could not see thread for similar issue elsewhere.
Where can i find what SQL syntax allowed for pys60??
How come query works when i use the word Stefan but when i put a var containing the string stefan it will not work
# this query works..
print select_row('Select CustID,CustHist from ' + Category + ' where Name = \'Stefan\' ')
# This Query Doesnt Work when x is Stefan
print select_row('Select CustID,CustHist from ' + Category + ' where Name = ' + '\''+ x + '\'\'')
heres the select row method
# search and retrieve from a row
result = 
for i in range(dbv.col_count()):
Thank you for help with this
EDIT: Error i get is [Errno -6]