At 07:14 09/04/2016, you wrote:
>I have implemented an application with Lazarus+FPCompiler, using SQLite
>tables, and the information was obtained from Excel tables previously
>done.
>
>I hope it would be very simple to prepare in the former Excel tables a
>sheet
>with the information required
On 04/06/2016 10:33 AM, Richard Hipp wrote:
> On 4/4/16, Mike Bayer wrote:
>> The "type" column in PRAGMA table_info() is now a blank string when the
>> target object is a view in 3.12.0. In 3.11.0 and prior versions, the
>> typing information is returned,
>>
>
> I think the problem is fixed by
Yes i am calling sqlite3_prepare_v2
snprintf(command, 512, INSERT_DN);
if ( (rv = sqlite3_prepare_v2(sqlHandle->db, command, -1,
, NULL) ) != SQLITE_OK )
{
fprintf(stderr, "Error Insert : sqlite3_prepare_v2, Error code :
%d\n",
Thanks very much to Jean-Christophe Deschamps
Regards
Ing. H?ctor F. Fiandor Rosario
On 4/9/16, Richard Hipp wrote:
> On 4/9/16, Bradley Grainger wrote:
>> In some circumstances "DELETE FROM x WHERE col = val" may fail to delete
>> all
>> rows if "PRAGMA reverse_unordered_selects = true;" has been executed.
>>
>
> https://sqlite.org/src/info/a306e56ff68b8fa5
Should be fixed now
In some circumstances "DELETE FROM x WHERE col = val" may fail to delete all
rows?if?"PRAGMA reverse_unordered_selects = true;" has been executed.
Steps to repro:
Open the test DB (https://downloads.logoscdn.com/temp/test.db 40KB)?with SQLite
3.12.1
Run:
pragma reverse_unordered_selects =
On 9 Apr 2016, at 6:14am, hfiandor wrote:
> I hope it would be very simple to prepare in the former Excel tables a sheet
> with the information required by my application and ?charge it? instead of
> the manual introduction as now.
Take a copy of your Excel spreadsheet.
Add a new column
Hello,
On 2016-03-29 19:25, Dan Kennedy wrote:
>http://sqlite.org/src/info/d0a3853b37230c12
> The fix should appear as part of the 3.13 release (not 3.12 - the
> version that was tagged earlier this morning).
Could that check--in be incorporated into next minor version? It fixes
rather
On 4/9/16, Bradley Grainger wrote:
> In some circumstances "DELETE FROM x WHERE col = val" may fail to delete all
> rows if "PRAGMA reverse_unordered_selects = true;" has been executed.
>
https://sqlite.org/src/info/a306e56ff68b8fa5
--
D. Richard Hipp
drh at sqlite.org
I have a PHP program where I have the equivalent of the following code. The
code was not deleting the expected rows ('abc' & 'def') because of the bad
syntax. However the error did not throw an exception. Is this what I should
expect?
$p = new PDO('sqlite::memory:');
Hi ?? ?
Dear list members:
Recently I have worked with an application for initial charge of an
Accounting System. It was very simple and I suspect that was implemented
with EXCEL and the Accounting System BD motor is not an SQLite (maybe
FoxPro).
The main idea is to prepare an accounting entry (I
12 matches
Mail list logo