[sqlite] Replicating table data from sqlite to ms sql server

Hello there, I'm new to sqlite and I was wondering if there is a way to programmatically replicate table data from a database in sqlite server to another database in ms sql server? I'm hoping to do this without any user intervention(the application will do it automatically). Is this possible?

Re: [sqlite] storing floating point values in field

I've run SQLite3 inWindows, it's store up it surely did not truncate the decimal point - up to 15 significant digits... regards, Radzi. - Original Message - From: "folabi" <[EMAIL PROTECTED]> To: Sent: Tuesday, July 10, 2007 3:20 AM Subject: [sqlite] storing

Re: [sqlite] FTS and upgrades

If you have not compiled in fts1, and try to drop an fts1 table, you'll get an error. I don't think you'll get a crash, but sqlite will simply not know how to deal with the table. I can think of two ways to deal with this. When builidng a new version, you could just leave the fts1 code in

Re: [sqlite] sqlite3_bind_text

yes.. i get it... the thing is that my str is more like str[][] = {"1,2","2,5,6","2,3,6,7,8","1,2,9"}; so i think i'm staying with for (i=0;i

Re: [sqlite] sqlite3_bind_text

You could also do this Query = sqlite3_mprintf("select name from foo where id = ?"); rc = sqlite3_prepare_v2(DB,Query ,-1,,NULL); char str[20][5] = {"32","2","66","3","88"} ; for (i=1;str[i]; i ++) { sqlite3_reset() ; sqlite3_bind_text(Statement,1,str[i],-1,NULL); do {

Re: [sqlite] sqlite3_bind_text

You can not provide in list items using bind as you described However you can do this: Query = sqlite3_mprintf("select name from foo where id in (%s, %s, %s, %s, %s)", str1, str2, str3, str4, str5); rc = sqlite3_prepare_v2(DB,Query ,-1,,NULL); Then step through the query results...

[sqlite] sqlite3_bind_text

I'm not quite sure if what i'm doing is correct. i have a table with id's and names.. table foo{ id INTEGER PRIMARY KEY, name varchar } then, i have to get all the names of a group (variable length) of elements in foo(i have the id's in ONE string) so i did this. Query =

[sqlite] storing floating point values in field

Hi, I stored a floating point number in a sqlite field with datatype REAL. However, when i wanted to retrieve the data, sqlite returned a rounded value back. ie. double val = 23.123567 stored as REAL sqlite returns 23.1236 Could someone pls confirm if this is consistent behaviour in sqlite?

RE: [sqlite] Using SQlite with .NET

Thanks for the heads up :) -Original Message- From: Samuel R. Neff [mailto:[EMAIL PROTECTED] Sent: Friday, July 06, 2007 2:49 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Using SQlite with .NET There are a few .NET wrappers for SQLite. I would suggest System.Data.SQLite

Re: [sqlite] Views

To clarify, if I have the three join SELECT statement in code or i have the same three join SELECT in a view, once I do the prepare it should pretty much be same as in my case they are simple one-to-one joins returning 0 or 1 row max. Thanks Mike Joe Wilson <[EMAIL PROTECTED]> wrote: --- Mario