Hi,
I am using sqlite 2.8.13 which is supposed to have fix for "Corrupt problem
encountered on Windows NT platform" check this
(http://www.sqlite.org/cvstrac/tktview?tn=599). But the code in pager.c still
has the following rc = write32bits(&pPager->jfd, pPager->noSync ? 0x :
0); .
Hi,
I am using sqlite 2.8.13 which is supposed to have fix for "Corrupt problem
encountered on Windows NT platform" check this
(http://www.sqlite.org/cvstrac/tktview?tn=599). But the code in pager.c still
has the following rc = write32bits(&pPager->jfd, pPager->noSync ? 0x :
0); .
Robert Zajda <[EMAIL PROTECTED]>
wrote:
This solution seems to works ok. As I understand that "-1" is used for
temporary. But how about two actions in the same time ? I'm
implementing this in web application for changing position of
articles. When two different users do the same action with the s
On 11/13/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
Robert Zajda <[EMAIL PROTECTED]>
wrote:
> On 11/12/06, Igor Tandetnik <[EMAIL PROTECTED]>
> wrote:
>> Robert Zajda
>> <[EMAIL PROTECTED]>
>> wrote:
Perhaps something like this:
update articles set order=-1 where order=:oldorde
Robert Zajda <[EMAIL PROTECTED]>
wrote:
On 11/12/06, Igor Tandetnik <[EMAIL PROTECTED]>
wrote:
Robert Zajda
<[EMAIL PROTECTED]>
wrote:
Perhaps something like this:
update articles set order=-1 where order=:oldorder
update articles set order=:oldorder where order=:neworder
update articles set
On 11/12/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
Robert Zajda <[EMAIL PROTECTED]>
wrote:
>> Perhaps something like this:
>>
>> update articles set order=-1 where order=:oldorder
>> update articles set order=:oldorder where order=:neworder
>> update articles set order=:neworder where order=-
Robert Zajda <[EMAIL PROTECTED]>
wrote:
Perhaps something like this:
update articles set order=-1 where order=:oldorder
update articles set order=:oldorder where order=:neworder
update articles set order=:neworder where order=-1
but how to define the row in this example ?
I don't understand
Ralph Wetzel <[EMAIL PROTECTED]> wrote:
might it be possible, that someone explains, why anyone would put
effort in this task? Aren't databases designed to keep data in
whatever
order... :-?
Imagine you want to store playlists in the database (lists of songs to
play). You may want to allow t
Have spent 2 days looking at all the different wrappers and the one ODBC
driver and maybe the best one is the commercial dll from Terra...
Still, I would be very interested what opinions are about the best (speed,
ease of use, so methods etc. close to ADO) way to connect.
This is from VB6/VBA. The
Hi folks,
might it be possible, that someone explains, why anyone would put effort
in this task? Aren't databases designed to keep data in whatever
order... :-?
Greetings, Ralph
Hello
I have little problem with changing order of rows. I have a simple
table articles:
CREATE TABLE articles
On 11/12/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
Bambero <[EMAIL PROTECTED]> wrote:
> I have little problem with changing order of rows. I have a simple
> table articles:
>
> CREATE TABLE articles (
> id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
> title VARCHAR,
> content VARCHAR,
> order
what are the available tools to convert a mysql db onto this engine ( sqlite3
) ?
thanks - i can take scripts (php, phyton, perhaps ruby although i dont have it
installed now) but any tool for windows would suffice too!
Bambero <[EMAIL PROTECTED]> wrote:
I have little problem with changing order of rows. I have a simple
table articles:
CREATE TABLE articles (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
title VARCHAR,
content VARCHAR,
order INTEGER UNIQUE,
);
when inserting row order is a copy of id (trigger
On 11/12/06, Gerry Snyder <[EMAIL PROTECTED]> wrote:
Bambero wrote:
> Hello
>
> I have little problem with changing order of rows. I have a simple
> table articles:
>
> CREATE TABLE articles (
> id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
> title VARCHAR,
> content VARCHAR,
> order INTEGER UNI
[EMAIL PROTECTED] wrote:
Hi All,
The function sqlite3_table_column_metadata() is giving the
error message "No such TableName.ColName" even if I pass correct table
name and col name
(All the parameters are correct).
Is there any problem with the API or Any extra care needs to be Tak
Bambero wrote:
Hello
I have little problem with changing order of rows. I have a simple
table articles:
CREATE TABLE articles (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
title VARCHAR,
content VARCHAR,
order INTEGER UNIQUE,
);
when inserting row order is a copy of id (trigger used).
I have
Hello
I have little problem with changing order of rows. I have a simple
table articles:
CREATE TABLE articles (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
title VARCHAR,
content VARCHAR,
order INTEGER UNIQUE,
);
when inserting row order is a copy of id (trigger used).
I have few rows
1, te
Hi All,
The function sqlite3_table_column_metadata() is giving the
error message "No such TableName.ColName" even if I pass correct table
name and col name
(All the parameters are correct).
Is there any problem with the API or Any extra care needs to be Taken?
Please let me Know
18 matches
Mail list logo