[sqlite] SQLite Query truncating String column at 255 chars long
I have a table in a SQLite 3 database file (.db3), which has a TEXT column whose fields often can be 1024 chars long or more. My application connects to this file using SQLite.NET library (from Nuget) and runs a simple "SELECT * FROM tabRxBinder;" command to populate a DataTable object. Inside this DataTable, all strings belonging to that column are truncated. In my tests, they got almost all chopped at 255 chars long, and just one was 270 chars long, but also truncated. I googled and found some people struggling with similar problems, but couldn't find a solution. Can anyone help me on this? Thank you very much. PS. This is table structure in DDL: CREATE TABLE tabRxBinder ( idINTEGER PRIMARY KEY AUTOINCREMENT UNIQUE NOT NULL, tipo INTEGER NOT NULL, regex TEXTNOT NULL, chave TEXTNOT NULL); And this is the code that queries it: Dim filename As String = "\\myserver\myfolder\mydatabase.db3"Dim connectionstring = String.Format("Data Source='{0}';Version=3;", filename)Dim conn as System.Data.Common.DbConnection = New SQLite.SQLiteConnection(connectionstring) With {.ParseViaFramework = True}Dim dt as New DataTableUsing comm = conn.CreateCommand comm.CommandText = "SELECT * FROM tabRxBinder ORDER BY tipo, chave;" Dim rdr As Data.Common.DbDataReader conn.Open rdr = comm.ExecuteReader dt.Load(rdr) conn.CloseEnd Using ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite and SQL Server 2005
Thanks I forgot to include coding language (vb) Do you know where can i find a sample code. Thanks Again Sent from my iPhone On Oct 4, 2012, at 4:47 PM, Bart Smissaert <bart.smissa...@gmail.com> wrote: > What is your coding language? > If VB then maybe via ODBC and ADO. > > RBS > > > On Thu, Oct 4, 2012 at 9:11 PM, Jorge <cotrinago...@yahoo.com> wrote: >>> Hello, >> I am new in Sqlite. I would like to know what is the best option to update >> data in two directions from Sqlite to SQL Server 2005 >> >> Thx >> >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Sqlite and SQL Server 2005
> Hello, I am new in Sqlite. I would like to know what is the best option to update data in two directions from Sqlite to SQL Server 2005 Thx > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Segmentation fault on sqlite3_create_module
Hi, I do this: const char *table_structure = "CREATE TABLE network (vertex_id INTEGER);"; if (sqlite3_declare_vtab(db, table_structure) == SQLITE_OK) { nr = (NiuRouting*) sqlite3_malloc(sizeof (NiuRouting)); if (nr == NULL) { //*pzErr = sqlite3_mprintf("[NiuRouting module] CREATE VIRTUAL: No memory \n"); return SQLITE_NOMEM; } *ppVTab = (sqlite3_vtab*) nr; ((sqlite3_vtab*) nr)->zErrMsg = NULL; } else { //*pzErr = sqlite3_mprintf("[NiuRouting module] CREATE VIRTUAL: invalid SQL statement \n"); return SQLITE_ERROR; } and continue. i do somethig more comment all the code inside the functions and get the same error. when try to load extension i just see the first debug message i can see any more i think, that the program do no enter to any method. 2012/2/3 Stephan Beal <sgb...@googlemail.com> > 2012/2/3 Jorge Eliécer Osorio Caro <jorgeliecer.oso...@gmail.com> > > > Yes, that's my code: > > > > http://paste.ideaslabs.com/show/OPNHBY7xPG > > > > this the backtrace: > > > > #0 0x0001001701d3 in initialize_niurouting () > > > > Can you try the following (but i'm just guessing here); > > std::cerr << "virtual_table_name="< << ", network_structure_table=" > <<network_structure_table<< '\n'; > > after those vars are initialized, and change: > > std::string table_structure(...) > > to > const static std::string table_structure(...) > > sqlite3_declare_vtab()[1] does not document the lifetime requirements of > the string passed to it, and it's "conceivable" that the lifetime of the > table_structure string is the problem. > > :-? > > [1] = http://www.sqlite.org/c3ref/declare_vtab.html > > -- > - stephan beal > http://wanderinghorse.net/home/stephan/ > http://gplus.to/sgbeal > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Segmentation fault on sqlite3_create_module
Yes, that's my code: http://paste.ideaslabs.com/show/OPNHBY7xPG this the backtrace: #0 0x0001001701d3 in initialize_niurouting () #1 0x0001001709d5 in sqlite3_extension_init () #2 0x0001000499a3 in sqlite3_load_extension (db=0x100200090, zFile=0x10020f206 "/Volumes/Me/jorge.osorio/proj/niurouting/bin/niurouting.sqlext", zProc=0x1000a1480 "sqlite3_extension_init", pzErrMsg=0x7fff5fbfd778) at sqlite3.c:91718 #3 0x000155db in do_meta_command (zLine=, p=0x7fff5fbfe2e0) at ./src/shell.c:1885 #4 0x000140da in process_input (p=0x7fff5fbfe2e0, in=0x0) at ./src/shell.c:2481 #5 0x000171c8 in main (argc=2, argv=) at ./src/shell.c:2972 (gdb) it's strange Stepan, thanks for you help.. 2012/2/3 Stephan Beal <sgb...@googlemail.com> > 2012/2/3 Jorge Eliécer Osorio Caro <jorgeliecer.oso...@gmail.com> > > > OK there is the trace: > > > > Program received signal EXC_BAD_ACCESS, Could not access memory. > > Reason: KERN_INVALID_ADDRESS at address: 0x03b8 > > 0x00010017024b in initialize_niurouting () > > > > That's the reason for the crash but not the backtrace, so i can't say what > let up to the crash, but the "Reason" part is telling - the address 03b8 is > invalid. Are you sure you've properly initialized all of the > memory/variables in initialize_niurouting()? > > -- > - stephan beal > http://wanderinghorse.net/home/stephan/ > http://gplus.to/sgbeal > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Segmentation fault on sqlite3_create_module
OK there is the trace: Program received signal EXC_BAD_ACCESS, Could not access memory. Reason: KERN_INVALID_ADDRESS at address: 0x03b8 0x00010017024b in initialize_niurouting () 2012/2/3 Stephan Beal <sgb...@googlemail.com> > 2012/2/3 Jorge Eliécer Osorio Caro <jorgeliecer.oso...@gmail.com> > > > Ok, tthanks Stepha, how i can do that? i compile sqlite like ./configure > > --enable-debug but i cant do a trace to see what happend > > > > Assuming you're on a Linux (or similar) platform you can try: > > gdb --args sqlite3 dbfile > > then run it as normal until it crashes, then type "bt" to get a backtrace. > That will show what led up to the error. > > -- > - stephan beal > http://wanderinghorse.net/home/stephan/ > http://gplus.to/sgbeal > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Segmentation fault on sqlite3_create_module
Ok, tthanks Stepha, how i can do that? i compile sqlite like ./configure --enable-debug but i cant do a trace to see what happend 2012/2/3 Stephan Beal <sgb...@googlemail.com> > But finding out exactly where it fails requires either adding debug output > to the plug or running it (in this case the sqlite shell) through a > debugger. > > - stephan beal > http://wanderinghorse.net/home/stephan/ > http://gplus.to/sgbeal > On Feb 3, 2012 4:35 PM, "Jorge Eliécer Osorio Caro" < > jorgeliecer.oso...@gmail.com> wrote: > > > It's caused calling a sqlite_create_module trying to load an extension by > > sqlite3 shell. > > > > 2012/2/3 Stephan Beal <sgb...@googlemail.com> > > > > > 2012/2/3 Jorge Eliécer Osorio Caro <jorgeliecer.oso...@gmail.com> > > > > > > > Good morning every one, > > > > > > > > I having a issue when try to create a sqlite3_create_module. > > > > > > > > when try to load my extension im getting that error "Segmentation > > fault", > > > > cause the sqlite3 cash. i dont know how it happend its my code: > > > > > > > > http://paste.ideaslabs.com/show/OPNHBY7xPG > > > > > > > > > A segfault can be caused by at least 300 million different things. The > > > easiest way to figure out where the problem is is to run your app > through > > > gdb (or equivalent) and get a backtrace after it crashes. > > > > > > -- > > > - stephan beal > > > http://wanderinghorse.net/home/stephan/ > > > http://gplus.to/sgbeal > > > ___ > > > sqlite-users mailing list > > > sqlite-users@sqlite.org > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > ___ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Segmentation fault on sqlite3_create_module
It's caused calling a sqlite_create_module trying to load an extension by sqlite3 shell. 2012/2/3 Stephan Beal <sgb...@googlemail.com> > 2012/2/3 Jorge Eliécer Osorio Caro <jorgeliecer.oso...@gmail.com> > > > Good morning every one, > > > > I having a issue when try to create a sqlite3_create_module. > > > > when try to load my extension im getting that error "Segmentation fault", > > cause the sqlite3 cash. i dont know how it happend its my code: > > > > http://paste.ideaslabs.com/show/OPNHBY7xPG > > > A segfault can be caused by at least 300 million different things. The > easiest way to figure out where the problem is is to run your app through > gdb (or equivalent) and get a backtrace after it crashes. > > -- > - stephan beal > http://wanderinghorse.net/home/stephan/ > http://gplus.to/sgbeal > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Segmentation fault on sqlite3_create_module
Good morning every one, I having a issue when try to create a sqlite3_create_module. when try to load my extension im getting that error "Segmentation fault", cause the sqlite3 cash. i dont know how it happend its my code: http://paste.ideaslabs.com/show/OPNHBY7xPG ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] How to return many data sqlite extension
Hi Jay, Thanks its make to me a major panorama, so i need to create a virtual table in orde to add that result, that means that the user need to do 2 querys ones to execute my function and other to view that result? i see in spatialite extension do you know about it? that he has a virtual table that make a select and that return a structure in the same query: *SELECT * FROM Roads_net WHERE NodeFrom = 1 AND NodeTo = 512;* that make and special query into virtual table that take like param node_fromm node_to and return many data values like: ArcRowid NodeFrom NodeTo Cost Geometry NULL 1 512 22021.995764 BLOB sz=3376 GEOMETRY 1 1 4 3366.262555 NULL 11 4 16 1418.458904 NULT 15 16 20 868.499405 NULL 21 20 25 623.616463 NULL 22 25 24 186.070230 NULL http://www.gaia-gis.it/spatialite-2.3.0/spatialite-network-2.3.0.html Thanks. 2012/2/2 Jay A. Kreibich <j...@kreibi.ch> > On Thu, Feb 02, 2012 at 09:03:34AM -0500, Jorge Eli?cer Osorio Caro > scratched on the wall: > > > im trying to return many data in sql extension i have a function that > > return structure that have a name and age of many users. but i just can > > return text o int, but i dont know how to return a structure like a > table. > > > You can't. SQLite functions only deal with scalar values, as > functions are designed to be used inline with queries. What you're > speaking of is more like a stored procedure, which SQLite does not > support. > > You may be able to use a View, however, or even a Virtual Table, if > your query is very complex. > > -j > > > > > El 1 de febrero de 2012 13:48, Jorge Eli?cer Osorio Caro < > > jorgeliecer.oso...@gmail.com> escribi?: > > > > > Hi everyone i hope that you are ok. > > > > > > so im doing a sqlite extension that generate many data, i have a > structure > > > something like that: > > > > > > struct data { > > > char *name; > > > int age; > > > }; > > > > > > in the precess y create a listo of data: > > > > > > data *t = malloc(5 * sizeof(data)) > > > > > > i need to return that values in order that the user can fetch like a > > > table. using something like > > > sqlite3_result_value i dont know how to do that. > > > > > > Help. > > > > > > Thanks. > > > > > ___ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- > Jay A. Kreibich < J A Y @ K R E I B I.C H > > > "Intelligence is like underwear: it is important that you have it, > but showing it to the wrong people has the tendency to make them > feel uncomfortable." -- Angela Johnson > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] How to return many data sqlite extension
Hi, im trying to return many data in sql extension i have a function that return structure that have a name and age of many users. but i just can return text o int, but i dont know how to return a structure like a table. struct data { char *name; int age; }; El 1 de febrero de 2012 13:48, Jorge Eliécer Osorio Caro < jorgeliecer.oso...@gmail.com> escribió: > Hi everyone i hope that you are ok. > > so im doing a sqlite extension that generate many data, i have a structure > something like that: > > struct data { > char *name; > int age; > }; > > in the precess y create a listo of data: > > data *t = malloc(5 * sizeof(data)) > > i need to return that values in order that the user can fetch like a > table. using something like > sqlite3_result_value i dont know how to do that. > > Help. > > Thanks. > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] How to return many data sqlite extension
Hi everyone i hope that you are ok. so im doing a sqlite extension that generate many data, i have a structure something like that: struct data { char *name; int age; }; in the precess y create a listo of data: data *t = malloc(5 * sizeof(data)) i need to return that values in order that the user can fetch like a table. using something like sqlite3_result_value i dont know how to do that. Help. Thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] blocks of read/write
Hello! I'm working on a project using sqlite3 together with the uClinux + arm7 + lpc2468. the whole process of reading / writing is very slow, I wonder if someone knows a way to change the size of the blocks read / write to sqlite. someone has suggestions to improve the performance of the sqlite in read/write on filesystem!? Thank you! -- Regards, ++ Jorge Pereira, From: Olinda/Pernambuco/Brazil Blog: http://www.jorgepereira.com.br/ E-mail: [EMAIL PROTECTED], [EMAIL PROTECTED] Mobile: +55 (81) 8833-2484 My Public Key: http://www.jorgepereira.com.br/public.pgp +---+ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] specific size of block to write/read?
hy folks! anybody known for use specific size of block to write/read? thkz! -- Regards, ++ Jorge Pereira, From: Olinda/Pernambuco/Brazil Blog: http://www.jorgepereira.com.br/ E-mail: [EMAIL PROTECTED], [EMAIL PROTECTED] Mobile: +55 (81) 8833-2484 My Public Key: http://www.jorgepereira.com.br/public.pgp +---+ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] how to use specific size of block to write/read?
hy folks! anybody known that for use specific size of block to write/read? thkz! -- Regards, ++ Jorge Pereira, From: Olinda/Pernambuco/Brazil Blog: http://www.jorgepereira.com.br/ E-mail: [EMAIL PROTECTED], [EMAIL PROTECTED] Mobile: +55 (81) 8833-2484 My Public Key: http://www.jorgepereira.com.br/public.pgp +---+ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] problems with performance uclinux + sqlite
Hi Folks, Somebody there use sqlite + uclinux + arm7? my problems it's about slow time on querys (select/update/insert), my env below! # sqlite 3.5.7 # options for build: ./configure --prefix=$PWD/outdir --disable-tcl --host=arm-elf --enable-static --enable-releasemode --enable-threadsafe # cat /proc/version Linux version 2.6.11.8-hsc0 ([EMAIL PROTECTED]) (gcc version 2.95.3 20010315 (release)(ColdFire patches - 20010318 from http://fiddes.net/coldfire/)(uClinux<http://fiddes.net/coldfire/%29%28uClinux>XIP and shared lib patches from http://www.snapgear.com/)) #1055 Fri Apr 18 17:52:27 BRT 2008 # I try running on (SDCARD + FAT32) and ROMFS, but same performance somebody have ideas for a STUPID SLOWLY? -- Regards, ++ Jorge Pereira, From: Olinda/Pernambuco/Brazil Blog: http://www.jorgepereira.com.br/ E-mail: [EMAIL PROTECTED], [EMAIL PROTECTED] Mobile: +55 (81) 8833-2484 My Public Key: http://www.jorgepereira.com.br/public.pgp +---+ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] help with sql query / command SUM
Hi folks! I Have two tables, and i need access data from both. below it's my tables; CREATE TABLE Product ( CD_PROD INTEGER CONSTRAINT PK_PROD NOT NULL PRIMARY KEY AUTOINCREMENT, CD_REMT_COMM INTEGER CONSTRAINT FK_PROD_REMT_COMM REFERENCES Remote_command(CD_REMT_COMM), CD_IDEN_PROD TEXT NOT NULL, NM_PROD TEXT NOT NULL, CD_ALIQ INTEGER NOT NULL CONSTRAINT FK_PROD_ALIQ REFERENCES Aliquot(CD_ALIQ), CD_DEPA INTEGER NOT NULL CONSTRAINT FK_PROD_DEPA REFERENCES Department(CD_DEPA), CD_MEASURE_UNIT INTEGER NOT NULL CONSTRAINT FK_PROD_MEASURE_UNIT REFERENCES Measure_unit(CD_MEASURE_UNIT), FL_UNITARY_TICKET INTEGER NOT NULL, CONSTRAINT FL_PROD_COMIS CHECK(FL_PROD_COMIS in (0,1)), CONSTRAINT FL_STOCK_PROD_CTRL CHECK(FL_STOCK_PROD_CTRL in (0,1)) ); and CREATE TABLE Current_sale_item ( CD_CURR_SALE_ITEM INTEGER CONSTRAINT PK_CURR_SALE_ITEM NOT NULL PRIMARY KEY AUTOINCREMENT, CD_CURR_SALE INTEGER NOT NULL CONSTRAINT FK_CURR_SALE_ITEM_CURR_SALE REFERENCES Current_sale(CD_CURR_SALE), CD_PROD INTEGER NOT NULL CONSTRAINT FK_CURR_SALE_PROD REFERENCES Product(CD_PROD), QT_SALE_ITEM REAL NOT NULL, VL_INCR_ITEM REAL NULL, VL_DISCT_ITEM REAL NULL, CD_REMT_COMD INTEGER NOT NULL, FL_CANC INTEGER NOT NULL ); I execute this query below, following result. sqlite> SELECT si.CD_CURR_SALE_ITEM,si.QT_SALE_ITEM,p.CD_IDEN_PROD,p.NM_PRODFROM Current_sale_item si, Product p WHERE si.CD_PROD = p.CD_PROD; CD_CURR_SALE_ITEM|QT_SALE_ITEM|CD_IDEN_PROD|NM_PROD 1|2.0|-1|Motorola V66V 2|3.0|0003-1|Celular Sony 3|55.0|0005-1|Tabajara N195 4|1.0|-1|Motorola V66V 5|1.0|0002-1|Gradiente Strike 6|1.0|0002-1|Gradiente Strike 7|1.0|0002-1|Gradiente Strike 8|1.0|0002-1|Gradiente Strike 9|1.0|0002-1|Gradiente Strike 10|1.0|0002-1|Gradiente Strike 11|1.0|0002-1|Gradiente Strike 12|1.0|0002-1|Gradiente Strike 13|1.0|0002-1|Gradiente Strike 14|1.0|-1|Motorola V66V 15|1.0|-1|Motorola V66V sqlite> i need something for sum the second col, ex: *sqlite>* SELECT si.CD_CURR_SALE_ITEM,*SUM(si.QT_SALE_ITEM)*,p.CD_IDEN_PROD, p.NM_PROD FROM Current_sale_item si, Product p WHERE si.CD_PROD = p.CD_PROD; CD_CURR_SALE_ITEM|QT_SALE_ITEM|CD_IDEN_PROD|NM_PROD 1|2.0|-1|Motorola V66V 2|3.0|0003-1|Celular Sony 3|55.0|0005-1|Tabajara N195 4|1.0|-1|Motorola V66V * 5|9.0|0002-1|Gradiente Strike* 14|1.0|-1|Motorola V66V 15|1.0|-1|Motorola V66V * sqlite> * But, my example of query return this! :( * sqlite> *SELECT si.CD_CURR_SALE_ITEM,SUM(si.QT_SALE_ITEM),p.CD_IDEN_PROD, p.NM_PROD FROM Current_sale_item si, Product p WHERE si.CD_PROD = p.CD_PROD; si.CD_CURR_SALE_ITEM|SUM(si.QT_SALE_ITEM)|p.CD_IDEN_PROD|p.NM_PROD 15|72.0|-1|Motorola V66V *sqlite> * I need sum only col *si.CD_CURR_SALE* equals by p.CD_PROD Somebody can help-me?!
[sqlite] SQlite in PDA with Windows CE
Hello, Anybody Knowk to use sqlite embeden in a PDA??, I saw that i can download a .dll to windows, but can I use this dll in PDA? I saw the documentation but don't find anything about this. Anybody can I help me?? Thanks!!! _ Tecnología, moda, motor, viajes,…suscríbete a nuestros boletines para estar siempre a la última http://newsletters.msn.com/hm/maintenanceeses.asp?L=ES=ES=WCMaintenance=WL=http%3a%2f%2fmail.live.com
[sqlite] Sqlite 3.27 slow than 3.22
Dears, Why Sqlite 3.27 it's more slow than Sqlite 3.22 The next Query in Sqlite 3.22 cost 6.47 seconts and 20.3 seconds on Sqlite 3.27 Table with 732.000 records select strftime('%Y',fecha) as Ano, strftime('%m',fecha) as Mes, sum(Duracion) as Duracion,sum(Costo) as Costo,sum(1) as Cantidad from Llamada where Estado = 'AC' group by strftime('%Y',fecha),strftime('%m',fecha) order by strftime('%Y',fecha),strftime('%m',fecha) Many thanks in advance Jorge Mason
Re: [sqlite] sqlite with Visual Basic
No, no... there is not mentioned VBWrapper.zip 1) DLL for VB 6/5/4 like as ADO free!! by Javier Bermudez from Argentina. http://free.hostdepartment.com/j/javierbermudez/archivos/sqlite/index.html isn't active Visual Basic 6 http://www.ag-software.com/SQLite/default.asp it's OK, but it isn't VBWrapper.zip SQLHelper: http://groups.yahoo.com/group/sqlite/files/ (Works with VB5 & VB6; Get both pssql.zip and psvbutls32.zip ) I am not yahoo group member SQLitePlus COM DLL wrapper for SQLite (coded with C++/ATL). http://www.sqliteplus.com ($$) it isn't my favourite price!!! TIA Jorge - Original Message - From: "Jalil Vaidya" <[EMAIL PROTECTED]> To: "Jorge" <[EMAIL PROTECTED]>; "Carlos Garces" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 17, 2004 5:50 PM Subject: Re: [sqlite] sqlite with Visual Basic Check out COM Wrappers / Visual Basic DLLs section in the wiki: http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers HTH, Jalil Vaidya --- Jorge <[EMAIL PROTECTED]> wrote: > Hi, > > Are there any site whehe can I found the mentioned > VBWrapper.zip? > > I have tried in http://f4.grp.yahoofs.com/..., but > this URL isn't OK > > TIA > > Jorge Colaccini = 01001010 0111 01101100 01101001 01101100 __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]