SQL query with variable

[AHKStudent]

I have a few questions about the SQL lib Class_SQLiteDB.ahk

Any answers will be helpful, I also posted to the creator in the scripts forum

How would I go about storing a date in the database so later I can do queries from date A to date B

What data type do I use? How do I do this (obviously I can generate the current date using ahk formattime)

Also, how do I do a select query with a variable with in?

SQL := "SELECT Table4.title FROM Table4 WHERE Table4.yen = %variable%;"

[tank]

I will answer your only AHK question. the others are SQL DB questions

Code: Select all

SQL := "SELECT Table4.title FROM Table4 WHERE Table4.yen = '" . variable . "';"

[AHKStudent]

I will answer your only AHK question. the others are SQL DB questions

Code: Select all

SQL := "SELECT Table4.title FROM Table4 WHERE Table4.yen = '" . variable . "';"

Thank you, that worked