[sqlite] dynamic bulk import

you could provide. Sébastien Roux ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] instr function or equivalent

Enormous! Thanks it works! Sébastien Roux 2012/9/10 Black, Michael (IS) > Does this work for you? > > SQLite version 3.7.13 2012-06-11 02:05:22 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> create table t(s); &

Re: [sqlite] instr function or equivalent

Sad! Would you have any link toward SQLite's user defined SQLite function? Many thanks. Sébastien Roux 2012/9/10 Bart Smissaert > Ah, OK. I have a feeling that needs to be done either in your application > code > or with a user defined SQLite function. > Somebody may prove

Re: [sqlite] instr function or equivalent

[10.168.59.169] 132|2012-09-07|Logging in user [aaa] from [10.169.22.58] Sébastien Roux 2012/9/10 Bart Smissaert > Could your application supply the values in code? > What exactly are you trying to do? > > RBS > > > > On 9/10/12, Sébastien Roux wrote: > > T

Re: [sqlite] instr function or equivalent

Thanks Bart but substr require hard coded positions I guess, I need to get this position dynamically! Sébastien Roux 2012/9/10 Bart Smissaert > http://www.sqlite.org/lang_corefunc.html > > Look at substr > > > RBS > > > On 9/10/12, Sébastien Roux wrote: > > H

[sqlite] instr function or equivalent

nor deeper explanations! Many thanks. Sébastien Roux ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] cmdline IMPORT create filed on the fly?

administration? A utiliy that could help inserting a file content into SQLite for querying, performance matters as I'm thinking about 100 MB files - a kind of swiss army knife if ya see whatta mean? Many thanks for any help Sébastien Roux ___ sqlite-

[sqlite] hierarchical queries

Hi, Is there a way of doing hierarchical queries with SQLite. I'm not a killer with SQL language but I've seen that there are some hierarchical functions under Oracle. I'm having a hierarchy stored as a parent/child relationship. Thanks for your help.