Re: [sqlite] ambiguous temporary trigger metadata

comfortable. I have found that a different approach is generally preferable - that the tool should be able to handle anything the users may throw at it. Thank you. Bogdan Ureche ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] ambiguous temporary trigger metadata

> The problem is not that table names aren't qualified. The problem is that > information for setting up the schema (structural components) of a SQLite > database are stored in the database as the SQL commands rather than a > complicated internal format. This makes it permissable to do this: > >

Re: [sqlite] ambiguous temporary trigger metadata

3, at 4:09pm, Bogdan Ureche <bogdan...@gmail.com> wrote: > > > I tried without success to reproduce this scenario. > > > > create table t1(c); > > create temporary trigger tr1 after insert on t1 begin select raise(abort, > > 'error'); end; > > insert into t

[sqlite] inconsistent column names in queries containing views vs tables

"If there is no AS clause then the name of the column is unspecified and may change from one release of SQLite to the next." but shouldn't this be at least consistent for tables and views for the same release of SQLite? Thanks, Bogdan Ureche

Re: [sqlite] latest sqlite 3 with Delphi 5 professional

If you want to support UTF-8 in Delphi 5 then you may want to take a look at UTF-8VCL. I have been using with Delphi 2007 with no major issues. http://sourceforge.net/projects/utf8vcl/ Bogdan Ureche On Wed, Jan 22, 2014 at 5:11 PM, dean gwilliam <mgbg25...@blueyonder.co.uk>wrote: >

Re: [sqlite] sqlite_compileoption_get + cte

where sqlite_compileoption_get( position + 1 ) is not null ) selectname from Option order by name Bogdan Ureche On Sat, Mar 1, 2014 at 9:01 AM, Petite Abeille <petite.abei...@gmail.com>wrote: > Just because we can: > > with > Option( name, position ) &

Re: [sqlite] 64bit DLL

In case you didn't find one by now, here's 3.8.3.1: http://www.sqliteexpert.com/library/ On Mon, Mar 10, 2014 at 4:43 AM, RSmith wrote: > > Have any of you kind folks a recent 3.8.3 (or newer) 64-bit DLL for > SQLite3 perhaps? > > > >

Re: [sqlite] 64 bits Dll

You can also use SQLite.Interop.dll as a replacement SQLite library with encryption support. It is part of the System.Data.SQLite distribution and both 32 bit and 64 bit are included. Bogdan On Fri, May 9, 2014 at 9:56 AM, Carlos Ferreira wrote: > Constantine, really

Re: [sqlite] A simple SELECT

Hello Philippe, My assembler is a bit rusty, but it looks like you perform the jump to @ReadyToGetData when the return code is either SQLITE_ROW or SQLITE_DONE. You should only attempt to get the data when the return code is SQLITE_ROW. Bogdan On Mon, Jun 13, 2011 at 2:47 AM, Moi (Ph RIO Biz)

Re: [sqlite] A simple SELECT

On Mon, Jun 13, 2011 at 8:44 AM, Moi (Ph RIO Biz) wrote: > You are right, I corrected it but this is not the problem. > The problem is coming from only ONE table : LibLogInf. > I exported it, destroyed it, re-created it and re-entered the datas the > problem always exists ! >

Re: [sqlite] A simple SELECT

Sorry, please disregard my previous message. It seems I experienced a page refresh issue and I didn't see your full message on the forum. Bogdan On Mon, Jun 13, 2011 at 9:16 AM, Bogdan Ureche <bogdan...@gmail.com> wrote: > > > On Mon, Jun 13, 2011 at 8:44 AM, Moi (Ph RIO Biz)

Re: [sqlite] A simple SELECT

s > > Advanced Analytics Directorate > > > > ____ > From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on > behalf of Bogdan Ureche [bogdan...@gmail.com] > Sent: Monday, June 13, 2011 9:19 AM > To: General Discussion of SQLite

RE: [sqlite] NEWBY Question: What would be the best way to get data from a DBF4 database to a SQLite SQB?

You could try: www.sqliteexpert.com Data transfer wizard -> Import from ADO data source -> Microsoft OLE DB provider for ODBC drivers -> dBase files should do the job, though I never tried with DBF databases. Bogdan -Original Message- From: Graham Wickens [mailto:[EMAIL PROTECTED]

Re: [sqlite] error in sum function

and you will see the floating-point values correctly in the grid. Bogdan Ureche ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

ools for SQLite, for displaying/editing foreign key constraints visually. The alternative would be to parse the CREATE TABLE statements. Bogdan Ureche ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_column_name

Unless the user is a paying customer. On Fri, Nov 13, 2009 at 8:37 AM, Jean-Christophe Deschamps wrote: > > > >Unfortunately I cannot modify the query... it is supplied by an user. > > Well, what about upgrading the user? > > Sorry coul'd resist ... I'm already out! > > > >

[sqlite] is ticket 4037 not a bug?

ambiguous. Could anybody help me with this? Basically what I'm looking for is the answers to these questions: 1. Is this a bug or not? If not, any reason why not? 2. Are other databases supporting this syntax? 3. Is this an invalid syntax according to the SQL standard? 4. Is there a workaro

Re: [sqlite] is ticket 4037 not a bug?

Many thanks to all who replied, that was very helpful. So the ticket was closed because the old CVSTRACKER was closed, and a new ticket should be created with the replacement mechanism, after being discussed in the mailing list. @Roger: I apologize for the misunderstanding. > If > it alters the

Re: [sqlite] is ticket 4037 not a bug?

> > > > I can imagine query generators tend to use more, possibly > redundant, qualifiers than a human programmer would. > -- > ( Kees Nuyt > ) > c[_] > That may be true but sometimes the qualifiers are needed to avoid ambiguity, in which case they are not redundant. Bogdan >

Re: [sqlite] is ticket 4037 not a bug?

ct? Again, many thanks. Bogdan Ureche ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] column constraint diagram

SQLite seems to accept the following column declaration syntax without errors: CREATE TABLE Test( TestId INTEGER NULL, TestName TEXT NULL); However, there is no branch in the column constraint diagram describing this syntax. In the

Re: [sqlite] column constraint diagram

Jay, thank you for the reply, this confirms what I suspected. Incidentally, SQLite also accepts a conflict clause here although it doesn't make sense: CREATE TABLE Test( TestId INTEGER NULL ON CONFLICT ABORT, TestName TEXT NULL); Bogdan ___

[sqlite] suggestion - make pragma case_sensitive_like queryable

The pragma case_sensitive_like is not queryable, unlike other pragmas. Is there any reason why it's not? If not, I would like to suggest to be made queryable, for consistency. Bogdan ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] suggestion - make pragma case_sensitive_like queryable

> > > The setting is detectable: > > Simon, thank you for the reply. It's not exactly the answer I was hoping for, but I suppose fixing this is a low priority if there is a workaround. Regards, Bogdan ___ sqlite-users mailing list

[sqlite] "default value of column [name] is not constant." error in table creation when using double quoted string literal in parenthesis

s used in a context where it cannot be resolved to an identifier but where a string literal is allowed, then the token is understood to be a string literal instead of an identifier." Regards, Bogdan Ureche ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] "default value of column [name] is not constant." error in table creation when using double quoted string literal in parenthesis

to accommodate expressions. This is no longer an issue in this case as I implemented a workaround. Perhaps this could be fixed in SQLite 4 if backwards compatibility is less a concern? Regards, Bogdan Ureche On Sun, Feb 10, 2013 at 2:39 PM, Richard Hipp <d...@sqlite.org> wrote: >

Re: [sqlite] False Error 'no such collation sequence'

> > I wonder, though, if there may still remain a problem for other shells > (SQLite managers?) that do not support loadable extensions, e.g., free > versions of SQLite Expert, SQLite Developer, ... You are mistaken. The free version of SQLite Expert supports loadable extensions. B

[sqlite] Error: malformed database schema

eate temp table t(c); sqlite> create temp trigger t1 before insert on t begin select * from t; end; sqlite> Is this a bug? Thanks. Bogdan Ureche ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] ambiguous temporary trigger metadata

me to introduce a "pragma trigger_info()"? :) Thank you for any insights on this issue. Bogdan Ureche ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [ANN] SQLiteDoctor

Not sure about OS X, but definitely not the only way<http://www.sqliteexpert.com/features.html> on Windows. Bogdan Ureche http://www.sqliteexpert.com On Thu, Sep 27, 2012 at 7:58 AM, Marco Bambini <ma...@sqlabs.net> wrote: > Announcing SQLiteDoctor, the only way to recover