Android Question A couple of questions for DB Experts

[Lary Yenta]

I am hoping that I can get a couple of answers here from Klaus or another DB Expert. I have come to believe that the best way for me to produce some of my reports would be to dump data into an empty table and proceed from there. I recognize that the best way to do this would be to create the table on the first time run of things but to test this methodology, I tried to use a create statement but did not succeed in creating a table. The code I used was the following:

  Query = "CREATE TABLE RptTemp Date TEXT, Time TEXT, Glucose Real"    
  SQL1.ExecNonQuery(Query)

 

[fixit30]

Your code should be this.

Query = "CREATE TABLE RptTemp (Date TEXT, Time TEXT, Glucose Real)"

 

[Lary Yenta]

Yeah, I caught that in the middle of posting but I could not figure out how to cancel the post

Sorry bout that

lary

 

[Mahares]

You are missing the parentheses. That is all:

Query = "CREATE TABLE  IF NOT EXISTS  RptTemp (Date TEXT, Time TEXT, Glucose Real)" 
 SQL1.ExecNonQuery(Query)