1 Reply Latest reply on Feb 1, 2009 7:13 PM by Dr. Fred Mbogo

    sqlite question

      Hi All
      how can I implement a command like this in sqlite

      INSERT INTO `General_Disease_List` VALUES (1,'Seisures'),(2,'Blackouts'),(3,'Strokes'),(4,'Dementia'),(5,'Parkinson\'s Disease'),(6,'Heart trouble'),(7,'Cancer'),(8,'Psychiatric disease'),(9,'Substace abuse'),(10,'Other');

        • 1. Re: sqlite question
          Dr. Fred Mbogo Level 1
          The documentation should be quite clear. Just execute it as a SQL statement. The only tricky bit is working out the quoting rules, and the simplest way to do that is to use double quotes in your AS or JS code, leaving the single quotes and back quotes unharmed in the SQL.

          If you're having some trouble getting it to compile or run, post the errors you're getting.