Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » sqlite3: error in reference example
sqlite3: error in reference example [message #5703] Tue, 10 October 2006 16:40 Go to next message
forlano is currently offline  forlano
Messages: 1185
Registered: March 2006
Location: Italy
Senior Contributor
Hello,

I've run the reference/SQL_Sqlite3 package. No problem during compilation but the program produce no result. This what I got from the log file:

Luigi
=================================
* C:\upp\out\MSC8\SQL_Sqlite3.exe 10.10.2006 15:47:41, user: Luigi

ERROR no such table: SIMPLE_TEST1: Preparing: insert into SIMPLE_TEST1(ID, NAME, LASTNAME, BDATE) values (0, 'Joe', 'Smith', 20000101)
ERROR no such table: SIMPLE_TEST1: Preparing: insert into SIMPLE_TEST1(ID, NAME, LASTNAME, BDATE) values (1, 'Mike', 'Smith', 20000102)
ERROR no such table: SIMPLE_TEST1: Preparing: insert into SIMPLE_TEST1(ID, NAME, LASTNAME, BDATE) values (2, 'Jon', 'Goober', 20000103)
ERROR no such table: SIMPLE_TEST1: Preparing: delete from SIMPLE_TEST1 where ID > 3
ERROR no such table: SIMPLE_TEST1: Preparing: insert into SIMPLE_TEST1(ID, NAME, LASTNAME, BDATE) values (5, 'wrongname', 'wronglastname', 20010604)
ERROR no such table: SIMPLE_TEST1: Preparing: update SIMPLE_TEST1 set NAME = 'rightname', LASTNAME = 'rightlastname', BDATE = 20010604 where ID = 5
ERROR no such table: SIMPLE_TEST1: Preparing: insert into SIMPLE_TEST1(name,bdate) values(?,?)
ERROR no such table: SIMPLE_TEST1: Preparing: insert into SIMPLE_TEST1(name,bdate) values(?,?)
ERROR no such table: SIMPLE_TEST1: Preparing: insert into SIMPLE_TEST1(name,bdate) values(?,?)
ERROR no such table: SIMPLE_TEST1: Preparing: insert into SIMPLE_TEST1(name,bdate) values(?,?)
ERROR no such table: SIMPLE_TEST1: Preparing: select ID, NAME, LASTNAME, BDATE from SIMPLE_TEST1
ERROR no such table: SIMPLE_TEST1: Preparing: select * from SIMPLE_TEST1
Re: sqlite3: error in reference example [message #5721 is a reply to message #5703] Wed, 11 October 2006 07:54 Go to previous messageGo to next message
mirek is currently offline  mirek
Messages: 13975
Registered: November 2005
Ultimate Member
Works for me. You should be in debug mode to create DB schema, are you?
Re: sqlite3: error in reference example [message #5724 is a reply to message #5721] Wed, 11 October 2006 08:22 Go to previous message
forlano is currently offline  forlano
Messages: 1185
Registered: March 2006
Location: Italy
Senior Contributor
luzr wrote on Wed, 11 October 2006 07:54

Works for me. You should be in debug mode to create DB schema, are you?



Of course not! Now it works.
Thank you,
Luigi
Previous Topic: port CppSQLite3 to Upp
Next Topic: Postgres Support
Goto Forum:
  


Current Time: Mon Apr 29 00:16:25 CEST 2024

Total time taken to generate the page: 0.06529 seconds