SQLite statements with parameters

1

I am using parameters with SQLite INSERT statements as shown below.

What is the correct syntax to use parameters with a SELECT statement; using a parameter after WHERE…

SELECT * FROM tablename WHERE fieldname=parameter

   args = [row.HighestKey];
    sqlList1[0] = ["INSERT INTO  FamilyMemberKey (HighestKey) VALUES (?)",args];
    Sql(DB,sqlList1);
2

air code:

sqlList1[0] = ["SELECT * FROM tablename WHERE fieldname=?",args];
3

Thank you, I appreciate it!

4

Hey Warren, I have heavily used sqlList with Appstudio, so let me know if you want to see other examples.
Ryan

5

Thank you, I appreciate the offer!!