Re: [Gambas-user] hConnection = New Connection ( [ DatabaseURL As String ] ) Clarification

2013-08-28 Thread Bruce
On Wed, 2013-08-28 at 13:47 +0200, Tobias Boege wrote: > On Wed, 28 Aug 2013, Bruce wrote: > > First off, thanks everyone for your answers - all are correct. > > > > My original question was purely about the syntax of the Connection > > constructor, specifically about the optional DatabaseURL para

Re: [Gambas-user] SQL query for DB.Exec() question

2013-08-28 Thread Bruce
On Thu, 2013-08-29 at 01:56 +0200, Willy Raets wrote: > On Thu, 2013-08-29 at 09:17 +0930, Bruce wrote: > > On Thu, 2013-08-29 at 01:25 +0200, Willy Raets wrote: > > > On Wed, 2013-08-28 at 22:28 +0200, Tobias Boege wrote: > > > > On Wed, 28 Aug 2013, Willy Raets wrote: > > > > > Hello all, > > > >

Re: [Gambas-user] SQL query for DB.Exec() question

2013-08-28 Thread Randall Morgan
Can you give us a dump of the table structure of all tables involved in the query, perhaps from something like phpmyadmin or a similar tool? On Wed, Aug 28, 2013 at 4:56 PM, Willy Raets wrote: > On Thu, 2013-08-29 at 09:17 +0930, Bruce wrote: > > On Thu, 2013-08-29 at 01:25 +0200, Willy Raets wr

Re: [Gambas-user] SQL query for DB.Exec() question

2013-08-28 Thread Willy Raets
On Thu, 2013-08-29 at 09:17 +0930, Bruce wrote: > On Thu, 2013-08-29 at 01:25 +0200, Willy Raets wrote: > > On Wed, 2013-08-28 at 22:28 +0200, Tobias Boege wrote: > > > On Wed, 28 Aug 2013, Willy Raets wrote: > > > > Hello all, > > > > > > > > I've been searching the Gambas mailing list archives a

Re: [Gambas-user] SQL query for DB.Exec() question

2013-08-28 Thread Bruce
On Thu, 2013-08-29 at 01:25 +0200, Willy Raets wrote: > On Wed, 2013-08-28 at 22:28 +0200, Tobias Boege wrote: > > On Wed, 28 Aug 2013, Willy Raets wrote: > > > Hello all, > > > > > > I've been searching the Gambas mailing list archives and documentation > > > for a answer to a problem I have. Tri

Re: [Gambas-user] SQL query for DB.Exec() question

2013-08-28 Thread Willy Raets
On Wed, 2013-08-28 at 14:08 -0700, Randall Morgan wrote: > FYI > > > It is standard practice to never use spaces in MySQL table and field > names. Replace the spaces with underscores. Also, it's good to use > only lower case field names (especially if you access the database > remotely. So your f

Re: [Gambas-user] SQL query for DB.Exec() question

2013-08-28 Thread Willy Raets
On Wed, 2013-08-28 at 23:16 +0200, Charlie Reinl wrote: > On Wed, 28 Aug 2013 22:18:52 +0200, Willy Raets > > wrote: > > Hello all, > > > > I've been searching the Gambas mailing list archives and documentation > > for a answer to a problem I have. Tried all kinds of suggestions but > > haven't s

Re: [Gambas-user] SQL query for DB.Exec() question

2013-08-28 Thread Willy Raets
On Wed, 2013-08-28 at 22:28 +0200, Tobias Boege wrote: > On Wed, 28 Aug 2013, Willy Raets wrote: > > Hello all, > > > > I've been searching the Gambas mailing list archives and documentation > > for a answer to a problem I have. Tried all kinds of suggestions but > > haven't solved the problem yet

[Gambas-user] Request for small addition

2013-08-28 Thread Willy Raets
Hi all, Could a line for Icelandic be added to the Language.module: Location on SVN should be gambas/branches/trunk/app/src/gambas3/.src/Translation/Language.module This so there can be a .po file for Icelandic made and translations can be entered. I happen to have received Icelandic translation

[Gambas-user] Gambas3 Sample file does not compile

