Re: [sqlite] Affinity modes

On 11/4/07, Ken <[EMAIL PROTECTED]> wrote: > In order to maximize compatibility between SQLite and other database > engines, SQLite support the concept of "type affinity" on columns. The type > affinity of a column is the recommended type for data stored in that column. > The key here is

Re: [sqlite] Affinity modes

On 11/5/07, Ken <[EMAIL PROTECTED]> wrote: > > ...given the choice, will prefer to use one storage class over > another. The preferred storage class for a column is called its "affinity". > > Seems pretty specific and explanatory to me. I think the OP was referring specifically to STRICT mode.

Re: [sqlite] Affinity modes

In order to maximize compatibility between SQLite and other database engines, SQLite support the concept of "type affinity" on columns. The type affinity of a column is the recommended type for data stored in that column. The key here is that the type is recommended, not required. Any column

[sqlite] uSQLiteServer and Visual Basic .NET

Hei all, is possible i access a database(through Visual Basic .NET) that is wrapped with uSQLiteServer ? Can you give a sample of code to do this ?? Thanks, Paulito

Re: [sqlite] parse.y

> I have some sql statement (for example Select col1, col2... from > some_table left join some_table_2 on... > where ...) > and I want get information about this statement -- column's list, where > clause, table's list etc in some structure (parse tree). If you compile with

RE: [sqlite] How many virtual table implemenations are there out there?

--- "Evans, Mark (Tandem)" <[EMAIL PROTECTED]> wrote: > 1) Modify xOpen interface to: > int ndmOpen(sqlite3_vtab *pVTab, sqlite3_vtab_cursor **ppCursor, int > update) ; > > where 'update' is an additional argument that indicates whether the > context is > for read-only select (0), or update (1),

RE: [sqlite] How many virtual table implemenations are there out there?

I would like to second the suggestion of Ralf and add a couple of my own: 1) Modify xOpen interface to: int ndmOpen(sqlite3_vtab *pVTab, sqlite3_vtab_cursor **ppCursor, int update) ; where 'update' is an additional argument that indicates whether the context is for read-only select (0), or

[sqlite] parse.y

Hi, All! I have some sql statement (for example Select col1, col2... from some_table left join some_table_2 on... where ...) and I want get information about this statement -- column's list, where clause, table's list etc in some structure (parse tree). I know about sqlite grammar