search

robotoworks / mechanoid

Eclipse plugin providing a set of DSL's for the rapid development of Android apps
58 stars 26 forks source link

SQlite function 'replace' is unknown #246

Closed hannesa2 closed 1 year ago

hannesa2 commented 10 years ago

unfortunately this is not possible

create view operationLogging as select 
  _id as id,
  case when instr(operationName,'mytext')>0 then length(replace(datain, 'IDS=','')||' ')/11 else 0 end as dynCount,
fluxtah commented 10 years ago

Looks like the replace function is conflicting with the replace keyword, try escape it like this ^replace(_id, 'IDS=','')

It probably wont work but worth a try

hannesa2 commented 10 years ago

awesome it works Thank you !

hannesa2 commented 10 years ago

unfortunately the OperationLoggingRecord wasn't generated

fluxtah commented 10 years ago

oh shame, will have to look into it