Fine Benoit! That's efficiency
Regards
2015-01-07 0:11 GMT+01:00 Benoît Minisini :
> Le 06/01/2015 19:28, Jorge Carrión a écrit :
> > I've tested "PRAGMA foreign_keys=ON" and it works fine...
> >
> > I can live without "PRAGMA fields_info".
> > Gambas rules!!
> >
> > Regards
> >
>
> "PRAGMA" and
Le 06/01/2015 19:28, Jorge Carrión a écrit :
> I've tested "PRAGMA foreign_keys=ON" and it works fine...
>
> I can live without "PRAGMA fields_info".
> Gambas rules!!
>
> Regards
>
"PRAGMA" and "WITH" are now supported in the gb.db.sqlite3 component, as
well as in the IDE database editor. Check r
I've tested "PRAGMA foreign_keys=ON" and it works fine...
I can live without "PRAGMA fields_info".
Gambas rules!!
Regards
2015-01-06 19:16 GMT+01:00 Jorge Carrión :
> >As for the use of PRAGMA, it never worked before.
>
> But it did! I had a application that uses to PRAGMA sentences: the PRAGMA
>As for the use of PRAGMA, it never worked before.
But it did! I had a application that uses to PRAGMA sentences: the PRAGMA
table_info and the PRAGMA Foreign_keys = ON. I tested it time ago, don't
know how much time or wich version of gambas or SQLite, sorry, but it
worked... (perhaps Gambas2...)
Le 06/01/2015 17:29, Jorge Carrión a écrit :
> I find the old code that shows the slowly of database objects in loops.
> Just trying to get de length of all fields of all tables in a database:
>
> For Each tbl In hc.Tables
> Print tbl.Name
> For Each fld In tbl.fields
>
>I'm curious about how you wrote your loop...
I'll try to find the old code where I did those loops. I think I should
have a sample in some old backup.
>No idea. When you use "Exec", the request is directly sent to the
>database client library. What does not work?
That instruction exctact from d
Le 06/01/2015 14:20, Jorge Carrión a écrit :
> Hi
> I used to use this sentence in SQLite databases in order to obtain fields
> information
>
>
> rs = hc.exec("PRAGMA table_info(`" & mytablename & "`)")
>
> It worked fine. I used it because the slow of gambas database objects when
> are used in loo
Hi
I used to use this sentence in SQLite databases in order to obtain fields
information
rs = hc.exec("PRAGMA table_info(`" & mytablename & "`)")
It worked fine. I used it because the slow of gambas database objects when
are used in loops.
I haven't used it since a don't-know-how-much time and
