-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 20/08/12 13:07, Tal Tabakman wrote:
> how much memory on heap will the application consume (from SQLite point
> of view).
Why don't you ask SQLite while running your representative schema and queries?
http://www.sqlite.org/c3ref/c_dbstatus_optio
Hi
I am writing an application which creates a db in runtime (i.e. only INSERT
queries are performed, indexing only by primary key...)
I am running with the following pragmas:
executeString("PRAGMA temp_store=MEMORY");
executeString("PRAGMA journal_mode = MEMORY;");
executeString("PRAGMA page_size
Thanks Joe, I'll work on converting this to ASP.NET. Thanks for pointing me in
the right direction!
:: Roger Rice, Senior Software Administrator
:: University Information Technology Services (UITS)
:: University of Massachusetts President's Office
:: 774-455-7825 Phone
:: 774-455-7733 Fax
:: r
Rice, Roger wrote:
>
> dim rs,x, conn, dir
>
> conn=Server.CreateObject("ADODB.Connection")
> 'conn.provider="Microsoft.Jet.OLEDB.4.0"
> conn.provider="System.Data.SQLite"
> conn.Mode = 1
> 'conn.open(server.mappath("..\pub\" & folder.name &
"\Messa
Hello,
I am trying to convert and ASP page to ASP.NET on Windows 2008 R2. The program
I converted previously read in data from multiple Microsoft Access databases,
looping through each directory under a directory called "pub". The data in the
tables is created from a software package called eM
You can try to use authorizer
(http://www.sqlite.org/c3ref/set_authorizer.html) although it seems to
me SQLite won't inform you about access to table2 in the first query.
Pavel
On Mon, Aug 20, 2012 at 2:18 AM, Bishwa Shrestha
wrote:
> Hi,
>
> I am creating an sqlite3 interface to an existing da
On 20 Aug 2012, at 3:05am, Sunshine Lutey wrote:
> I receive an sqlite3 error (see attached) whenever I re-start my computer.
You cannot attach files to messages to this list. However, the most frequent
cause of this is installing iTunes on a Windows computer. If you have done
this, please
On 19 Aug 2012, at 6:31pm, lukas wrote:
> Simon Slavin writes:
>
>> Using both versions can you tell us the results of
>>
>> SELECT sqlite_version(),sqlite_source_id()
>
> Results are exactly the same for both dlls:
>
> 3.7.13
> 2012-06-11 02:05:22 f5b5a13f7394dc143aa136f1d4faba6839eaa6dc
On 20 Aug 2012, at 10:18am, Bishwa Shrestha wrote:
> Is there a way to get the table names that were referenced in the query
> itself?
I don't think so. Consider that you might do things like
SELECT 1,2,3;
SELECT (a.column1 + b.column1) FROM table1 AS a, table2 AS b;
so it's quite possible
Dear Support Team,
I receive an sqlite3 error (see attached) whenever I re-start my computer.
I don't actually know what this application is but I would like to get rid
of the error.
Thanks,
Sunshine
*Terri Sunshine Lutey*
*President and Musical Director, Sunshine Performance Club*
*President an
Simon Slavin writes:
> Using both versions can you tell us the results of
>
> SELECT sqlite_version(),sqlite_source_id()
Results are exactly the same for both dlls:
3.7.13
2012-06-11 02:05:22 f5b5a13f7394dc143aa136f1d4faba6839eaa6dc
The inserts are also in a transaction block. Basically it l
Hi,
I am creating an sqlite3 interface to an existing data model. For that
purpose sqlite3 tables are dynamically loaded. I'm using
/sqlite3_column_count/ and /sqlite3_column_table_name/ to load data into
relevant tables only.
Now, I am having problems with queries such as:
SELECT a.column1
On 08/20/2012 11:08 AM, Bishwa Shrestha wrote:
Hi,
I am creating an sqlite3 interface to an existing data model. For that
purpose sqlite3 tables are dynamically loaded. I'm using
/sqlite3_column_count/ and /sqlite3_column_table_name/ to load data
into relevant tables only.
Now, I am having
Hi,
I am creating an sqlite3 interface to an existing data model. For that
purpose sqlite3 tables are dynamically loaded. I'm using
/sqlite3_column_count/ and /sqlite3_column_table_name/ to load data into
relevant tables only.
Now, I am having problems with queries such as:
SELECT a.column1
14 matches
Mail list logo