I have an app using SQLYoga written in LC5.5 which worked well.
Tried it in LC6.1, LC6.12 and LC6.5 and each time I tried a search using my SQLYoga routines I get an error.
An alert comes up "an error with SQL has occurred"
And the message box shows the following...
Code: Select all
sqlyoga_executesql_err,0,0,Database Error: near "FROM": syntax error (SELECT FROM line_text WHERE line_text.content MATCH 'release')
sqlyoga_executesql_err,0,0,dbconn_openCursor (2747)
sqlyoga_executesql_err,0,0,stack "/Users/jehale/Development_Projects/Revolution projects/Reader2/AnoText new db schema - FTS - LC5.5/components/sql_yoga.rev"
sqlyoga_executesql_err,0,0,sqlquery_retrieve (4872)
sqlyoga_executesql_err,0,0,stack "/Users/jehale/Development_Projects/Revolution projects/Reader2/AnoText new db schema - FTS - LC5.5/components/sql_yoga.rev"
sqlyoga_executesql_err,0,0,sqlquery_retrieveAsArray (4885)
sqlyoga_executesql_err,0,0,stack "/Users/jehale/Development_Projects/Revolution projects/Reader2/AnoText new db schema - FTS - LC5.5/components/sql_yoga.rev"
sqlyoga_executesql_err,52,0,search_crumbs
sqlyoga_executesql_err,52,0,stack "Index_find" of stack "/Users/jehale/Development_Projects/Revolution projects/Reader2/AnoText new db schema - FTS - LC5.5/components/program.dat"
sqlyoga_executesql_err,4,0,mouseUp
353,4,0,button id 66399 of card id 1025 of stack "/Users/jehale/Development_Projects/Revolution projects/Reader2/AnoText new db schema - FTS - LC5.5/components/program.dat"
Has something changed in LC 6.x that SQLyoga doesn't like?
I am using the commercial versions of all LC's