-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Rashmi Hiremath wrote:
| someone have an SQLite internationalization samples
| which I can take a look at ?
|
| Also can I save,search in internationalization fomat ?
Your question doesn't make sense. SQLite does not have a user interface
- - it is
Hi,
Is any possible way to know if a column is UNIQUE without PRAGMA
index_info('index_name')? Seems PRAGMA table_info('table_name')
doesn't returns the unique flag of column.
Thanks for advice.
--
Firman Wandayandi http://firmanw.org/
http://www.sqlite.org/cvstrac/fileview?f=sqlite/src/parse.yv=1.210
--- Dusan Gibarac [EMAIL PROTECTED] wrote:
What are our options to extend or change SQL syntax if needed?
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam
The questioner might find that user functions will extend the capability
to do what he wants without implementing new SQL syntax.
Joe Wilson wrote:
http://www.sqlite.org/cvstrac/fileview?f=sqlite/src/parse.yv=1.210
--- Dusan Gibarac [EMAIL PROTECTED] wrote:
What are our options to extend or
On 12/16/06, Firman Wandayandi [EMAIL PROTECTED] wrote:
Hi,
Is any possible way to know if a column is UNIQUE without PRAGMA
index_info('index_name')? Seems PRAGMA table_info('table_name')
doesn't returns the unique flag of column.
Thanks for advice.
this will show you the count of
Hi Jay,
On 12/17/06, Jay Sprenkle [EMAIL PROTECTED] wrote:
On 12/16/06, Firman Wandayandi [EMAIL PROTECTED] wrote:
Hi,
Is any possible way to know if a column is UNIQUE without PRAGMA
index_info('index_name')? Seems PRAGMA table_info('table_name')
doesn't returns the unique flag of column.
Maybe he wants to change the SQL keywords to Esperanto, or implement
CONNECT BY. You never know.
--- John Stanton [EMAIL PROTECTED] wrote:
The questioner might find that user functions will extend the capability
to do what he wants without implementing new SQL syntax.
Joe Wilson wrote:
On 12/16/06, Firman Wandayandi [EMAIL PROTECTED] wrote:
I meant, I want retrieve the information of the column or schema as
much as possible, so I can build a new schema based on it. Then I need
to know if column is a UNIQUE or not and so on.
select * from sqlite_master;
It tells you about
On 12/17/06, Jay Sprenkle [EMAIL PROTECTED] wrote:
On 12/16/06, Firman Wandayandi [EMAIL PROTECTED] wrote:
I meant, I want retrieve the information of the column or schema as
much as possible, so I can build a new schema based on it. Then I need
to know if column is a UNIQUE or not and so
On 12/16/06, Firman Wandayandi [EMAIL PROTECTED] wrote:
Yeah, as I thought before. Well nevermind, I should parse the table schema then.
Thanks
You're welcome.
--
The PixAddixImage Collector suite:
http://groups-beta.google.com/group/pixaddix
SqliteImporter and SqliteReplicator: Command line
The basic problem is that I am getting SQLITE_BUSY on a call to
sqlite3_exec where the SQL passed is simply COMMIT;
Notes:
1. This in on a WIN32 platform.
2. There is only one process (the main process) that makes any calls
to sqlite3 for the DB in question.
3. The process is single
Hi,
In my database I find that the explain program for the view (114
statements) is much longer than direct query that comprises the view
(89) and almost twice as long as doing the 2 separate queries that make
up the union in the view (39 + 30 = 69).
To explain more clearly what I mean, if I
Done. Is there anything else that is necessary to contribute code and
patches to sqlite? The bug database seems to lack feedback (many bugs
seem to just lie stale, there is no way to create an account to login,
etc). I can't find documentation on the website on contributions.
Regards,
Brodie
Hey folks
I am starting an ambitious project that I fear I may regret :P
Some time ago I wrote a member and incident management application for my
volunteer bushfire brigade in PHP/mySQL. It works quite well but is
browser based which limits it a bit.
Other Brigades have eyed it enviously
Ahhh...thanks for that.
All the best
Steve Davis
Steve Davis - too much time on his hands
-Original Message-
From: Jay Sprenkle [mailto:[EMAIL PROTECTED]
Sent: Sunday, 17 December 2006 9:12 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Is sqlite the right db for me?
On
Dixon Hutchinson
sqlite-491LjFE5FnHkPponyUOvwgC/[EMAIL PROTECTED] wrote:
The basic problem is that I am getting SQLITE_BUSY on a call to
sqlite3_exec where the SQL passed is simply COMMIT;
Most likely, you still have a statement in progress that has not been
reset or finalized.
3.
Dixon Hutchinson wrote:
The basic problem is that I am getting SQLITE_BUSY on a call to
sqlite3_exec where the SQL passed is simply COMMIT;
Notes:
1. This in on a WIN32 platform.
2. There is only one process (the main process) that makes any calls
to sqlite3 for the DB in question.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Steve Davis wrote:
| Some time ago I wrote a member and incident management application for
| my volunteer bushfire brigade in PHP/mySQL. It works quite well but is
| browser based which limits it a bit.
Being browser based shouldn't be limiting
No, I did not explicitly set it.
John Stanton wrote:
Do you set the inherit handles flag on your CreateProcess call?
Dixon Hutchinson wrote:
The basic problem is that I am getting SQLITE_BUSY on a call to
sqlite3_exec where the SQL passed is simply COMMIT;
Notes:
1. This in on a WIN32
Igor, I thought having a statement in progress or not finalized resulted
in SQLITE_LOCKED, not SQLITE_BUSY... but I have been searching for such
a condition anyway.
As to the second question below, the parameters bound each time are
different, thus the reset.
Igor Tandetnik wrote:
Dixon
Brodie Thiesfield [EMAIL PROTECTED] wrote:
Done. Is there anything else that is necessary to contribute code and
patches to sqlite?
For ticket #2023, the first patch seems unlikely to work right
since it changes the character encoding for LoadLibrary() but
leaves it unchanged for
I would endorse Roger's comments. A web interface can give you
everything you can get from a stand-alone application but also gives you
flexibility.
The greatest advantage of the web application is that you have no
software loading onto PCs, a real nuisance. As long as the browser
works
Roger, I appreciate your response and am sorry for wasting your time a bit
by not being more detailed...
It is not a web-based app, rather browser based. Many brigades do not have
net access at their stations, they might only have someone there once a
fortnight, so it isn't viable. Also this
A view is basically just a SELECT on a subquery. These two queries
are functionally equivalent:
SELECT * from va;
SELECT * from (SELECT a, b, 0 AS c FROM ta
UNION SELECT a, b, 1 FROM tb);
SELECTs on subqueries (or views) containing UNION or INTERSECT or
EXCEPT can be slow.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Steve Davis wrote:
| Does that change your opinion?
Not in the slightest. You can run the web server and browser on the
same machine as you have presumably already been doing. (Unless you
have been using the word browser to mean something other
25 matches
Mail list logo