troubleshooting Question

SQLite question

Avatar of curiouswebster
curiouswebsterFlag for United States of America asked on
SQLDatabasesMicrosoft SQL ServerMySQL ServerMicrosoft SQL Server 2005
6 Comments3 Solutions15 ViewsLast Modified:
Select *  seems to hang and bring up an odd cursor, which locks me out.


I was trying to create a table, then verify the table existed by showing me a RowCount of 0.

CREATE TABLE IF NOT EXISTS ContactStatus (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    status TEXT NOT NULL,
    description TEXT NOT NULL
);

INSERT INTO ContactStatus (status, description) VALUES ('Active', ‘The Contact has been Activated.');
INSERT INTO ContactStatus (status, description) VALUES ('Inactive', 'The Contact is no longer Activate.');
INSERT INTO ContactStatus (status, description) VALUES ('Disabled', 'The Contact has been Disabled.');
INSERT INTO ContactStatus (status, description) VALUES ('Pending', 'The Contact has not been Activated.');

Is there anything clearly wrong with this SQLite syntax?

What does that cursor expect from me??

Thanks
SOLUTION
Bill Bach
President and Btrieve Guru

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros