SQL Help

[ComplexT]

Hi,

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??

# 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
def select_row(query):
  dbv.prepare(db, unicode(query))
  dbv.first_line()
  dbv.get_line()
  result = []
  for i in range(dbv.col_count()):
    result.append(dbv.col(i+1))
  return result

How come query works when i use the word Stefan but when i put a var containing the string stefan it will not work

Thank you for help with this

EDIT: Error i get is [Errno -6]
KErrArgument

[dehlerm]

The DBMS is documented in the Symbian OS Library. Although this documentation is aimed to C++ developing you might get an impression of the available SQL functionality.

Online: http://www.symbian.com/developer/tec...de%2eSQL%2etoc
It's also in the documentation files of the S60 SDK's (SDK Help).

for your problem try:

query = 'Select CustID,CustHist from ' + Category + ' where Name = ' + str(x)

[ComplexT]

Hi Guys,

Thanks for you help but i am still struggling with basic sql syntax

spring = db.execute(u'Select Name from ' + Category + ' where Name = \'' + term +'\' ')

Any body know why this doesnt work?

Could someone please supply some very simple statements that i can use with my method..

def select_row(query):
dbv.prepare(db, unicode(query))
dbv.first_line()
dbv.get_line()
result = []
for i in range(dbv.col_count()):
result.append(dbv.col(i+1))
return result

Thank You!