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 » SQLite queries problem
SQLite queries problem [message #16430] Sat, 14 June 2008 12:12 Go to next message
Mindtraveller is currently offline  Mindtraveller
Messages: 917
Registered: August 2007
Location: Russia, Moscow rgn.
Experienced Contributor

I`ve got another strange issue from SQLite.

First, I add new table:
create table if not exists perevod0 (p0 COLLATE NOCASE, p1 COLLATE NOCASE, p2 COLLATE NOCASE, p3 COLLATE NOCASE, p4 REAL, p5 INTEGER, p6 INTEGER, p7 COLLATE NOCASE, p8 COLLATE NOCASE, p9 COLLATE NOCASE, p10 COLLATE NOCASE, p11 COLLATE NOCASE)
and it works.

Then I add some records:
insert into perevod0 (p0, p1, p2, p3, p4, p5, p6, p7, p8, p9, p10, p11) values ('1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1')
and it works too.

But when I try to acquire added records:
select all from 'perevod0'
or
select all from perevod0

-- all I have is error

Quote:

ERROR near "from": syntax error(0): Preparing: select all from perevod0


As far as I know, such a primitive query should be executed without problems. Can anyone tell what is wrong and how to solve it?
Re: SQLite queries problem [message #16431 is a reply to message #16430] Sat, 14 June 2008 12:23 Go to previous messageGo to next message
unodgs is currently offline  unodgs
Messages: 1366
Registered: November 2005
Location: Poland
Ultimate Contributor

shouldn't be select * from..
Re: SQLite queries problem [message #16434 is a reply to message #16431] Sat, 14 June 2008 17:11 Go to previous message
Mindtraveller is currently offline  Mindtraveller
Messages: 917
Registered: August 2007
Location: Russia, Moscow rgn.
Experienced Contributor

That helped, thanx! Smile
Previous Topic: MySQL easy guide
Next Topic: Quick explanation of function calls for postgresql
Goto Forum:
  


Current Time: Thu Mar 28 17:28:22 CET 2024

Total time taken to generate the page: 0.01344 seconds