Post by eaglescone101 on Oct 29, 2020 21:07:59 GMT
Greetings,
When I submitted the following query via dbManager.Execute, I received the "incomplete input" exception. The query is:
Then I used a parameterized version with question marks (which I would rather not do), and it appeared to work. However, when I checked the table using DB Browser for SQLite, no information was entered and the table has no records.
I checked using code to query the table using Simple SQL. Simple SQL said it had one record. However, when I tried to get the value of a field for that record, there was nothing there.
Also, is there a way to check for null values before attempting an assignment? I am trying to assign a DateTime value and it throws an exception because the record is empty.
Please advise.
Thanks.
When I submitted the following query via dbManager.Execute, I received the "incomplete input" exception. The query is:
insert into UserInformation(Username, PlayerLevelName, PlayerLevelNumber, RecordCreationDateTime, RecordUpdateDateTime) values('DavidB​', 'Bronze', 1, 637395873687039670, 637395873687039670)Then I used a parameterized version with question marks (which I would rather not do), and it appeared to work. However, when I checked the table using DB Browser for SQLite, no information was entered and the table has no records.
I checked using code to query the table using Simple SQL. Simple SQL said it had one record. However, when I tried to get the value of a field for that record, there was nothing there.
Also, is there a way to check for null values before attempting an assignment? I am trying to assign a DateTime value and it throws an exception because the record is empty.
Please advise.
Thanks.
