[sqlite] Changing Schema On The Fly

f possible.. Thanks! -- - Mitchell Vincent - K Software - Innovative Software Solutions - Visit our website and check out our great software! - http://www.ksoftware.net - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Changing Schema On The Fly

update through SQLite to make that happen. Thanks for the help! On 5/31/07, P Kishor <[EMAIL PROTECTED]> wrote: If you read <http://www.sqlite.org/datatype3.html> you will see that, "Each value stored in an SQLite database (or manipulated by the database engine) has one of the followin

Re: [sqlite] Changing Schema On The Fly

ght savings time, but are now as of 2007. SQLite relies on the underlying OS to handle these timezone/DST issues. In Windows versions prior to Vista, Windows only keeps one DST record per timezone - regardless of different past DST periods. --- Mitchell Vincent <[EMAIL PROTECTED]> wrote: > Th

[sqlite] Re: Changing Schema On The Fly

I guess this isn't possible after all? On 5/31/07, Mitchell Vincent <[EMAIL PROTECTED]> wrote: I have a set of databases that contain a date type called "timestamp". I need to make those "integer" so they come through the ODBC driver the right way. Is there any way to

Re: [sqlite] Re: Changing Schema On The Fly

Quite a bit easier said than done! :-) Thanks for the feedback Joe, I appreciate it! On 6/1/07, Joe Wilson <[EMAIL PROTECTED]> wrote: --- Mitchell Vincent <[EMAIL PROTECTED]> wrote: > I guess this isn't possible after all? Get the SQLite ODBC driver source code and alter it to

[sqlite] MMap On Solaris

in memory (assuming 8192 byte pages)? Thanks! -- - Mitchell Vincent - K Software - Innovative Software Solutions - Visit our website and check out our great software! - http://www.ksoftware.net - To unsubscribe, send email

Re: [sqlite] MMap On Solaris

<[EMAIL PROTECTED]> wrote: Mitchell Vincent wrote: > Working with some data conversion here (that will eventually go into > an SQLite database). I'm hoping you IO wizards can offer some help on > a question that I've been trying to get answered. > > I'm using Solaris 10 fo

[sqlite] DISTINCT and Indexes

invoice_master.ship_state from invoice_master; Can anyone help speed this query up for large(r) data sets or a suggest a more efficient way of getting the unique list of states? I'd sure appreciate it! Thanks! -- - Mitchell Vincent

Re: [sqlite] DISTINCT and Indexes

On 7/7/07, Mitchell Vincent <[EMAIL PROTECTED]> wrote: > > I have a query to get all states that a user might have entered, it is : > > SELECT DISTINCT customers.bill_state as the_result from customers > UNION SELECT DISTINCT invoice_master.bill_state FROM invoice_mas

Re: [sqlite] DISTINCT and Indexes

___ Need a vacation? Get great deals to amazing places on Yahoo! Travel. http://travel.yahoo.com/ - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Changing Database Encoding

the encoding correctly as any non-English text isn't accessible. I think I need to set the encoding to UTF8 now, though it "just worked" before, so I'm not sure what I accidentally did right the first time :-) Any help is appreciated! Thanks! -- - Mitche

Re: [sqlite] Changing Database Encoding

<[EMAIL PROTECTED]> wrote: > On 7/30/07, Mitchell Vincent <[EMAIL PROTECTED]> wrote: > > I've read a few places that it is not possible to change the encoding > > of a database once it's created. Is it possible to do it in some > > automated way with any of the comma

[sqlite] Query Indexes

x on lower(invoice_number) -- can I? -- - Mitchell Vincent - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] "database is locked" SQLITE_BUSY when db is on network drive...

is locked". > > NO ONE else is accessing this database file, so how is that possible? > > > what am i doing wrong? > > - chase > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] >

[sqlite] ltrime() and rtrim() not understood with ODBC?

: rtrim (1)" I thought at first that maybe sqlite3.exe just had extra extension functions compiled in but http://www.sqlite.org/lang_expr.html says ltrim and rtrim are "core". Is there something I have to do to get ltrim/rtrim to work over ODBC? T

Re: [sqlite] ltrime() and rtrim() not understood with ODBC?

; http://www.sqlite.org/cvstrac/chngview?cn=3698 > > What sqlite version is your ODBC driver? > > select sqlite_version(); > > --- Mitchell Vincent <[EMAIL PROTECTED]> wrote: > > If I use sqlite3.exe to execute the query "Select > > customer_id

Re: [sqlite] Resetting a Primary Key

ry key uses to track the next ID? If so, how can I do it? Thanks very much for the reply! On Nov 20, 2007 4:44 PM, <[EMAIL PROTECTED]> wrote: > > "Mitchell Vincent" <[EMAIL PROTECTED]> wrote: > > I have a primary key that auto increments and has apparently > >

Re: [sqlite] Resetting a Primary Key

for the invoice_items table has "NULL" hard coded in for item_id, so I know it's not accidentally being set to an existing value. On Nov 20, 2007 4:44 PM, <[EMAIL PROTECTED]> wrote: > > "Mitchell Vincent" <[EMAIL PROTECTED]> wrote: > > I have a primary

