"Robert Wojciechowski" <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I'm trying to figure out the exact algorithm to determine how much data
> can be stored within Sqlite 3's B-tree without using overflow pages.
>
> I've searched quite a bit and all the documents I've seen explain how
> Sqlite 2 works
Hello,
I'm trying to figure out the exact algorithm to determine how much data
can be stored within Sqlite 3's B-tree without using overflow pages.
I've searched quite a bit and all the documents I've seen explain how
Sqlite 2 works with a page size of 1024 which results in 238 bytes
available
Hi all,
There seem to be several SQLite GUI apps around. But I haven't seen
any that offer building of layouts, ie positioning test frames for
fields on a page for form data entry or printing. This feature is
typical of proprietary apps such as FileMaker, AppleWorks, 4D etc.
Anyone know
Hi,
I created a patch which adds "-bail" and ".bail" commands to the sqlite3
shell. When bail is enabled, the shell will exit with a non-zero return
code immediately upon encountering the first SQL error. This is useful
when you pass a number of commands to the shell non-interactively and
wish
T wrote:
1. Is this a known bug in SQLite's csv output? Will it be fixed?
Tom,
Yes this is a know issue. I wouldn't hold my breath waiting for it to be
fixed
2. Is there another way to reliably get the contents of a database via
the command line? It must handle values containing pipes,
Dave Dyer wrote:
I can't find an example, but it seems like there ought to be
syntax to use bind to inline selection variables, instead of
having to have a callback function.
Something like:
char *forval,*barval;
sqlite_prepare(db,"select ?foo,?bar from table");
sqlite_bind("?foo",);
T wrote:
1. Is this a known bug in SQLite's csv output? Will it be fixed?
SQLite is a database library and the shell is just a handy tool that
happens to come with it. ISTM that the developers (should) give bugs
like this a pretty low priority.
2. Is there another way to reliably get the
7 matches
Mail list logo