Does anyone know what the course of action is for recovering from a table
locked error?
I dropped a table and I got the error code 6 (Table Locked Error). After two
weeks of pulling my hair I guessed that the error was not for my table being
dropped. It was for the sqlite_master table being
There is a lot of information about disk file concurrency model.
I have not found much information regarding the in memory database
concurrency model.
Thanks,
-Alex
___
sqlite-users mailing list
sqlite-users@sqlite.org
Write a C test.c program that uses the desired type. Then do "gcc -E test.c
> test.txt".
This will expand/flatten all the macros. Open the test.txt file and look for
the type.
On Mon, Aug 25, 2008 at 5:30 PM, Brown, Daniel <[EMAIL PROTECTED]> wrote:
> Good afternoon list,
>
> I'm attempting to
Hi,
What can cause an in memory database a table lock error besides not
finalizing statements?
Thanks,
-Alex
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Just a note. If you change the #define settings to the below values you also
get table locks
#define MAX_THREAD 100
#define MAX_LOOP 100
Thanks,
-Alex
On Sat, Aug 23, 2008 at 3:35 PM, Alex Katebi <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am getting a table lock for no appare
Hi,
I am getting a table lock for no apparent reason in my application.
To reproduce this I have written a test file that behaves the same way with
the difference that it reports database lock instead of table lock. My
application database is in memory the test uses a file database. I think it
Most people are using it the way you described. I assume they had success
since it is the most widely deployed data base engine.
On Thu, Aug 21, 2008 at 12:07 PM, Ricardo Hawerroth Wiggers - Terceiro <
[EMAIL PROTECTED]> wrote:
> Hello.
>
> Has anyone used sqlite in a freestanding embedded
,
-Alex
On Tue, Aug 19, 2008 at 9:17 PM, Alex Katebi <[EMAIL PROTECTED]> wrote:
> You don't need to open a second connection. The sole connection can be used
> from any thread.
>
>
> On Tue, Aug 19, 2008 at 6:17 PM, vincent cridlig <[EMAIL PROTECTED]>wrote:
>
&g
Hi,
For a in memory connection I get table lock error 6.
I have one in memory connection with many prepared statements for different
tables.
Depending how the statements are interleaved I get a table lock error when
dropping a table.
What is causing of this?
I did turn on tracing. I am
Boy I was off on that one. The stmt is not going to help my case. The users
context that is already there can help me.
Sorry,
-Alex
On Wed, Aug 20, 2008 at 8:52 PM, Alex Katebi <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I am using the sqlite3_trace to track down a bug. It is
Hi All,
I am using the sqlite3_trace to track down a bug. It is lacking a vital
information that is needed for tracing. The stmt handle is necessary in
order to identify related statements. Notice the sqlite3_stmt that I have
added below.
void *sqlite3_trace(sqlite3*, void(*xTrace)(void*,const
Write the missing functions with using the equivalent VxWorks functions.
example:
int exit(int a)
{
vxworks_exit(a);
}
On Wed, Aug 20, 2008 at 4:16 AM, Kershaw, Anthony (UK) <
[EMAIL PROTECTED]> wrote:
>
> Hi,
> Have been trying to compile (and run) the amalgamated version of sqlite
>
You don't need to open a second connection. The sole connection can be used
from any thread.
On Tue, Aug 19, 2008 at 6:17 PM, vincent cridlig <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I would like to use transactions from separate threads, each thread having
> one connection to a single in-memory
How can I run the SQLite TCL test scripts?
Thanks,
-Alex
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
No I don't mean offline use. I mean it would be nice to have links on the
sqlite.org for all documents and resources.
On Tue, Jul 8, 2008 at 1:42 PM, Mihai Limbasan <[EMAIL PROTECTED]> wrote:
> Alex Katebi wrote:
> > Is there any way to get to all of these docs you mentione
Is there any way to get to all of these docs you mentioned from the home
page of the sqlite.org?
Thanks,
-Alex
On Tue, Jul 8, 2008 at 2:31 AM, Roger Binns <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Aditya Bhave (adbhave) wrote:
> > I am interested in
--
> Hash: SHA1
>
> Alex Katebi wrote:
> > I was able to get the attachment myself. It could be your email server.
>
> Are you sure? I was looking at the actual raw message. My mail server
> is postfix with messages funneled through clamassassin and spamassassin.
>
How about this one?
On Thu, Jul 3, 2008 at 9:39 PM, Roger Binns <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Alex Katebi wrote:
> > sqlite3_errmsg(db) does not provide the correct error message but
> > sqlite_exec(...) does
sqlite3_errmsg(db) does not provide the correct error message but
sqlite_exec(...) does.
I have attached my test code. You can compile it by doing below:
gcc x.c -lsqlite3
___
sqlite-users mailing list
sqlite-users@sqlite.org
wherein I could validate the SQL
> statement (for correct grammar, resource name - column name, table name
> etc), w/o having to do prepare.
>
> Thanks in advance
>
>
>
> --- On Wed, 7/2/08, Alex Katebi <[EMAIL PROTECTED]> wrote:
> From: Alex Katebi <[EMAIL PROT
This is the way I hoped it should work, and it does.
Thanks so much Igor!
-Alex
On Wed, Jul 2, 2008 at 9:39 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> "Alex Katebi" <[EMAIL PROTECTED]>
> wrote in message
> news:[EMAIL PROTECTED]<[EMAIL PROTECTED]>
>
table,
you can safely do so
if you use temporary tables. When a connection creates or writes to a
temporary table, it does
not have to get a RESERVED lock, because temporary tables are maintained
outside of the database
On Wed, Jul 2, 2008 at 7:25 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote
Igor,
Notice that I have multiple stmts stepping over the same table at the
same time.
Why is this OK? There isn't a table level lock?
When is a table locked?
Thanks,
-Alex
On Wed, Jul 2, 2008 at 5:12 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Alex Katebi <[EMA
I created a test file. It is attached in this email. I can not see any
locking happening at all.
On Wed, Jul 2, 2008 at 4:25 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Alex Katebi <[EMAIL PROTECTED]> wrote:
> > Do I need to enable shared cache mode plus read uncomm
or Tandetnik <[EMAIL PROTECTED]> wrote:
> Alex Katebi <[EMAIL PROTECTED]> wrote:
> > Just to make myself clearer. I have one memory connection and many
> > stmts.
> > Each stmt multiplexes the thread. This means that a stmt could give
> > up the
> > thread
Alexey,
Do you mean the sqlite3_busy_timeout( ) ?
I never thought I could use it for simulating this.
I will give that a shot.
Thanks,
-Alex
On Wed, Jul 2, 2008 at 11:40 AM, Alexey Pechnikov <[EMAIL PROTECTED]>
wrote:
> В сообщении от Wednesday 02 July 2008 19:11:58 Alex Katebi
Just to make myself clearer. I have one memory connection and many stmts.
Each stmt multiplexes the thread. This means that a stmt could give up the
thread without finalizing itself.
On Wed, Jul 2, 2008 at 11:19 AM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Alex Katebi <[EMA
Hi Igor,
I have an in memory database and a single multiplexed thread for all
readers and writes.
I like to be able to read tables without locking out other readers and
writers.
Is this possible? I don't mind writers using locks but some of my readers
are slow and I don't want them to hold
Can you update your SQLite to the latest revision?
On Tue, Jul 1, 2008 at 3:42 PM, smlacc1 leador <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm having some trouble with blobs. I have 4 blobs tht I want to insert
> into a db, and it works fine when I execute each insert as a single commit.
> However,
one or more longest mask
nexthop values.
I want to make a view for the above select and pass in a destination
variable as parameter.
Thanks,
-Alex
On Tue, Jul 1, 2008 at 2:41 PM, Stephen Woodbridge <[EMAIL PROTECTED]>
wrote:
> Alex Katebi wrote:
> > The problem with the view
Table level locking is used among statements for the same connection. File
level locking is used among connections. Your case is file level.
On Tue, Jul 1, 2008 at 8:00 PM, Joanne Pham <[EMAIL PROTECTED]> wrote:
> Hi All,
> I read the online document regarding "Table Level Locking" as below:
>
The problem with the view is that you can not pass a parameter or variable
from the outer select to the views select.
On Mon, Jun 30, 2008 at 12:49 AM, Igor Tandetnik <[EMAIL PROTECTED]>
wrote:
> "Henrik Bechmann" <[EMAIL PROTECTED]>
> wrote in message news:[EMAIL PROTECTED]
> > Thanks Igor! And
No. The range is for 64 bit signed. SQLite has manifest typing it is like
Ruby Duck Typing or Dynamic Typing. The value defines the type not the
column type or lack there of it.
If you value is a small integer it will only use 1 byte.
On Sat, Jun 28, 2008 at 6:02 PM, freeav8r <[EMAIL PROTECTED]>
Steven,
If SQLite runs on ARM9/Linux, then I don't see any problems. I think you
should watch the SQLite video on youtube.
http://www.youtube.com/watch?v=giAMt8Tj-84
Enjoy!
-Alex
2008/6/24 Steven Woody <[EMAIL PROTECTED]>:
> Hi,
>
> I am considering to use SQLite in my current embedded
I have no way of knowing which rows a select command has visited for an
indexed table.
create table t(a);
create index it on t(a);
insert ...
select * from t where a=5;
Is there a select hook for debugging?
Thanks,
-Alex
___
sqlite-users mailing list
In sqlite source code. src/test_schema.c
On Tue, Jun 24, 2008 at 4:57 PM, <[EMAIL PROTECTED]> wrote:
> Is there any example source code available that demonstrates a working
> virtual table implementation?
>
> Thanks
> Dan Winslow, GamePlan
> 402-991-5875 x219
> [EMAIL PROTECTED]
>
> Third Nerd
>
> Alex Katebi wrote:
> > slowness is fixed. Can't tell the difference between client/server speed
> > from library.
> >
> > On Sat, Jun 14, 2008 at 8:32 PM, Alex Katebi <[EMAIL PROTECTED]>
> wrote:
> >
> >
> >>Hi All,
> >
slowness is fixed. Can't tell the difference between client/server speed
from library.
On Sat, Jun 14, 2008 at 8:32 PM, Alex Katebi <[EMAIL PROTECTED]> wrote:
> Hi All,
>
>Looks like there is some interest. I will announce when I release it.
> Currently I am developing a
reason. I need to fix this
issue.
Thanks,
-Alex
On Mon, Jun 2, 2008 at 11:40 AM, Alex Katebi <[EMAIL PROTECTED]> wrote:
>
> Hi All,
>
> I am using remote procedure calls (RPC) for SQLite in my application. I
> have implemented a few SQLite RPC functions that I needed
I can still keep my routes in text presentation notation like 1.1.0.0/16 or
fe80::/16.
Thanks,
-Alex
On Thu, Jun 12, 2008 at 7:32 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
>
> On Jun 12, 2008, at 6:35 PM, Alex Katebi wrote:
>
> > The custom sqlite3_create_coll
The custom sqlite3_create_collation( ) is a perfect solution for
implementing an Internet Protocol Routing Table.
But I am not sure if SQLite will call a custom collation function if column
values are blobs. In other word, are blobs considered for collation?
One can format a blob with route
to implement my own
SQL Engine. :-)
Thanks,
-Alex
On Wed, Jun 11, 2008 at 3:21 PM, Nicolas Williams <[EMAIL PROTECTED]>
wrote:
> On Tue, Jun 10, 2008 at 12:35:14PM -0400, Alex Katebi wrote:
> > Peter,
> >I am using my own implementation. I found RPC and others too
>
such as an embedded server page processor and and compiler
> plus a security shell and would be a handful to maintain and document in
> great detail but if you are interested in chunks of code contact me.
>
> Alex Katebi wrote:
> > John,
> >
> >My server uses ep
!
-Alex
On Wed, Jun 11, 2008 at 9:36 AM, Dennis Cote <[EMAIL PROTECTED]> wrote:
> Alex Katebi wrote:
> > However there are two things I don't like about this method. One is that
> I
> > need to parse the prepared statments and prefix queries, and replace the
> >
>
> Based on our experience you should be very happy with your Sqlite based
> RPC capability.
>
> Alex Katebi wrote:
> > John & John,
> >
> >Actually my API used to be XML using SCEW a DOM like XML parser that
> uses
> > Expat.
> >
> >
Try this link.
http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions
On Tue, Jun 10, 2008 at 12:39 AM, Stephen Woodbridge <
[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I was reading through the sqlite source and noticed that there appears
> to be an ability to build and extension that is
I just noticed that you are returning from your function before finalize.
On Tue, Jun 10, 2008 at 10:12 AM, piotro <[EMAIL PROTECTED]> wrote:
> Hello. I really need help with this, because Im almost out of
> ideas here. Help please!
>
> sqldata is a vector< vector < char* > >
> row is a vector <
For starters sqlite3_column_count( ) should be after prepare once.
You don't need to do it for every step.
The other thing is do you have to use STL when you can do everything by
using SQLite?
Tell us in English what you want to accomplish with your code. We can come
up with a pure SQLite
this seems to be
the only choice.
Thanks,
-Alex
On Tue, Jun 10, 2008 at 4:33 PM, Dennis Cote <[EMAIL PROTECTED]> wrote:
> Alex Katebi wrote:
> > The only ugliness is that select locks the tables. I wish D. Hipp would
> give
> > us an option for pStmt to create a temporary ta
at 10:09 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
>
> On Jun 9, 2008, at 9:58 PM, Russell Leighton wrote:
>
> >
> > On Jun 9, 2008, at 8:52 PM, Igor Tandetnik wrote:
> >
> >> "Alex Katebi" <[EMAIL PROTECTED]>
> >> wrote in messa
Arjen,
Thanks!
On Tue, Jun 10, 2008 at 1:39 PM, Arjen Markus <[EMAIL PROTECTED]>
wrote:
> > I am going to guess yes.
> >
> > On Mon, Jun 9, 2008 at 9:58 PM, Russell Leighton
> > <[EMAIL PROTECTED]>
> > wrote:
> >
>
> >>
> >> Aren' t there aligment and endian issues as well as potential floating
ide is the complexity of the XML parser at the receive end.
>
> Alex Katebi wrote:
> > I am trying to implement remote procedure calls (RPC) for SQLite API to
> be
> > used in my application.
> > In particular sqlite3_column_double( ) returns a floating point double.
> &g
I am going to guess yes.
On Mon, Jun 9, 2008 at 9:58 PM, Russell Leighton <[EMAIL PROTECTED]>
wrote:
>
> On Jun 9, 2008, at 8:52 PM, Igor Tandetnik wrote:
>
> > "Alex Katebi" <[EMAIL PROTECTED]>
> > wrote in message
> > news:[EMAIL PROTECTED]
Igor,
You are right. The answer is to use 8 byte buffer and don't forget to
account for the endianess.
I had a bug in my code.
On Mon, Jun 9, 2008 at 8:52 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> "Alex Katebi" <[EMAIL PROTECTED]>
> wrote in message
>
A. Friend <[EMAIL PROTECTED]>
wrote:
> Alex Katebi wrote:
> > I am trying to implement remote procedure calls (RPC) for SQLite API to
> be
> > used in my application.
> > In particular sqlite3_column_double( ) returns a floating point double.
> > How can I write this d
There can only be one prepare per table at a time. The first prepare has to
be finalized before another one. Table is locked by the first prepare until
finalized.
On Tue, Jun 10, 2008 at 7:36 AM, Sabyasachi Ruj <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a very big table with around 40,00, 000
I am trying to implement remote procedure calls (RPC) for SQLite API to be
used in my application.
In particular sqlite3_column_double( ) returns a floating point double.
How can I write this double value into a TCP socket?
I have tried writing 8 bytes as integer values but the received valued at
You can do your own custom functions using the C extentions. You should buy
the book.
"The Definitive Guide SQLite"
On Thu, Jun 5, 2008 at 6:55 PM, Scott Baker <[EMAIL PROTECTED]> wrote:
> I have a database with coordinates in it. I'd like to calculate distance at
> the SQL level, but the
It would be nice to be able to revert back to the default value for a
column. I don't think SQLite support this right now.
The closest thing I found is "pragma table_info(foo)". If you prepare this
and then grab the dflt_value for your column.
On Tue, May 20, 2008 at 2:33 PM, Jeff Hamilton <[EMAIL
as it is unique.
Thanks,
-Alex
On Tue, Jun 3, 2008 at 2:23 PM, Mihai Limbasan <[EMAIL PROTECTED]> wrote:
> Alex Katebi wrote:
>
>> Hi All,
>>
>> For those of us that use SQLite mostly in-memory. Our context is mostly
>> not
>> {sqlite3*} database poi
Hi All,
For those of us that use SQLite mostly in-memory. Our context is mostly not
{sqlite3*} database pointer, it is {sqlite3_stmt*}.
Current API?
int sqlite3_set_authorizer(
sqlite3*,
int (*xAuth)(void*,int,const char*,const char*,const char*,const char*),
void *pUserData
);
Can we
All your dbs will have different values. It is a C pointer value not an
enumeration value.
On Tue, Jun 3, 2008 at 8:28 AM, Hildemaro Carrasquel <
[EMAIL PROTECTED]> wrote:
> Hello.-
>
> but how can i make a different between all db on RAM if you define as
> :memory: ?
>
> --
> Ing. Hildemaro
<[EMAIL PROTECTED]> wrote:
> On Mon, Jun 2, 2008 at 8:12 AM, Alex Katebi <[EMAIL PROTECTED]> wrote:
> > Hi Keith,
> >
> > Your observation is correct. I did not know that when selecting a table
> a
> > shared lock is aquired by the reader and writes are
n 1, 2008 at 2:19 PM, Alex Katebi <[EMAIL PROTECTED]>
> wrote:
> > Hi All,
> >
> > I have a in-memory database with some tables. Each table has a single
> > record writer and multiple readers.
> > Readers and writes prepare their own sqlite3_stmt for the
Hi All,
I have a in-memory database with some tables. Each table has a single
record writer and multiple readers.
Readers and writes prepare their own sqlite3_stmt for the db. Everyone
operates within a single thread.
What happens if a reader wants to read a record that has been deleted by the
THANKS Igor!
On Tue, Apr 29, 2008 at 6:38 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Alex Katebi <[EMAIL PROTECTED]> wrote:
> > Just want to make a note that when I say in-memory data base I don't
> > mean
> > the cache memory I mean the :memory: date base
I have an embedded application that uses a single :memory: database
connection. This application has a user interface via a networking socket
that receives SQL commands. The application tasks and the user interface
will use the single :memory: connection. I want to limit the user interface
for
http://www.amazon.com/Definitive-Guide-SQLite/dp/1590596730
Excellent book!
On Sat, Apr 19, 2008 at 12:37 PM, mikeobe <[EMAIL PROTECTED]> wrote:
> i found it boring to learn how to use sqlite, maybe we can write a
> tutorial for it, with examples,
> it will be much easier for the beginner to
Just want to make a note that when I say in-memory data base I don't mean
the cache memory I mean the :memory: date base.
On Tue, Apr 29, 2008 at 5:39 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Alex Katebi <[EMAIL PROTECTED]> wrote:
> > I am planning to use only in-me
table needs
to be updated by my application. Can you tell be why there would be no lock
contention?
Thanks!
-Alex
On Tue, Apr 29, 2008 at 5:39 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Alex Katebi <[EMAIL PROTECTED]> wrote:
> > I am planning to use only in-me
Hi,
I am planning to use only in-memory data base for my application. I have
couple of questions?
1) Would SQLite still make Rollback Journal files? If yes can it be turned
off with pragma, etc.?
2) If I have a single in-memory connection with multiple
statements, should I worry about
Does this mean that if I have one connection and multiple statements
operating on a in-memory table within a single thread no statement will lock
out another? In other words locks will not be used?
On Sat, Apr 26, 2008 at 7:40 PM, Joanne Pham <[EMAIL PROTECTED]> wrote:
> Hi,
> One
Hello Everyone,
I am designing an IP Routing Software. Work arrives via telnet clients or
routing control packets. I am planning to use the POSIX select function to
handle all work in a single loop in one thread. I will have one
SQLite memory connection for my routing tables. When a user
ame time, you're going to handle
> merging the config changes in a sensible way and handle conflicts.
>
> -scott
>
>
> On Thu, Apr 17, 2008 at 5:08 PM, Alex Katebi <[EMAIL PROTECTED]>
> wrote:
> > Scott,
> >
> > Every user will have thier own sqlite conn
internal semantics), when upper management comes
> to you with some crazy feature request which does not conform to the
> SQL transaction model, you'll be able to change things without too
> much pain.
>
> -scott
>
> (*) http://www.sqlite.org/cvstrac/wiki?p=UndoRedo
>
>
> On
f probably indicates that there's a disconnect in how you're
> trying to model the problem, but without knowing what the problem is,
> it's hard to do much.
>
> -scott
>
> On Thu, Apr 17, 2008 at 12:43 PM, Alex Katebi <[EMAIL PROTECTED]>
> wrote:
> > The re
Yap I was wrong about triggers. Triggers are part of the same connection. So
I will try your suggestions. I will let you know how I made out. And thanks
so much for clearing my mistakes.
-Alex
On Thu, Apr 17, 2008 at 6:06 PM, Alex Katebi <[EMAIL PROTECTED]> wrote:
> I remember trying
wrote:
> Alex Katebi wrote:
> > My problem is that triggers don't trigger until after commit.
> >
>
> No, that is not your problem. You haven't tried anything yet.
>
> This is a trace of SQlite executing the code I posted. There is not a
> commit in sight, a
I remember trying it before but I will try it again. Maybe I was wrong. I
will let you know.
Thanks!
On Thu, Apr 17, 2008 at 4:43 PM, Dennis Cote <[EMAIL PROTECTED]> wrote:
> Alex Katebi wrote:
> > But triggers don't trigger until commit.
> >
>
> That is not true
My problem is that triggers don't trigger until after commit.
On Thu, Apr 17, 2008 at 4:52 PM, Dennis Cote <[EMAIL PROTECTED]> wrote:
> Alex Katebi wrote:
> > I will give a simple example:
> >
> > create table t1(name);
> > insert into t1('Alex');
> > be
d of the rows you modify.
>
> -scott
>
>
> On Thu, Apr 17, 2008 at 12:33 PM, Alex Katebi <[EMAIL PROTECTED]>
> wrote:
> > Hi Richard,
> >
> > create table t1 (name);
> > insert into t1 values ('Alex');
> > begin;
> > insert into t1 va
selects right?
Thanks,
-Alex
On Thu, Apr 17, 2008 at 2:38 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
>
> On Apr 17, 2008, at 2:35 PM, Alex Katebi wrote:
> > Is there a way to select rows that have not been committed yet?
> >
>
> No. SQLite doesn't really
TED]> wrote:
> Alex Katebi wrote:
> > Actually I am not interested on rows that have been committed. I am
> > interested on the rows that have been changed but not commited yet. As I
> > understand the triggers trigger of of a commit.
> > The example that you are refer
Is there a way to select rows that have not been committed yet?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
in seeing the rows that are in my transaction
queue before the commit.
On Thu, Apr 17, 2008 at 1:54 PM, Dennis Cote <[EMAIL PROTECTED]> wrote:
> Alex Katebi wrote:
> >Can you give an example on how to use this. Basically I want to see
> > (select) only the uncommited rows.
before commit.
>
> Have a look here: http://www.sqlite.org/pragma.html
>
> Martin
>
> Alex Katebi schrieb:
> > Hi All,
> >
> > Let's say I start a transaction and do bunch of insertions etc. Before
> my
> > commit I
Hi All,
Let's say I start a transaction and do bunch of insertions etc. Before my
commit I like to show (select) what I have configured.
How can I accompilish this?
Thanks,
-Alex
___
sqlite-users mailing list
sqlite-users@sqlite.org
TED]> wrote:
> On 3/25/08, Alex Katebi <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I was woundering how I can update a column in my table back to its
> default
> > value.
> >
> > For example:
> >
> > create table t1 (value integ
Hello Puneet,
On Tue, Mar 25, 2008 at 1:40 PM, P Kishor <[EMAIL PROTECTED]> wrote:
> On 3/25/08, Alex Katebi <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I was woundering how I can update a column in my table back to its
> default
> > value.
>
Hi,
I was woundering how I can update a column in my table back to its default
value.
For example:
create table t1 (value integer default 55, name text);
insert into t1(name) values('hello');
update t1 set value=default; /* for illustration only */
How can I achive the desired behavior short
Hi All,
I am using sqlite to make an IP routing table. A routing table has a
Destination and a Mask column. I chose blob for my types since IPv6 will be
16 bytes long, IPv4 is only 4 bytes.
The query will be some IP packet destination address that needs to be
forwarded in the internet. This
I don't think many people have your problem. I mean using Sqlite towards using
PostGres.
Please let's not pollute Sqlite.
Thanks,
Alex Katebi
- Original Message
From: P Kishor <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Friday, January 11, 2008 2:19:23 PM
S
92 matches
Mail list logo