[Gambas-user] gb.db.form: Program hangs after erasing content in a DataControl and clicking into a DataBrowser

[Christof Thalhofer]

Hi,

Am 12.09.2014 um 10:52 schrieb Tobias Boege:
>> Grmbl.
> 
> If you have time, of course! Or do what you want. It was just a quick idea.

:-)

Had a nice afternoon updating some machines / waiting for the next
question / programming your thing.

>>> Have you tested that? Do you have a patch for the project?
>>
>> No. I don't even know how to create a patch for Gambas.
> 
> Not for Gambas. For my Gambas project only. This is pretty easy *slap on
> my back*. You have a source archive of the old project, right? Then you
> uncompress it and change the project. In the IDE menu: Project -> Patch
> -> Create, a wizard will guide you through the creation of a patch for a
> Gambas project. The result is what you changed in the currently opened
> project from the source archive you select in the wizard.

Ok, the patch is attached. It works on my Mysql-server (but also there
are some hangs, maybe that was, what Benoit fixed). I did a module which
contains the connection to db together with the credentials. One could
fetch them from Settings there.

If you have a look at the connection, you will see, it is not closed als
long as the app lives.

It is persistant and u can reuse it in different places of your app.

I personally always work with results, that are defined in the
functions, and fill the controls with the data of the results which are
queried via this one connection.

This one persistant connection (per DB) ensures, that you will not do
something ugly where two parts of your application fiddle with the same
data via different connections. This is especially important, when your
app grows ...

I did and do not like the code, that creates the database, it injects
unneccessary complexity.


Alles Gute

Christof Thalhofer

-- 
[x] nail here for new monitor

-------------- next part --------------
A non-text attachment was scrubbed...
Name: KontakteMySQL-0.1.25.patch
Type: text/x-patch
Size: 11704 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20140912/c5e6bdb3/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: OpenPGP digital signature
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20140912/c5e6bdb3/attachment.sig>