hankknight
asked on
SQLite: What is wrong with my query?
ASKER
I don't think that the problem is because there are too many columns.
The database works, it just won't take my SQL to insert additional items.
Please test the attached database, thanks.
q2.txt
forexWorkingDB.txt
The database works, it just won't take my SQL to insert additional items.
Please test the attached database, thanks.
q2.txt
forexWorkingDB.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
P.S. the number of columns looked suspect to me, but I did not mention anything. However, I just had a chance to download the database and a simple SELECT from the trades table yields the following error. Therefore, you may have multiple issues going on. In fact, this may be the main error. Single quotes are the typical delimiter for literals—at least for those of us who also use SQL Server. However, I tried the following simple test in a new database.
Open in new window
Open in new window
Everything worked fine. When I try the same two queries in your database I get the error above even though I am not querying the trades table. It appears it corrupts the entire database, which makes sense as the error is regarding the schema.