Home » U++ Library support » U++ SQL » SQLite queries problem
SQLite queries problem [message #16430] |
Sat, 14 June 2008 12:12 |
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
-- 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?
|
|
|
Goto Forum:
Current Time: Fri May 10 02:54:35 CEST 2024
Total time taken to generate the page: 0.01819 seconds
|