RE: [sqlite] Resetting primary key auto-increment after table re-create

Sorry...That's what I meant - scary you can insert into a table that has this property without first setting The propert off without re-seeding - ie. How Sybase and SqlServer handle this.. It would be good if this was documented a little clearer Thx all for your assistance - onward and upwa

Re: [sqlite] SQLite 2.8.13. Issues found with SQLite.exe

rayB wrote: Seems that dot-commands (.output, .separator, .nullvalue, etc) are now being rejected by SQLite.exe 2.8.13 when contained in files executed via the .read command. Error message text is: ‘unknown command or invalid arguments: "output". Enter ".help" for help’ I tired it and everythi

Re: [sqlite] 'show_datatypes' Question

On Mar 8, 2004, at 5:09 PM, Tito Ciuro wrote: You can write your own sqlite_get_table to package up all the types for you. I'd like to do that. Should I create my own TabResult struct, to store the column data or would I be doing too much work? Any pointers? I would see if you can't snarf the s

Re: [sqlite] Data types in 2.8.13

Tito Ciuro wrote: If I understand correctly, I should write my own sqlite_get_table() function with a custom callback which stores the column data somewhere, right? Would it be better to create my own TabResult struct, to store the column data or would I be doing too much work? The other thing

Re: [sqlite] 'show_datatypes' Question

Hello, On 8 mar 2004, at 18:57, Will Leshner wrote: Are you seeing these results with the callback or with sqlite_get_table. I'm betting sqlite_get_table, because the callback doesn't return results in that fashion. Anyway, you can't get the types with sqlite_get_table. Only with the callback.

Re: [sqlite] Data types in 2.8.13

Hello, On 8 mar 2004, at 18:47, Dennis Cote wrote: How are you interfacing to SQLite? Are you using the C API directly? If so, are you using sqlite_exec() with a callback function (the callback API), or are you using the sqlite_compile(), sqlite_step(), and sqlite_finalize() (the newer non-cal

RE: [sqlite] Resetting primary key auto-increment after table re-create

- Forwarded by Ben Carlyle/AU/IRSA/Rail on 09/03/2004 10:56 AM - Ben Carlyle 09/03/2004 10:54 AM To: "Roger Hawkins" <[EMAIL PROTECTED]>@CORP cc: Subject:RE: [sqlite] Resetting primary key auto-increment after table re-create Roger, "Roger Haw

[sqlite] SQLite 2.8.13. Issues found with SQLite.exe

Seems that dot-commands (.output, .separator, .nullvalue, etc) are now being rejected by SQLite.exe 2.8.13 when contained in files executed via the .read command.   Error message text is: ‘unknown command or invalid arguments:  "output". Enter ".help" for help’   Was this change intended?   Regards

Re: [sqlite] 'show_datatypes' Question

Will Leshner wrote: Anyway, you can't get the types with sqlite_get_table. Only with the callback. Sorry for the misleading information. By "only with the callback" I meant considering those two options, the callback is the only one of them that returns types. You can also create a VM out of your

Re: [sqlite] 'show_datatypes' Question

Tito Ciuro wrote: Hello, After reading quite a bit about 'show_datatypes' I still don't get its workings. After setting 'PRAGMA show_datatypes = ON;' I go ahead and perform a 'SELECT * FROM address_table LIMIT 1;' The resulting set contains 4 columns, 1 row: [0] --> ROWID [1] --> First [2] --

Re: [sqlite] Data types in 2.8.13

From: "Tito Ciuro" <[EMAIL PROTECTED]> > Now that 2.8.13 is out, is 'PRAGMA show_datatypes = ON' by default? I > wonder because I'm still not getting the data types in the result set. > > I posted a message yesterday and after upgrading to 2.8.13 I'm still > getting the same results. Can someone *p

Re: [sqlite] RMemory database from 2.8.9 to 2.8.13

At 8:16 AM +1100 3/9/04, Greg Obleshchuk wrote: Hi , I have an appllication for MS SQL Server which creates crosstab reports . To generate some extra speed out of the process I use SQLite (funning I think) as an in memory database. Has there been any improvements in speed or stability of the :memo

[sqlite] Data types in 2.8.13

Hello guys, Now that 2.8.13 is out, is 'PRAGMA show_datatypes = ON' by default? I wonder because I'm still not getting the data types in the result set. I posted a message yesterday and after upgrading to 2.8.13 I'm still getting the same results. Can someone *please* give me some pointers? Th

[sqlite] RMemory database from 2.8.9 to 2.8.13

Hi , I have an appllication for MS SQL Server which creates crosstab reports . To generate some extra speed out of the process I use SQLite (funning I think) as an in memory database. Has there been any improvements in speed or stability of the :memory: database since 2.8.9? I just want to know if

Re: [sqlite] Resetting primary key auto-increment after table re-create

> So what you are saying is that if I recreate the table I can insert all > the old values back into the newly created table (including the primary > key values) and the primary key column wont complain? That's a bit > scary! It's not scary, it's essential. In a real database, an integer primary

Re: [sqlite] rollout of 2.8.13 ???

Ralph Wetzel wrote: Wouldn't it be a nice idea to rollout 2.8.13, so that it reduces the amount of flood (on this list and the wiki) concerning already fixed bugs??? Version 2.8.13 is now on the website. -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 --