Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

2017-01-27 Thread GB
Clyde Eisenbeis schrieb am 27.01.2017 um 18:51: I tried this: - System.Data.SQLite.SQLiteCommand sqliteCmd = sqliteConnection.CreateCommand()); sqliteCmd.CommandText = "SELECT" + stFieldNames + "FROM " + stTableName + " WHERE " + stLikeFieldName + " LIKE '%'

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

2017-01-27 Thread Joseph R. Justice
On Fri, Jan 27, 2017 at 7:49 PM, dandl wrote: > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of James K. Lowden > > >>>Sticking with C90 is perfectly rational if you're still running Windows > 98 on a Pentium III at 500 Mhz with 256 MB

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

2017-01-27 Thread dandl
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of James K. Lowden >>>Sticking with C90 is perfectly rational if you're still running Windows 98 >>>on a Pentium III at 500 Mhz with 256 MB RAM. Else, really, it's not too >>>soon to adopt a 6-year old

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

2017-01-27 Thread Richard Damon
On 1/27/17 6:06 PM, Keith Medcalf wrote: On Friday, 27 January, 2017 08:26, Clemens Ladisch said: David Empson wrote: Perhaps SQLite’s test procedure should be enforcing strict ANSI C mode? If this is already being done, then the compiler(s) used might not be enforcing

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

2017-01-27 Thread Keith Medcalf
On Friday, 27 January, 2017 08:26, Clemens Ladisch said: > David Empson wrote: > > Perhaps SQLite’s test procedure should be enforcing strict ANSI C mode? > > If this is already being done, then the compiler(s) used might not be > > enforcing this particular rule. > > "gcc

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

2017-01-27 Thread John McKown
On Fri, Jan 27, 2017 at 2:51 PM, Warren Young wrote: > > > There’s no obfuscated Perl contest because it’s pointless. > > Perl is not pointless: > ​True. I love it. But most Perl code is, by design, already rather obscure. Some of the "idioms​" used (like slurping input and

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

2017-01-27 Thread Clyde Eisenbeis
I agree completely! I am grateful that SQLite exists. It would be good if users could post solutions, similar to forums. This relieves the burden on the benefactors ... and would, quite likely, attract more users. On Fri, Jan 27, 2017 at 2:38 PM, Warren Young wrote: > On

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

2017-01-27 Thread R Smith
On 2017/01/27 10:51 PM, Warren Young wrote: Perl is not pointless: http://search.cpan.org/~markov/Geo-Point-0.96/lib/Geo/Point.pod Without Geometry Life is pointless. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

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

2017-01-27 Thread Warren Young
On Jan 27, 2017, at 12:09 PM, John McKown wrote: > > On Fri, Jan 27, 2017 at 12:58 PM, Antonio Carlos Jorge Patricio < > antonio...@gmail.com> wrote: > >> In my tests, they got almost all chopped at 255 chars long >> > ​I'm guessing this is a problem with

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

2017-01-27 Thread Warren Young
On Jan 27, 2017, at 1:09 PM, Clyde Eisenbeis wrote: > > The SQLite websites would be more useful with examples. Certainly. No question. The thing is, I think most of us are primarily grateful that SQLite *exists* and that it works as well as it does. Given a choice of

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

2017-01-27 Thread Clyde Eisenbeis
Hi Simon Slavin, This works! Almost identical to the approach used for OLE DB example described in the 26 Jan, 11:45am email attachment. The end result code for SQLite is attached. - Hi James K. Lowden, Examples are a source I've used since 1968 (Fortran using key

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

2017-01-27 Thread Jens Alfke
> On Jan 27, 2017, at 11:09 AM, John McKown > wrote: > > ​I'm guessing this is a problem with SQLite.NET , or .NET > itself, which is > not supported here. …or with Visual BASIC. (It looks like the code the OP posted is BASIC, judging by the

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

2017-01-27 Thread John McKown
On Fri, Jan 27, 2017 at 12:58 PM, Antonio Carlos Jorge Patricio < antonio...@gmail.com> wrote: > 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

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

2017-01-27 Thread James K. Lowden
On Fri, 27 Jan 2017 10:08:17 +1300 David Empson wrote: > Should SQLite be aiming for the 1990 version of ANSI/ISO C as a > baseline, for widest compatibility, or is it OK to drop older > compilers and require C99 compliance? Older compilers? C99 was adopted 17 years ago,

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

2017-01-27 Thread James K. Lowden
On Thu, 26 Jan 2017 08:19:02 + Hick Gunter wrote: > On LP_64 architactures, the integer 0 is 32 bits while (void *)0 is > 64 bits, which makes more than a bit of a difference. A 64 bit > integer 0 would be denoted by 0L. in C, as you know, integer assignment is subject to

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

2017-01-27 Thread James K. Lowden
On Thu, 26 Jan 2017 11:45:41 -0600 Clyde Eisenbeis wrote: > Usually I look at examples, and extract the relevant info. In the Age of Google, that has become a popular technique. But it's not a good way to learn anything. I wonder, though: how do you know what the "relevant

[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] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

2017-01-27 Thread Simon Slavin
On 27 Jan 2017, at 5:59pm, Clyde Eisenbeis wrote: > sqliteCmd.CommandText = SELECT fstPriority, fstInfo, fstDateCreated, > fstDateModified, fiKeyID FROM MemoPadTable WHERE fstInfo LIKE '%' || > ?1 || '%'" > > liststLikeFieldValue[0] = "bruce" Please try the following:

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

2017-01-27 Thread Clyde Eisenbeis
sqliteCmd.CommandText = SELECT fstPriority, fstInfo, fstDateCreated, fstDateModified, fiKeyID FROM MemoPadTable WHERE fstInfo LIKE '%' || ?1 || '%'" liststLikeFieldValue[0] = "bruce" On Fri, Jan 27, 2017 at 11:55 AM, Simon Slavin wrote: > > On 27 Jan 2017, at 5:51pm,

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

2017-01-27 Thread Simon Slavin
On 27 Jan 2017, at 5:51pm, Clyde Eisenbeis wrote: > System.Data.SQLite.SQLiteCommand sqliteCmd = > sqliteConnection.CreateCommand()); > > sqliteCmd.CommandText = "SELECT" + stFieldNames + "FROM " + > stTableName + " WHERE " + stLikeFieldName + " LIKE '%' || ?1 || '%'"; > >

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

