How to work with a database?

General Discussion
#1

SQL know. As in this application, insert, delete, update and select specific fields in(out) database(loc) -> <- widget app.

B.R./

#2

In Database - OK.

“update data set field2 = '”+ document.childByName(“Text 4”).content.plainText

  • "’ where field1 = ‘FIO’ "

Out Database - problem. I Need help.

This no Work
"select top 1 " + document.childByName(“Text 4”).content.plainText + " = field2 from data where field1 = ‘FIO2’ "

#3

Use LIMIT 1 at the end of the query instead of TOP 1 (which isn’t valid sqlite syntax):

select * from data where field1 = 'FIO2' LIMIT 1
#4

as a result of the query (one field) pass in document.childByName(“Text 4”).content.plainText ?

Back to Flipabit >
Copyright © 2018. Flipabit Team. All rights reserved.