Welcome to the SQLitening support forums!
Started by Fred Meier, October 02, 2008, 06:07:23 PM
Create Table T1 (C1, C2, C3)
Create Table T1 (C1 Integer, C2 Text, C3 Real)
QuoteOn Feb 2, 2008, at 7:57 PM, Scott Chapman wrote:I've looked high and low and can't find a way to invoke the other 2affinity modes. Are they available? I'm on 3.5.4.
QuoteD. Richard Hipp (Mr SQLite) replyThe concept of "strict" affinity mode was briefly discussed yearsago, but we never implemented it, having never seen any benefitfor such a thing. Can you explain why you think strict affinity modemight be beneficial to you? If somebody can provide a goodenough rational to justify strict affinity mode, we might just put itin.
slExe "Create table T1(F1)" slExe "Insert into t1 values (10) slExe "Insert into t1 values ('11') slExe "Insert into t1 values (12)
Quote from: Fred Meier on October 04, 2008, 06:57:50 PM... Of course within your PB code, all values are returned as strings using the Get Field routines so you can not tell (nor do I think you care) if it was stored as numeric or text.
QuoteI have a table that consists entirely of numeric fields (LONGs and a QUAD).
Quote from: Fred Meier on January 29, 2009, 11:31:42 AMI was not correct in saying SQLite3.Dll only returns strings. It can return 4 and 8 byte integers as well as 8 byte floats. Many additional routines could have been added to SQLitening.Dll to do this (there would be some problems with the 8 byte integer) but it was decided that returning only strings was the simplest.