2008/10/3 D. Richard Hipp <[EMAIL PROTECTED]>:
> http://www.sqlite.org/draft/syntaxdiagrams.html
> http://www.sqlite.org/draft/lang.html
The diagrams are nice and for some people probably easier to read than
plain text BNF* syntax.
Although, images have two disadvantages:
1) web search engines
Gavin Kistner wrote:
> The diagrams are read most easily left to right; rolling to a new line
> greatly reduces the utility, IMO. Roughly 7% of the 'net is still
> using 800x600, and surely far less of tech savvy audience.
>
> I suggest increasing the image width to at least 900px before
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mark Easton wrote:
> An up arrow just produces the characters ^[[A
The command editing is performed by the readline library. If you
compiled SQLite yourself then you need the readline development files
(includes, libs etc) installed before running
Hi everyone,
Since I have installed the new version of sqlite3, I have found that when I
am in command line (sqlite3) I can no longer use up arrow to search through
my command history.
An up arrow just produces the characters ^[[A
Anyone know what is going on? It is very tedious having to
Hello guys,
Is there an option in SQLite to make the database file reside in the
memory during sql transactions for faster access?
I am using the C# language under Mono.
Thanks in advance,
Marc Glenn
--
View this message in context:
On 10/5/08, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
>
> On Oct 5, 2008, at 4:55 PM, yaroslavp wrote:
>
> >
> > Hi all,
> >
> > For testing purposes, I created a single row with a large blob
> > (hundreds of
> > megs) in my database. There is also an integer column. When I do an
> >
On Oct 5, 2008, at 4:55 PM, yaroslavp wrote:
>
> Hi all,
>
> For testing purposes, I created a single row with a large blob
> (hundreds of
> megs) in my database. There is also an integer column. When I do an
> update
> on the integer, the query is very slow, and there's a lot of disk
>
"yaroslavp" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> For testing purposes, I created a single row with a large blob
> (hundreds of megs) in my database. There is also an integer column.
> When I do an update on the integer, the query is very slow, and
> there's a lot of disk
Hi all,
For testing purposes, I created a single row with a large blob (hundreds of
megs) in my database. There is also an integer column. When I do an update
on the integer, the query is very slow, and there's a lot of disk activity.
The bigger the blob, the slower the query (a rule of thumb -
On Sun, Oct 5, 2008 at 7:59 AM, Gilles Ganault <[EMAIL PROTECTED]>wrote:
>
> This is for an accounting program: As an exemple, all accounts
> starting with 6 must be listed together, which means that eg. 6001
> must come after 601, and not after, say, 801.
It sounds like you want the account
On Oct 5, 2008, at 3:59 PM, Gilles Ganault wrote:
> Is there a trick in SQL that lets me do this? ORDER BY ASC won't do
> this.
order by to_char( account_id ) perhaps?
--
PA.
http://alt.textdrive.com/nanoki/
___
sqlite-users mailing list
Hello
This is for an accounting program: As an exemple, all accounts
starting with 6 must be listed together, which means that eg. 6001
must come after 601, and not after, say, 801.
Is there a trick in SQL that lets me do this? ORDER BY ASC won't do
this.
Thank you.
On Oct 4, 2008, at 11:00 AM, Neon wrote:
> Only _MSC_VER >= 1400 supports _declspec(deprecate("text")) syntax;
> _MSC_VER >= 1300 only supports bare _declspec(deprecate) syntax.
>
> This error was introduced in version 3.6 and still exists in 3.6.3. I
> have to modify these two files in order to
Only _MSC_VER >= 1400 supports _declspec(deprecate("text")) syntax;
_MSC_VER >= 1300 only supports bare _declspec(deprecate) syntax.
This error was introduced in version 3.6 and still exists in 3.6.3. I
have to modify these two files in order to compile using Visual C++ 2003.
It should be like
14 matches
Mail list logo