Re: [sqlite] Resetting a Primary Key

te <[EMAIL PROTECTED]> wrote: > > Mitchell Vincent wrote: > > Here we go. I am accessing the database through an ODBC connection > > using the most recent version from Christian's site.. > > > > The table schema : > > > > CREATE TABLE invoice_it

Re: [sqlite] Resetting a Primary Key

No triggers at all in the database. It's pretty vanilla.. On Nov 20, 2007 6:04 PM, <[EMAIL PROTECTED]> wrote: > "Mitchell Vincent" <[EMAIL PROTECTED]> wrote: > > > Here we go. I am accessing the database through an ODBC connection > > using the m

Re: [sqlite] Resetting a Primary Key

t; > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > -- - Mitchell Vincent - K Softwar

[sqlite] Strange .dump output

the import into another database. That is the only table name that is surrounded by the single quote and I can't for the life of me figure out why. Other table names have underscores, so what would be the reason of quoting that table name in the CREATE statement with single quotes? -- - Mitchell

Re: [sqlite] Strange .dump output

Sure enough, that's in the sqlite_master table. I guess I did do it back when I created the database but I can't imagine why.. Thanks! On Dec 11, 2007 2:19 PM, <[EMAIL PROTECTED]> wrote: > "Mitchell Vincent" <[EMAIL PROTECTED]> wrote: > > I've noticed somet

[sqlite] Moving from 2.8.16

from 2.6.18 to 3.3.13 *should* be pretty smooth. Other than the information here : http://www.sqlite.org/version3.html, is there anything I might run into with queries not working (like any date/time function differences?). I appreciate any tips or tricks anyone would like to share! -- - Mitchell

[sqlite] Last ID from Primary Key through ODBC

tables in order to preserve referential integrity. SELECT MAX(id) FROM TABLE is one option but it's pretty dangerous seeing as multipl people *could* be accessing this database file at the same time.. Are there alternatives? Thanks! -- - Mitchell Vincent

Re: [sqlite] Last ID from Primary Key through ODBC

I really don't know. Will it work the way I think it will? :-) On 3/3/07, Dan Kennedy <[EMAIL PROTECTED]> wrote: On Sat, 2007-03-03 at 19:18 -0500, Mitchell Vincent wrote: > I found the nifty ODBC driver for SQLite and have been trying to use > it to replace a 2.8 SQlite implementa

Re: [sqlite] Last ID from Primary Key through ODBC

On 3/4/07, Christian Werner <[EMAIL PROTECTED]> wrote: Dan Kennedy wrote: > > On Sat, 2007-03-03 at 19:18 -0500, Mitchell Vincent wrote: > > I found the nifty ODBC driver for SQLite and have been trying to use > > it to replace a 2.8 SQlite implementation in some de

[sqlite] SQLite 2 to SQLite 3 - Varchar sizes

of just "varchar" (or just use an SQLite 'type' of "text") ? -- - Mitchell Vincent - K Software - Innovative Software Solutions - Visit our website and check out our great software! - http://www.ksoftware.net - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] SQLite 2 to SQLite 3 - Varchar sizes

On 3/9/07, Christian Werner <[EMAIL PROTECTED]> wrote: Mitchell Vincent wrote: > > I have an old SQLite 2.8 database that shared it's schema with > PostgreSQL. One of the nifty things about PostgreSQL (that admittedly > has me spoiled) is the ability to just say "varcha

Re: [sqlite] SQLite 2 to SQLite 3 - Varchar sizes

r, etc.), you'll have to be a bit more creative. "awk" may be your friend. Derrell Fantastic idea, but I'm afraid this will all be on Windows. I'll see about getting a sed-like program to distribute with my converter, though, thanks!! -- - Mitchell Vincent - K Software - Inn

Re: [sqlite] SQLite 2 to SQLite 3 - Varchar sizes

On 3/9/07, Scott Hess <[EMAIL PROTECTED]> wrote: On 3/9/07, Mitchell Vincent <[EMAIL PROTECTED]> wrote: > I'm looking into ways of changing the schema type name when I do my > SQLite2->SQLite3 conversion. Most likely I'll have to pipe the .dump > from the SQLite2 db thro

[sqlite] SQlite 2.8.16 -> SQLite 3

to 3.3.13 normal? Thanks!! -- - Mitchell Vincent - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] SQlite 2.8.16 -> SQLite 3

data (I have do some that store lots of floating point numbers). I was impressed with SQLite before, now I'm REALLY impressed. Thank you!! -- - Mitchell Vincent - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Currency Formatting within SQLite

I know it's a long shot but is it possible to use the Windows API GetCurrencyFormat() function to format currency strings? I need a layer between my database and report generator to properly format currency (money) strings for various countries. -- - Mitchell Vincent - K Software - Innovative

Re: [sqlite] Re: Currency Formatting within SQLite

to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mitchell Vincent Sent: Friday, April 06, 2007 11:17 AM To: sqlite-users@sqlite.org

Re: [sqlite] Re: Re: Currency Formatting within SQLite

