[sqlite] SQLite Query truncating String column at 255 chars long

2017-01-27 Thread Antonio Carlos Jorge Patricio
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

Re: [sqlite] Sqlite and SQL Server 2005

2012-10-05 Thread Jorge
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 >> &g

[sqlite] Sqlite and SQL Server 2005

2012-10-04 Thread Jorge
> 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

Re: [sqlite] Segmentation fault on sqlite3_create_module

2012-02-03 Thread Jorge Eliécer Osorio Caro
at 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 back

Re: [sqlite] Segmentation fault on sqlite3_create_module

2012-02-03 Thread Jorge Eliécer Osorio Caro
e0, 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

Re: [sqlite] Segmentation fault on sqlite3_create_module

2012-02-03 Thread Jorge Eliécer Osorio Caro
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 <jor

Re: [sqlite] Segmentation fault on sqlite3_create_module

2012-02-03 Thread Jorge Eliécer Osorio Caro
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

Re: [sqlite] Segmentation fault on sqlite3_create_module

2012-02-03 Thread Jorge Eliécer Osorio Caro
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, > > > >

[sqlite] Segmentation fault on sqlite3_create_module

2012-02-03 Thread Jorge Eliécer Osorio Caro
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

Re: [sqlite] How to return many data sqlite extension

2012-02-02 Thread Jorge Eliécer Osorio Caro
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 do

Re: [sqlite] How to return many data sqlite extension

2012-02-02 Thread Jorge Eliécer Osorio Caro
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

[sqlite] How to return many data sqlite extension

2012-02-01 Thread Jorge Eliécer Osorio Caro
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

[sqlite] blocks of read/write

2008-05-09 Thread Jorge Pereira
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

[sqlite] specific size of block to write/read?

2008-05-09 Thread Jorge Pereira
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

[sqlite] how to use specific size of block to write/read?

2008-05-09 Thread Jorge Pereira
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

[sqlite] problems with performance uclinux + sqlite

2008-05-06 Thread Jorge Pereira
: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

[sqlite] help with sql query / command SUM

2008-01-13 Thread Jorge Pereira
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),

[sqlite] SQlite in PDA with Windows CE

2007-12-19 Thread Jorge Rodríguez Pedrianes
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!!!

[sqlite] Sqlite 3.27 slow than 3.22

2005-12-20 Thread Jorge Mason
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

2004-06-17 Thread Jorge
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 J