Hello,
When I set the MAX_PAGE_COUNT and retrieve the value in the same connection,
I get what I set.
However, when I use a new connection to the database, I get the default
value. Also if I close all connections and restart, I am getting the default
value.
Statements used:
PRAGMA
Hi,
I am using sqlite for meta data storage of audio files.
I am storing the sqlite database in hard disk.
The sector size of FAT file system is 512 bytes.
Hard disk rpm is 4200
Page size = 1K
cache size = 2k
The processor speed is 600 Mhz.
I am using joins method in sqlite.The records are the
Dear All,
I need help in sqlite3. i want to test the sqlite 3 database . any test tool
is there to test database??
pls help me
Thanks in Advance.
--
View this message in context:
http://www.nabble.com/Need-help-in-sqlite3-tp14685105p14685105.html
Sent from the SQLite mailing list
I have a client who's using a colorful excel sheet as a database. It's
colorful, well-structured, and a joy to use. He has no code working on the
data though -- it's just used for holding data, like a ledger book!
My question is how I can put his information into a sqlite database but give
him
Let me be more clear. There's very little data, and I want to help my client
be able to expand his business, so the first step is automating what he's
been doing by hand. I can get the excel data into sqlite no problem -- and
wish to do so in order to START doing automated stuff with the data
If it is so good then why would you want to use
SQLite? Holiday data can't be that much, so I would
think Excel can cope with that fine.
If you really want to move the data from Excel to
SQLite then you will need a VB wrapper.
RBS
>
> I have a client who's using a colorful excel sheet as a
Please read the following pages:
http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuning
http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuningWindows
Sreedhar.a wrote:
Hi,
I am using sqlite for meta data storage of audio files.
I am storing the sqlite database in hard disk.
The sector size
Still not sure why you want to use SQLite here, but I think to get what
you want you will have to code
it yourself.
RBS
>
> Let me be more clear. There's very little data, and I want to help my
> client
> be able to expand his business, so the first step is automating what he's
> been doing by
Your disk is slow (large latency). Speeding that up to 7,500 or 15,000
RPM will help.
Sreedhar.a wrote:
Hi,
I am using sqlite for meta data storage of audio files.
I am storing the sqlite database in hard disk.
The sector size of FAT file system is 512 bytes.
Hard disk rpm is 4200
Page
there are a number of front ends to sqlite - I use sometime tksqlite.
http://reddog.s35.xrea.com/wiki/TkSQLite.html
maybe not exactly what you want - but it might be a starting point.
regards W.Braun
[EMAIL PROTECTED] wrote:
Still not sure why you want to use SQLite here, but I think to get
Regarding
Moving colorful spreadsheet to sqlite.
-- Would Christian Werner's free ODBC interface allow you to use the
same spreadsheet to access an sqlite database?
http://www.ch-werner.de/sqliteodbc
-- Lots of automation can be performed within Excel spreadsheets (and, I
imagine,
Your request for assistance is too broad. Can you narrow it, be more
specific? For instance:
Do you want to test the use of a specific SQLite3 database that you've
designed, test the software that you've created to access it, test the
SQLite3 DBMS, or what?
I know from reading forum emails from
I'm not big on either Excel or ODBC, so I can't help with the details, but...
There's an ODBC driver for SQLite you could install on your customer's system,
and I'm pretty sure Excel can render data from an ODBC data source. So, if
what you really want is to view query result data in Excel, it
SQLite is not an end-user tool (nor is any other database except *perhaps*
Access, but even then it just gets people into trouble).
What you want is not a free gui for SQLite but a custom application that
does what the user needs and uses SQLite as it's data storage mechanism.
This certainly
Sqlfan:
If you really want something to imitate Excel, rather than just using Excel
itself and the very capable VBA it includes, one option would be Borland
Delphi, using Ralf Junker's Disqlite3 as the wrapper to Sqlite3 and any one
of a number of third-party shareware grid components, easily
Greetings!
I have developed an application that uses a local and a shared folder
SQLite3 DBs and the D SQLite3 wrapper is failing on execute commands. For
example, this UPDATE command,
UPDATE LSOpenJobs SET
ProjID = '871',
subProjID = '865',
parent = '209',
children = '',
The only occurence of the string "bs" in your code is at the table name
LSOpenJobs
Maybe the DBI layer is not passing everything since there is a carriage return
after the SET?
HTH
Ken
jose isaias cabrera <[EMAIL PROTECTED]> wrote:
Greetings!
I have developed an application that uses a
One more question on this... What if I don't send UTF-8 characters?
From: "Ken" who said,
The only occurence of the string "bs" in your code is at the table name
LSOpenJobs
Maybe the DBI layer is not passing everything since there is a carriage
return after the SET?
HTH
Ken
jose
Hello. I've written a UDF named ENCRYPT. I want to do something like this:
UPDATE Employees SET EncryptedName = ENCRYPT(LastName + ', ' + FirstName)
The UDF gets called, but not with my data - rather something like "0.0". Kind
of weird. Does Sqlite handle SQL expressions inside the
On Wed, 09 Jan 2008 11:21:43 +1000, [EMAIL PROTECTED]
wrote:
>Hello. I've written a UDF named ENCRYPT. I want to do something like this:
>
> UPDATE Employees SET EncryptedName = ENCRYPT(LastName + ', ' + FirstName)
>
>The UDF gets called, but not with my data - rather something like "0.0".
Hello,
I am not able to persist the MAX_PAGE_COUNT on the database I am using.
OS : Windows
Version: 3_5_4 dated 14.Dec.2007
1) Create a database - say store01.sqlite
2) Open store01.sqlite using sqlite.exe
3) Execute "pragma MAX_PAGE_COUNT = 20;"
4) Execute "pragma MAX_PAGE_COUNT;" -->
21 matches
Mail list logo
