Android Question A couple of questions for DB Experts

Discussion in 'Android Questions' started by Lary Yenta, May 5, 2015.

  1. Lary Yenta

    Lary Yenta Member Licensed User

    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:

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

    fixit30 Active Member Licensed User

    Your code should be this.

    Code:
    Query = "CREATE TABLE RptTemp (Date TEXT, Time TEXT, Glucose Real)"
     
  3. Lary Yenta

    Lary Yenta Member Licensed User

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

    Sorry bout that :(

    lary
     
  4. Mahares

    Mahares Well Known Member Licensed User

    You are missing the parentheses. That is all:
    Code:
    Query = "CREATE TABLE  IF NOT EXISTS  RptTemp (Date TEXT, Time TEXT, Glucose Real)" 
     SQL1.ExecNonQuery(Query)
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice