[sqlite] Andl: choices for generic types: bool, binary, number/decimal, date/datetime, text/varchar

- From: David Bennett [mailto:da...@yorkage.com] Sent: Wednesday, 10 February 2016 2:15 PM To: 'SQLite mailing list' Subject: RE: [sqlite] Andl: choices for generic types: bool, binary, number/decimal, date/datetime, text/varchar >>>Every SQLite database file has a text encod

[sqlite] Andl: choices for generic types: bool, binary, number/decimal, date/datetime, text/varchar

>> If you do not know what type is _actually_ stored, call >> sqlite3_column_type() first. > > That looks like one call to get the type, a choice of 3 calls for > INTEGER, REAL or TEXT and a choice of 3 conversion/casts to get it to > the final type >>>If you want to get out a value for a specif

[sqlite] How to see SQLite debugging information

On Windows you will get a console and standard output if you are running a console application, and otherwise not. I think you need a simple console app to call your ActiveX DLL, or find some other way. Windows GUI app and standard output do not play well together. Regards David M Bennett FACS A

[sqlite] SQLite Extensions

Any chance of a GitHub etc repo for others to maybe fork? Regards David M Bennett FACS Andl - A New Database Language - andl.org -Original Message- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Keith Medcalf Sent

[sqlite] Compile warnings

of SQLite Database ; davidb at pfxcorp.com Subject: Re: [sqlite] Compile warnings On Aug 24, 2015 6:29 AM, "David Bennett" mailto:davidb at pfxcorp.com> > wrote: > > I think we've beaten the philosophy to death and we're largely in agreement. > > I'

[sqlite] Compile warnings

.sqlite.org] On Behalf Of Scott Robison Sent: Monday, 24 August 2015 8:25 AM To: davidb at pfxcorp.com; General Discussion of SQLite Database Subject: Re: [sqlite] Compile warnings On Sat, Aug 22, 2015 at 8:07 PM, David Bennett wrote: > Of course that is the aim, as always. > > >

[sqlite] Compile warnings

(necessarily) a change to suppress warnings, even if both requirements are needlessly strict in some situations. I just don't think that C99 or some compilers warning setup should mandate a change. On Aug 22, 2015 8:36 AM, "David Bennett" mailto:davidb at pfxcorp.com> > wrot

[sqlite] Compile warnings

users-bounces at mailinglists.sqlite.org] On Behalf Of Scott Robison Sent: Saturday, 22 August 2015 2:05 AM To: General Discussion of SQLite Database ; davidb at pfxcorp.com Subject: Re: [sqlite] Compile warnings And C89 doesn't have the valid pointer requirement On Aug 21, 2015 7:03 AM, &quo

[sqlite] Compile warnings

Addressing only standards compliance, the C99 (n1256) standard says as follows. 7.21.1 /2 Where an argument declared as size_t n specifies the length of the array for a function, n can have the value zero on a call to that function. Unless explicitly stated otherwise in the description of a partic