Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

2017-06-07 Thread PICCORO McKAY Lenz
2017-06-07 13:57 GMT-04:00 Simon Slavin : > The work of parsing comments in the CREATE TABLE command ? I don’t think > anyone else thinks this is worth working on. Discussion in this list has > come up with many reasons why it’s a poor way to store comments, including >

Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

2017-06-07 Thread PICCORO McKAY Lenz
remote site is going to be > available, what the provider is going to do with my information. > > > > On Wed, Jun 7, 2017 at 12:17 PM, PICCORO McKAY Lenz < > mckaygerh...@gmail.com> > wrote: > > > hello brian, what standars? reading deeply the sqlit

Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

2017-06-07 Thread PICCORO McKAY Lenz
gt; Brian P Curley > > > > On Wed, Jun 7, 2017 at 12:09 PM, PICCORO McKAY Lenz < > mckaygerh...@gmail.com> > wrote: > > > 2017-06-07 9:59 GMT-04:00 Richard Hipp <d...@sqlite.org>: > > > > > I would suggest, then, that you grab a copy of the SQLite s

Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

2017-06-07 Thread PICCORO McKAY Lenz
2017-06-07 9:59 GMT-04:00 Richard Hipp : > I would suggest, then, that you grab a copy of the SQLite source code, > put it on github, and start your own fork. You can then add whatever > new SQL commands you want. > > At this point, your chances of getting us to do your work for

Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

2017-06-07 Thread PICCORO McKAY Lenz
com>: > What other way would there be? Just anonymous "Fix it, add this, do it > now!" kind of messages? If you don't register, then anyone can start > spamming the hell outta the message board. > > On Wed, Jun 7, 2017 at 9:15 AM, PICCORO McKAY Lenz <mckaygerh...@gmail.com

Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

2017-06-07 Thread PICCORO McKAY Lenz
; Patches are still welcome, I guess. I haven't seen anybody claiming > that this would be done in any way. > > On 6 June 2017 at 15:17, PICCORO McKAY Lenz <mckaygerh...@gmail.com> wrote: >> how its the status of this work? >> >> a limited implementation will be good!

Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

2017-06-06 Thread PICCORO McKAY Lenz
how its the status of this work? a limited implementation will be good! Lenz McKAY Gerardo (PICCORO) http://qgqlochekone.blogspot.com 2017-03-15 12:24 GMT-04:00 Simon Slavin : > > On 15 Mar 2017, at 4:09pm, Dominique Devienne wrote: > > > On Wed, Mar

[sqlite] RIGHT JOIN! still not supported?

2017-03-20 Thread PICCORO McKAY Lenz
i got this Query Error: RIGHT and FULL OUTER JOINs are not currently supported Unable to execute statement still today in 21 ts century? Lenz McKAY Gerardo (PICCORO) http://qgqlochekone.blogspot.com ___ sqlite-users mailing list

Re: [sqlite] sqlite with Java

2017-03-17 Thread PICCORO McKAY Lenz
one solution its use the odbc sqlite brigde http://www.java2s.com/Tutorial/Java/0340__Database/ConnecttoAccessDatabaseusingJDBCODBCbridge.htm with the sqlite odbc module http://www.ch-werner.de/sqliteodbc/ so due i dont see here java (a general great widely use due portability) facilities, and

Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

2017-03-15 Thread PICCORO McKAY Lenz
2017-03-15 12:24 GMT-04:00 Simon Slavin : > Problem is, it requires parsing the CREATE command looking for comments in > a certain format. Notoriously difficult, considering that they can contain > CR, LF, tab, and unforeseen Unicode characters. > well limit the comment to

Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

2017-03-15 Thread PICCORO McKAY Lenz
2017-03-15 11:49 GMT-04:00 R Smith : > Well, the advantage of having comments in DB tables (as some suggested) is > also that you have the entire SQL language functions available to > manipulate the comments that's one firts reason that rely on the second, comment can handle

Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

2017-03-15 Thread PICCORO McKAY Lenz
the idea its that many tools generated (due portability and compability) sql script with a optional keyword COMMENT on each column definition.. this its xxtremely usefull for selft container documentation for many console users and rapid development so manual comment using C-like cannot do that,

Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

2017-03-15 Thread PICCORO McKAY Lenz
hey their'e WIDELY USED keyword and practice in all mayor DBMS so can introduce a feature that converts all parts that have COMMENT '(\*)' to /* COMMENT */ and stored? in the master part of the Database? and NOTED THAT no many users comes here due the complicated behavior of report an issue...

[sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

2017-03-15 Thread PICCORO McKAY Lenz
an important feature in a DB its the column field that gives to developers metadata info INDEPENDENT of the tecnologies used, due by this way with a simple text editor in generated script developer can read and use minimal info for understanding structure ... its a minimal feature need in a