[sqlite] data types

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 http://www.w3schools.com/sql/sql_create.asp Data types given there http://www.sqlite.org/datatype3.html Data types given here Is it ok to use the SQL data types given by w3schools? Or must I strictly use TEXT, NULL, INTEGER, BLOB, and NUMERIC? - --

Re: [sqlite] sqlite V3 with php

Thanks! At 05:27 PM 1/9/2005, [EMAIL PROTECTED] wrote: Michael Keilhofer <[EMAIL PROTECTED]> writes: > It appears that the extension module for php 5 uses sqlite V2.8 and not V3. > > Does anyone know where there's a php extension for either php 4 or php 5 that > uses sqlite 3? Try searching the

Re: [sqlite] sqlite V3 with php

Michael Keilhofer <[EMAIL PROTECTED]> writes: > It appears that the extension module for php 5 uses sqlite V2.8 and not V3. > > Does anyone know where there's a php extension for either php 4 or php 5 that > uses sqlite 3? Try searching the php "whole site" for PDO, which supports sqlite3. If

Re: [sqlite] Error in Aducom components

Hi Bert, Maybe converting null values to zero in integer columns will solve the problem. I will check it as soon as possible. Also, I will try to send a more detailed question about the subject to the Aducom forum. Thanks. Ahmet Aksoy Bert Verhees wrote: Op zondag 9 januari 2005 11:46, schreef

Re: [sqlite] sqlite3_busy_timeout not avoiding "database is locked" errors with multi-threaded updates

Stephen C. Gilardi wrote: Of course I could implement this in the application code, but I'd rather understand why sqlite isn't able to do this first. The sqlite source is unfamiliar territory, but I'll have a poke around and try to trace how the busy callback is used. Based on following the

Re: [sqlite] URGENT : library routine called out of sequence

Hi Sumit, Sumit Nagpal wrote: I was searching the web for links related to my problem . I came across one thread "Sqlite Thread safety" SQLite requires one connection per thread for threadsafe operation. If two or more threads share an SQLite connection, the program might get the error

Re: [sqlite] sql tables. . .?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mrs. Brisby wrote: | On Sat, 2005-01-08 at 00:04 -0500, John Richard Moser wrote: | |>What can be in an SQL table? | | | Tuples. | | like Baby from DBGT? [...] - -- All content of all messages exchanged herein are left in the Public Domain, unless

[sqlite] URGENT : library routine called out of sequence

Hi, My application has one main thread and other thread which is writing into SQLite Database. I have opened the db at both locations(read only in main thread) without errors. But, When I try to access DB thru main thread, it says "library routine called out of sequence" for all calls to

Re: [sqlite] Error in Aducom components

Op zondag 9 januari 2005 11:46, schreef Ahmet Aksoy: > Hi Bert, > Thank you for your answer. > I found a solution for my problem: setting TypeLess property to true. > Also, I think I found the reason of my problem. My original database was > in MsAcces, and I converted it to sqLite using

Re: [sqlite] Error in Aducom components

Op zondag 9 januari 2005 01:29, schreef Ahmet Aksoy: > Hi, > I'm trying to open a query using Aducom components, but I get an error > message saying: > '' is not a valid integer value. > I can open and use the database with sqlite3.exe. Also > Sqlite3Explorer.exe can open the database and all the