2013-08-28 Thread mx4evaNZ .
Hi The GamgasGears 3.0.0 sample file does not compile the following error is shown: gb.sdl error. Could not open: /../gb.sdl/DejavuSans.ttf Other files compile and run okay Running Linux Mint 15 (Olivia) 64 bit latest version Kim --

Re: [Gambas-user] SQL query for DB.Exec() question

2013-08-28 Thread Charlie Reinl
On Wed, 28 Aug 2013 22:18:52 +0200, Willy Raets wrote: > Hello all, > > I've been searching the Gambas mailing list archives and documentation > for a answer to a problem I have. Tried all kinds of suggestions but > haven't solved the problem yet. > > This is the situation simplified: > > A MyS

Re: [Gambas-user] SQL query for DB.Exec() question

2013-08-28 Thread Randall Morgan
FYI It is standard practice to never use spaces in MySQL table and field names. Replace the spaces with underscores. Also, it's good to use only lower case field names (especially if you access the database remotely. So your fields should be: product_id initial_ic actual_ic etc.. Using mixed ca

Re: [Gambas-user] SQL query for DB.Exec() question

2013-08-28 Thread Tobias Boege
On Wed, 28 Aug 2013, Willy Raets wrote: > Hello all, > > I've been searching the Gambas mailing list archives and documentation > for a answer to a problem I have. Tried all kinds of suggestions but > haven't solved the problem yet. > > This is the situation simplified: > > A MySql database name

[Gambas-user] SQL query for DB.Exec() question

2013-08-28 Thread Willy Raets
Hello all, I've been searching the Gambas mailing list archives and documentation for a answer to a problem I have. Tried all kinds of suggestions but haven't solved the problem yet. This is the situation simplified: A MySql database named MyData with a two tables named IC and Products. Both tab

Re: [Gambas-user] SQLite3 VARYING CHARACTER(255) taken as Boolean?

2013-08-28 Thread Tobias Boege
On Wed, 07 Aug 2013, Beno?t Minisini wrote: > Le 05/08/2013 16:22, Tobias Boege a ?crit : > > Hi, > > > > we have a case at http://gambas-club.de where one uses an SQLite3 database > > with some fields being of type VARYING CHARACTER(255). These are all shown > > to be Booleans by Gambas code. Note

Re: [Gambas-user] hConnection = New Connection ( [ DatabaseURL As String ] ) Clarification

2013-08-28 Thread Tobias Boege
On Wed, 28 Aug 2013, Bruce wrote: > First off, thanks everyone for your answers - all are correct. > > My original question was purely about the syntax of the Connection > constructor, specifically about the optional DatabaseURL parameter. > > Clarification 1: According to the help there are thre

Re: [Gambas-user] hConnection = New Connection ( [ DatabaseURL As String ] ) Clarification

2013-08-28 Thread Bruce
First off, thanks everyone for your answers - all are correct. My original question was purely about the syntax of the Connection constructor, specifically about the optional DatabaseURL parameter. Clarification 1: According to the help there are three ways to initialise a connection: a) by direc

Re: [Gambas-user] hConnection = New Connection ( [ DatabaseURL As String ] )

2013-08-28 Thread Tobias Boege
On Tue, 27 Aug 2013, paulwheeler wrote: > >Bruce and Fabien, >My email a few days back gave the code that I am using to open sqlite >databases. That code opens a db in any directory you have access to. Is >there something I am not understanding about Bruce's question? >The cod

Re: [Gambas-user] List of Open Forms?

2013-08-28 Thread Tobias Boege
On Tue, 27 Aug 2013, Kende Kriszti??n wrote: > > I edited the docs accordingly. Did I get all your points? > > > > Regards, > > Tobi > > Oh, thanks. But "the main window is the first created window" is not > true. Because if Print Application.MainWindow then see nothing, and if > closing the firs

Re: [Gambas-user] List of Open Forms?

2013-08-28 Thread Jack
Le 27/08/2013 17:51, Ru Vuott a écrit : > I tried this simple code: > > Private w As Window > > > Public Sub Form_Open() > >With w = New Window > .W = 100 > .H = 100 > .X = 0 > .Y = 0 > .Show >End With > >With w = New Window > .W = 100 > .H = 100 >