I use a bunch of TextFields (in an edit window) to allow New, Modify, Delete (!). I am able to store Records with empty (nothing) values.
"Statut VARCHAR NOT NULL, PRIMARY KEY(ID))" "Pays VARCHAR NOT NULL, SentBy VARCHAR NOT NULL, Date_In DATE NOT NULL, Date_Out DATE NOT NULL, " +_ "Wife VARCHAR, Enfant VARCHAR, Sexe BOOLEAN NOT NULL, Date_Birth DATE NOT NULL, " +_ SQLParm = "CREATE TABLE IF NOT EXISTS Caritas(ID INTEGER NOT NULL, PNom VARCHAR NOT NULL, Nom VARCHAR NOT NULL, " +_ Oh, you want to see the CREATE Statement ? Here it is: When I ask advice(s), usually I listen to them. I do not really understand what you said. PS: I left the Terminal when I added a report window with a TextField as a SQLite command text holder (I put SQLite string commands there and watch what the result(s) can be in a Listbox below (for searching porposes only. I have to read carefully what my code do (how my code achieve what I want to do) and try to make changes. SELECT * FROM Caritas WHERE Date_Out LIKE '%2016%' // Keep all Date_Out that were done in 2016
SELECT * FROM Caritas WHERE Date_Out NOT LIKE '' // Exclude empty Date_Out (still present) Now that some days ellapsed, I can start back and watch what error Ive made with the command. I also was able to make working some SELECT * FROM queries. I get two pipes (||) for each empty entry. I spend time to try to use the Terminal to open, return data from my. Curious, why did you use Date_Out in the query, but mention Date_In here?
0 kommentar(er)
