if i used absolute path in con.host or con.name without define the other
(by example, define con.name but not con.host) datbase connection does not
opened for slite3
documentation said that only need to define one of those
Lenz McKAY Gerardo (PICCORO)
http://qgqlochekone.blogspot.com
umm interesting, great tobias, thanks...
Lenz McKAY Gerardo (PICCORO)
http://qgqlochekone.blogspot.com
2017-06-16 16:17 GMT-04:00 Tobias Boege :
> On Fri, 16 Jun 2017, PICCORO McKAY Lenz wrote:
> > its there some code to get BEFORE send the query the fields of the table?
> >
> > i mean, in the f
On Fri, 16 Jun 2017, PICCORO McKAY Lenz wrote:
> its there some code to get BEFORE send the query the fields of the table?
>
> i mean, in the following code example i already know the column name, but i
> need firts detect column name to send amount of filters
>
> sCriteria *=* "id = &1"iParamete
yeah--- that i was done.. as you confirmed.. its the only solution
due mysql has the DESCRIBE command, but sqlite need to search in master
table...
thanks
Lenz McKAY Gerardo (PICCORO)
http://qgqlochekone.blogspot.com
2017-06-16 15:47 GMT-04:00 :
> Maybe a previous query like:
>
> SELECT TOP
Maybe a previous query like:
SELECT TOP 1 * FROM
would help with the FOR EACH loop. Don't really know your case though.
Regards,
zxMarce
On Jun 16, 2017, 16:40, at 16:40, PICCORO McKAY Lenz
wrote:
>2017-06-16 15:04 GMT-04:00 ML :
>
>> Does this help?
>>
>> Dim fld as Field
>> For Each
2017-06-16 15:04 GMT-04:00 ML :
> Does this help?
>
> Dim fld as Field
> For Each fld In Result.Fields
> ... do whatever with field names
> Next
>
err zxMarce.. that need a previous query... and i need the filed BEFORE
made the query jajajaj
quite strange but that its!
>
> zxMarce
>
>
On 16/06/17 14:48, PICCORO McKAY Lenz wrote:
> its there some code to get BEFORE send the query the fields of the table?
>
> i mean, in the following code example i already know the column name, but i
> need firts detect column name to send amount of filters
>
> sCriteria *=* "id = &1"iParameter *=
its there some code to get BEFORE send the query the fields of the table?
i mean, in the following code example i already know the column name, but i
need firts detect column name to send amount of filters
sCriteria *=* "id = &1"iParameter *=* *1012*$hConn*.*Begin' Same as
"SELECT * FROM tblDEFAU
I am able to attach a file based SQLite database to in-memory DB and copy
entire database (all tables sequentially using create table + select *
from..) into in-memory DB.How do I do the reverse ? i.e dump in-memory DB
onto a file based sqlite DB by attaching the memory based DB to file based
DB ?
Le 20/06/2016 04:07, adamn...@gmail.com a écrit :
>
> hmm, that contradicts with
> http://gambaswiki.org/wiki/comp/gb.db/connection/name
>
>
Huh, this is a bug in the documentation. :-/ I fix that...
--
Benoît Minisini
---
On Mon, 20 Jun 2016 02:25:18 +0200
Benoît Minisini wrote:
> Le 20/06/2016 01:17, zainudin ahmad a écrit :
> > I can't use it too (attach pic), it's bug ? (attach project)
> >
> > On Sun, Jun 19, 2016 at 5:57 PM, Vinode Singh Ujlain
> > wrote:
> >
> >> Public conH As New Connection
> >> conH.Type
Le 20/06/2016 01:17, zainudin ahmad a écrit :
> I can't use it too (attach pic), it's bug ? (attach project)
>
> On Sun, Jun 19, 2016 at 5:57 PM, Vinode Singh Ujlain
> wrote:
>
>> Public conH As New Connection
>> conH.Type = "sqlite3"
>> conH.name = ":memory:"
>>Try conH.Open()
>> If Error
I can't use it too (attach pic), it's bug ? (attach project)
On Sun, Jun 19, 2016 at 5:57 PM, Vinode Singh Ujlain
wrote:
> Public conH As New Connection
> conH.Type = "sqlite3"
> conH.name = ":memory:"
> Try conH.Open()
>If Error Then
> Print "Unable to open database \n Error :"; Erro
Public conH As New Connection
conH.Type = "sqlite3"
conH.name = ":memory:"
Try conH.Open()
If Error Then
Print "Unable to open database \n Error :"; Error.Text
Error I am getting is :-
/Unable to open database //
//Error : Unable to locate database `:memory:` in ``/
conH.name
Op 19-10-15 om 17:55 schreef Benoît Minisini:
Le 19/10/2015 17:38, Johny Provoost a écrit :
Hallo,
Is it possible to delete a field in a table from a SQLite database
through gambas code?
with
FMain.tmpSQL = "ALTER TABLE " & FMain.lstTables.Text & " ADD " &
FieldNew.txtFieldname.Text & "
Le 19/10/2015 17:38, Johny Provoost a écrit :
> Hallo,
>
> Is it possible to delete a field in a table from a SQLite database
> through gambas code?
>
> with
> FMain.tmpSQL = "ALTER TABLE " & FMain.lstTables.Text & " ADD " &
> FieldNew.txtFieldname.Text & " " & FieldNew.cmbFieldType.Text
>
Hallo,
Is it possible to delete a field in a table from a SQLite database
through gambas code?
with
FMain.tmpSQL = "ALTER TABLE " & FMain.lstTables.Text & " ADD " &
FieldNew.txtFieldname.Text & " " & FieldNew.cmbFieldType.Text
FMain.openSQL = FMain.$hConnLocl.EXEC(FMain.tmpSQL)
I can add
Thanks,
you are right , it works now.
Regards,
Ivan
-Ursprüngliche Nachricht-
Von: Benoît Minisini [mailto:gam...@users.sourceforge.net]
Gesendet: Donnerstag, 20. August 2015 15:33
An: mailing list for gambas users
Betreff: Re: [Gambas-user] SQLite problem, data has not been read
Thanks, I'll try tomorrow.
Regards,
Ivan
-Ursprüngliche Nachricht-
Von: Benoît Minisini [mailto:gam...@users.sourceforge.net]
Gesendet: Donnerstag, 20. August 2015 15:33
An: mailing list for gambas users
Betreff: Re: [Gambas-user] SQLite problem, data has not been read
>> W
>> What's wrong exactly?
>>
>
> Ha ok, I see.
>
The main reason is that you use "STRING" as SQL datatype, which is an
unknown SQL datatype.
The bug is that the new SQLite driver does not react intelligently. This
will be fixed in the next release, but do use standard SQL datatypes if
you don't
Le 20/08/2015 15:23, Benoît Minisini a écrit :
> Le 20/08/2015 14:38, Ivan Kern a écrit :
>>
>>
>> Hi,
>>
>>
>>
>>
>>
>> Data read from SQLite database is not possible.
>> Result delivers everything possible but not correct data.
>> Is it a bug?
>>
>> I use Gambas3.8 stable.
>>
>> With earlier vers
Le 20/08/2015 14:38, Ivan Kern a écrit :
>
>
> Hi,
>
>
>
>
>
> Data read from SQLite database is not possible.
> Result delivers everything possible but not correct data.
> Is it a bug?
>
> I use Gambas3.8 stable.
>
> With earlier versions of Gambas I have no problems.
>
> This does not work on Ubu
Hi,
Data read from SQLite database is not possible.
Result delivers everything possible but not correct data.
Is it a bug?
I use Gambas3.8 stable.
With earlier versions of Gambas I have no problems.
This does not work on Ubuntu14.04 LTS and on Xubuntu14.04 LTS as well.
Project exam
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
Le 29/05/2012 07:43, Bruce a écrit :
> Is there any way to access (read-only of course) an sqlite database
> inside the gambas executable?
>
> Strange idea I know, but I've got this "really good idea".
>
> Bruce
>
At program startup, you must copy the sqlite file from the executable
(with COPY) t
Hi Bruce,
what about to cat the database-file at the end of an executable and
strip it later (perhaps with cut) and store it, where you like.
Another methode could be, study the C-code of the sqlite-libs and see,
if you can open the database with an offset - i.e. the data will begin
at the end
On Wed, 2012-05-30 at 01:38 +0200, Emil Lenngren wrote:
> If you only use the database file as a container for help files, isn't it
> possible to store the help files directly under a directory structure
> (which can be packed in the executable) or something, instead of having a
> database?
>
> /E
On Tue, 2012-05-29 at 16:19 -0700, Randall Morgan wrote:
> As I understand Sqlite, the database is file based, and the file path can
> be passed to the open/connect method. So what is to keep you from putting
> the db file in the data directory of the application?
That's where it is (and that's w
If you only use the database file as a container for help files, isn't it
possible to store the help files directly under a directory structure
(which can be packed in the executable) or something, instead of having a
database?
/Emil
2012/5/30 Randall Morgan
> As I understand Sqlite, the databa
As I understand Sqlite, the database is file based, and the file path can
be passed to the open/connect method. So what is to keep you from putting
the db file in the data directory of the application? I'll admit I have not
used Sqlite in four or five years. I mostly use MySQL and MS SQL. Which are
On Tue, 2012-05-29 at 12:17 -0700, Randall Morgan wrote:
> Can you explain in a little more detail what you want to do?
>
>
>
> On Mon, May 28, 2012 at 10:43 PM, Bruce wrote:
>
> > Is there any way to access (read-only of course) an sqlite database
> > inside the gambas executable?
> >
> > Str
Can you explain in a little more detail what you want to do?
On Mon, May 28, 2012 at 10:43 PM, Bruce wrote:
> Is there any way to access (read-only of course) an sqlite database
> inside the gambas executable?
>
> Strange idea I know, but I've got this "really good idea".
>
> Bruce
>
>
>
> ---
On Tue, 2012-05-29 at 15:13 +0930, Bruce wrote:
> Is there any way to access (read-only of course) an sqlite database
> inside the gambas executable?
>
> Strange idea I know, but I've got this "really good idea".
>
> Bruce
>
FireFox uses SQLite to manage their 'cookie' DB. I don't think the OS
I suppose it is possible, but not easy. Unless you copy database out from
executable to access it.
But what's the point then... or anyway..?
Jussi
On 29 May 2012 08:43, Bruce wrote:
> Is there any way to access (read-only of course) an sqlite database
> inside the gambas executable?
>
> Stran
Is there any way to access (read-only of course) an sqlite database
inside the gambas executable?
Strange idea I know, but I've got this "really good idea".
Bruce
--
Live Security Virtual Conference
Exclusive live event
tobias schrieb:
> good evening,
> i have a more sqlite related question:
> what does it mean in the doc: For SQLite, you can also create and use a
> database in memory by giving as database name the string ":memory:".
> (from gambas2 doc, gb.db.connection.name)
>
> what is creating a database in
good evening,
i have a more sqlite related question:
what does it mean in the doc: For SQLite, you can also create and use a
database in memory by giving as database name the string ":memory:".
(from gambas2 doc, gb.db.connection.name)
what is creating a database in memory?? simply a temporary d
it say just that the sqlite3 driver can manage sqlite 2 database ...
so ..; select sqlite3 :)
2010/11/2 tobias :
> good evening,
> i have a simple question.
> in the doc it is said that "The SQLite driver supports the version 3 of
> SQLite, and falls back to the version 2 driver if needed. See
> w
good evening,
i have a simple question.
in the doc it is said that "The SQLite driver supports the version 3 of
SQLite, and falls back to the version 2 driver if needed. See
www.sqlite.org for more information. "
first, i can't find these "more information"...
and i what could be reasons for the
> Hi everyone,
> I have recently discovered Gambas and am using it on a PCLinuxOS 2010
> distribution.
> I have used SQLite databases under VB and RealBasic but am kindof
> stumped with SQLite3.
> I am writing a Ham radio Logger App and I need to check the DB tables
> etc on loading the App.
>
>
Hi everyone,
I have recently discovered Gambas and am using it on a PCLinuxOS 2010
distribution.
I have used SQLite databases under VB and RealBasic but am kindof
stumped with SQLite3.
I am writing a Ham radio Logger App and I need to check the DB tables
etc on loading the App.
I have been ab
Sorry, don't think I can help you here.
Matti
Am 07.02.2010 20:17, schrieb M. Cs.:
> I'm developing the GamCat cataloging program. I'd like to add possibilities
> to scan CD/DVDs and to create thumbnail images, which would be stored in a
> database file, and the user could optionaly see the thumbn
I'm developing the GamCat cataloging program. I'd like to add possibilities
to scan CD/DVDs and to create thumbnail images, which would be stored in a
database file, and the user could optionaly see the thumbnails of the
pictures in a TreeView , which would visually display the content of the
archi
Hi M. Cs.,
I'm not really sure what you want.
Is it: the user chooses a picture directory, and you want to display the
thumbnails of the pictures? In PictureBoxes, or frames containing PictureBoxes?
Then you wouldn't need any database, and I could help you. Did this with just an
array of file na
Hi,
I'd like to know how can I store image thumbnails (~10 KByte each) inside
the sqlite database using Gambas. I'd like to use the stored thumbs as
preview images, so I'd have to know how to read the blob data out of
database and use it as a content of a Picture container.
Once more:
CREATE TABLE
Anybody using these two together?
I made an ultra-simple SQLite database to help me pick through and learn
what GridEditor does. When I get to:
[FTest]
with grid
...
.open
[DBGridEditor & DBConnection]
I get "Query Failed: SQL error or missing database." and it doesn't occur
until $conn.Roll
> Greetings
> I have a problem - I can query a sqlite database using
>
> SELECT ssym,sclose FROM shistory where (sdate='2009-05-06') and sclose<.75
> and sclose > .1 order by ssym,sdate;
>
> and receive the following output:
> AAC|0.24
> AAME|0.64
> AAU|0.61
> ABMC|0.16
> ABTL|0.5
> ACLS|0.47
Hi,
SQLite is a bit unusual. As the FAQ at www.sqlite.org says, the field type
is is one of expectation rather than definition (with the exception of an
integer primary key). This is demonstrated in your example where you have
put real numbers (0.64) into an integer field. SQLite doesn't care: it
Greetings
I have a problem - I can query a sqlite database using
SELECT ssym,sclose FROM shistory where (sdate='2009-05-06') and sclose<.75 and
sclose > .1 order by ssym,sdate;
and receive the following output:
AAC|0.24
AAME|0.64
AAU|0.61
ABMC|0.16
ABTL|0.5
ACLS|0.47
but when I do the sa
Thank you for your answer.
Meantime i realised the autoincrementation for INT4 "manually" in my
project.
Because i am a novice developer I learned a lot with this trouble at least.
:-)
br
attila
moon_walker wrote:
>
> Hi Benoit,
>
> i am developing a cross platform application. The linux side
On mardi 16 décembre 2008, moon_walker wrote:
> Hi Benoit,
>
> i am developing a cross platform application. The linux side is on GAMBAS
> and the Win side is on
> C#.NET. The common part is the SQLite database.
>
> There is some foreign relations which are coupled with comboboxes.
> So the child t
Hi Benoit,
i am developing a cross platform application. The linux side is on GAMBAS
and the Win side is on
C#.NET. The common part is the SQLite database.
There is some foreign relations which are coupled with comboboxes.
So the child table has some foreign key fields joined to parent primary
k
Benoit Minisini kirjoitti:
>>
>
> The sqlite2 component is independent of the sqlite3 component. The two shared
> libraries they are based on are different: libsqlite.so & libsqlite3.so.
>
> So this is not a problem if you cannot compile the sqlite2 component. This
> component may even be remov
On mardi 10 juin 2008, Kari Laine wrote:
> Hi,
>
> Now I have had almost all the modules to compile in the Gambas. sqlite2
> is stilling giving me problems. From their web-site there is only
> available version 3.5.9. I compiled this and still gambas is not happy
> because the sqlite.h has changed
Hi,
Now I have had almost all the modules to compile in the Gambas. sqlite2
is stilling giving me problems. From their web-site there is only
available version 3.5.9. I compiled this and still gambas is not happy
because the sqlite.h has changed to sqlite3.h and lisqlite.so has
changed to libs
62 matches
Mail list logo