2017-01-27 Thread Clyde Eisenbeis
Thanks. Was able to open the .chm file. I tried this: - System.Data.SQLite.SQLiteCommand sqliteCmd = sqliteConnection.CreateCommand()); sqliteCmd.CommandText = "SELECT" + stFieldNames + "FROM " + stTableName + " WHERE " + stLikeFieldName + " LIKE '%' || ?1 ||

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

2017-01-27 Thread Clemens Ladisch
I wrote: > David Empson wrote: >> Perhaps SQLite’s test procedure should be enforcing strict ANSI C mode? >> If this is already being done, then the compiler(s) used might not be >> enforcing this particular rule. > > "gcc -pedantic -std=c90" (or gnu90) would check for this error And

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

2017-01-27 Thread Kim Gräsman
David, On Fri, Jan 27, 2017 at 12:51 PM, David Empson wrote: > >> On 27/01/2017, at 9:09 PM, Kim Gräsman wrote: >> >> On Thu, Jan 26, 2017 at 10:08 PM, David Empson > > wrote: >>> On

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

2017-01-27 Thread Clemens Ladisch
David Empson wrote: > Perhaps SQLite’s test procedure should be enforcing strict ANSI C mode? > If this is already being done, then the compiler(s) used might not be > enforcing this particular rule. "gcc -pedantic -std=c90" (or gnu90) would check for this error: test.c:6:3: warning: initializer

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

2017-01-27 Thread David Empson
> On 27/01/2017, at 9:09 PM, Kim Gräsman wrote: > > On Thu, Jan 26, 2017 at 10:08 PM, David Empson > wrote: >> >>> On 26/01/2017, at 8:46 PM, Clemens Ladisch wrote: >>> …

Re: [sqlite] application function value in sql where

2017-01-27 Thread R Smith
On 2017/01/26 8:29 PM, dspub...@freemail.hu wrote: On 2017/01/26 6:23 PM, dspub...@freemail.hu wrote: Thanks for responses, I have an other problem select * from (select row_number(name) as id,name from example order by name desc) t order by name In this query, the server why doesn't use

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

2017-01-27 Thread Kim Gräsman
On Thu, Jan 26, 2017 at 10:08 PM, David Empson wrote: > >> On 26/01/2017, at 8:46 PM, Clemens Ladisch wrote: >> >> Ziemowit Laski wrote: >>> Visual C++ >> >> Which one? >> >>> correctly catches this. >> >> Oh? What exactly is illegal about this? >> >>>