that I know it's possible I'll I'm sure I'll have all my questions answered as I read the documentation. Thanks again! On 4/6/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote: Mitchell Vincent <[EMAIL PROTECTED]> wrote: > Yes, I know about creating a function but I'm wonderin

[sqlite] Join Syntax Questions

I could swear I've done this type of thing before and am sure I'm overlooking something simple. Is this correct syntax? SELECT im.invoice_date as invoice_date,im.pay_by as due_date,im.invoice_id as invoice_id, im.invoice_number as invoice_number,im.invoice_date as created,im.status as status,

[sqlite] Query Optimization

SELECT customer_id FROM customers WHERE cust_balance != (select coalesce(sum(balance_due), 0) FROM invoice WHERE status='Active' AND invoice.customer_id = customers.customer_id) The above query is used to determine if any stored balances are out of date. It works very well but is *really* slow

Re: [sqlite] Update/Join Howto?

D. Richard Hipp wrote: On Thu, 2005-06-23 at 14:48 -0400, Mitchell Vincent wrote: UPDATE customer_detail SET customer_id = (SELECT customer_id FROM customers WHERE customers.customer_name = customer_detail.customer_name); This should work. Are you having problems? You'll need version

Re: [sqlite] Update/Join Howto?

D. Richard Hipp wrote: On Thu, 2005-06-23 at 15:32 -0400, Mitchell Vincent wrote: Shoot! I meant to say that I need it to work with 2.8.16 (which was the entire issue!).. *crosses fingers* any way to make that happen? Not really. Version 2 is in maintenance - meaning bugfixes only. All

Re: [sqlite] Problem with 2.8.13

our results to 2-character strings, you want double underscore, not double percent. That is an automatically generated query and in that particular case the search string was empty (it would normally go between the %'s).. Thanks! -

Re: [sqlite] SQLite and ODBC

Well put, Darren. Raymond, I would say that if you need ODBC then you need to use a different database (server) all together. SQLite fills the embedded database niche perfectly but it is not a replacement for MS-SQL, MySQl, PostgreSQl, Oracle or other database *servers*. If you need a RDBMS

Re: [sqlite] Newbie --question about multiple PCs accessing sqlite

nks. (B (BNo idea on this one, check the SQLite webpage.. (B (B-- (B- Mitchell Vincent (B- kBilling - http://www.k-billing.com (B (B (B- (BTo unsubscribe, e-mail: [EMAIL PROTECTED] (BFor additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Does Richard have a wish-list @ Amazon?

Well then, expect some books because SQLite has made me a lot of cash! Thanks Dr. Hipp - amazing work with SQLite! D. Richard Hipp wrote: Frederic Faure wrote: Does Richard have a wish-list over at Amazon or Barnes and Noble I have a wish-list on Amazon. :-) My name and email address at Amazon

Re: [sqlite] help with evaluation of sqlite db tool

dishonest to buy the software at the discounted price. If you intend on developing something to be used commercially just make sure you carefully read the academic license.. -- - Mitchell Vincent - kBilling - Invoice Software - http://www.k-billing.com Darren Duncan wrote: At 2:44 PM -0400 6

[sqlite] Join query help

So I'm sitting here in a pinch and my brain just refuses to work... 2 tables, a customer and an invoice table. What is the proper SQL to get all customers records, plus the sum of a column in the invoice table with a relation on the customer ID, but not all customers might have an invoice

Re: [sqlite] Join query help

Very nice, however that still only gives me the customer records if they have an invoice in the invoice_master table.. A sub-select or outer join or something of the sort is needed but I can't get it to work.. In PostgreSQL I might do : SELECT *,(SELECT sum(total) FROM invoice_master WHERE

Re: [sqlite] Join query help

Really appreciate your help! However that query doesn't give correct results (though it does give a row for every customer!!!).. The problem is the sum() in the join isn't qualified against the selected customer ID.. Using this : SELECT c.customer_number as customer_number

[sqlite] Vacuum Error with 2.8.16

sqlite> vacuum; SQL error: near "varchaä": syntax error sqlite> These databases had been made with an earlier version of SQLite.. Ideas? -- - Mitchell Vincent - kBilling - Invoices Made Easy! - http://www.k-billing.com

Re: [sqlite] Vacuum Error with 2.8.16

D. Richard Hipp wrote: On Thu, 2005-03-10 at 16:37 -0500, Mitchell Vincent wrote: sqlite> vacuum; SQL error: near "varchaÃ": syntax error sqlite> These databases had been made with an earlier version of SQLite.. Ideas? Not much to go on I thought maybe it had something to do

Re: [sqlite] Vacuum Error with 2.8.16

! -- - Mitchell Vincent - kBilling - Invoices Made Easy! - http://www.k-billing.com

Re: [sqlite] Vacuum Error with 2.8.16

Mitchell Vincent wrote: D. Richard Hipp wrote: Can you tell me what the original schema is? Replied in private with the schema. I'm also happy to send the custom compiled DLL and the database if you need it. Thanks!!! Any additional thoughts on this? I'm happy to provide any additional