On 25 jul 2004, at 23:50, gohaku wrote:
Hi everyone,
I was just curious if there is a way to see what tables have been
created in a SQLite database.
SELECT tbl_name FROM sqlite_master;
-- Tito
smime.p7s
Description: S/MIME cryptographic signature
Hi everyone,
I was just curious if there is a way to see what tables have been
created in a SQLite database.
Thanks.
-gohaku
Since SQLite v2 was 'typeless', one had to call atoi() and atof() on terms
of the array *azArg to convert the text strings returned by a query into
integers and doubles.
As I understand it SQLite v3 stores integers and doubles in their native
binary format so one should be able to get at the numer
Le dimanche 25 Juillet 2004 21:28, [EMAIL PROTECTED] a écrit :
>
> Let me explain, I guess I did no express myself clear.
>
> There is quit some SQL-generating software (like MDA*-software, but also all
kind
> of GUI's for databases, and these kind of GUI's can be everywhere in many
kinds
> o
> The code is Cocoa-based, but could easily be adapted to other
> languages. I could build a GUI environment to alter a table and to
> generate the SQL statements as well, I don't see what the problem is.
> As I said earlier, the issue with the workaround is that it has to
> copy the entire table t
> Bert Verhees wrote:
> >
> > The workaround for ALTER TABLE is not useable in SQL-code generating
> > environments.
>
> Sorry for being dense, but can you elaborate on the above? Why can't
> such code be generated?
Let me explain, I guess I did no express myself clear.
There is quit some SQ
On 25 jul 2004, at 13:21, Bert Verhees wrote:
These newly added features were long requested as well, and although
ALTER TABLE is indeed an important feature too, there are probably
other issues that require more attention right now.
In any case, there is an entry on the FAQ section that shows
Bert Verhees wrote:
The workaround for ALTER TABLE is not useable in SQL-code generating
environments.
Sorry for being dense, but can you elaborate on the above? Why can't
such code be generated?
Gerry
--
--
Gerry Snyder
AIS Director, Affiliates Chair, Symposium Chair
in warm, wi
> These newly added features were long requested as well, and although
> ALTER TABLE is indeed an important feature too, there are probably
> other issues that require more attention right now.
>
> In any case, there is an entry on the FAQ section that shows you how to
> do something like ALTER
On 25 jul 2004, at 5:47, Yves Chaufour wrote:
Why has it not been added for SQLite 3 ?
It's perhaps the more wanted SQLite feature, and we can't understand
why it
isn't yet implemented.
Perhaps because you haven't you seen the tremendous amount of work that
has been put into version 3. The differ
Le dimanche 25 Juillet 2004 14:25, M. Fioretti a écrit :
> Yves,
>
> do you have graphs or tables showing these numbers, and explaining how
> they were obtained? If so, what is the URL? It would be great to add
> it in my article, to strenghten our thesis.
>
> > it seems that OOo dba developpers
On Sun, Jul 25, 2004 11:47:27 AM +0200, Yves Chaufour
([EMAIL PROTECTED]) wrote:
> >
> I and a few other independant OOo users have tested OOo with SQLite
> and HSQLDB. Our goal is that these test results help the OOo dba
> developpers to make the choice of the next OOo embedded database.
> Our te
Le samedi 24 Juillet 2004 23:29, D. Richard Hipp a écrit :
> M. Fioretti wrote:
> >
> >>The main drawback of SQLite is that it doesn't support ALTER
> >>TABLE. It's a big limitation for simple users when building a
> >>database. If this fonctionnality (and a few others) could be add in
> >>a near
13 matches
Mail list logo