U++ framework: U++ SQL » SQLite queries problem

Home » U++ Library support » U++ SQL » SQLite queries problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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'

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?

Report message to a moderator

Re: SQLite queries problem [message #16431 is a reply to message #16430]

Sat, 14 June 2008 12:23

unodgs
Messages: 1367
Registered: November 2005
Location: Poland

Ultimate Contributor

shouldn't be select * from..

Report message to a moderator

Re: SQLite queries problem [message #16434 is a reply to message #16431]

Sat, 14 June 2008 17:11

Mindtraveller
Messages: 917
Registered: August 2007
Location: Russia, Moscow rgn.

Experienced Contributor

That helped, thanx! Smile

Report message to a moderator

Previous Topic:	MySQL easy guide
Next Topic:	Quick explanation of function calls for postgresql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Apr 26 09:24:42 GMT+2 2026

Total time taken to generate the page: 0.00485 seconds