Re: [Gambas-user] [slightly OT] No Problem with Gambas or MySql!

2013-10-07 Thread Caveat
Thanks Randall, we got some great discussions going here. I think the closing paragraph sums it up quite well... So err on the side of caution and normalize your data until you have the experience needed to know when to break the rules. If you always normalize your data you will be correct

Re: [Gambas-user] [slightly OT] No Problem with Gambas or MySql!

2013-10-07 Thread nando
Lovely -- Original Message --- From: Caveat gam...@caveat.demon.co.uk To: gambas-user@lists.sourceforge.net Sent: Mon, 07 Oct 2013 14:04:55 +0200 Subject: Re: [Gambas-user] [slightly OT] No Problem with Gambas or MySql! Thanks Randall, we got some great discussions going here.

[Gambas-user] Am I misunderstanding settings.clear?

2013-10-07 Thread Willy Raets
Hi all, I've been working with settings quite a while now. Today I realised some settings where placed under a new key a while ago. So I looked at the documentation to see if I could remove the old ones. Documentation said...YES -- Gambas Docs on settings.clear -- Sub Clear ( [

Re: [Gambas-user] [slightly OT] No Problem with Gambas or MySql!

2013-10-07 Thread Willy Raets
On Mon, 2013-10-07 at 14:04 +0200, Caveat wrote: Thanks Randall, we got some great discussions going here. I think the closing paragraph sums it up quite well... So err on the side of caution and normalize your data until you have the experience needed to know when to break the rules.

Re: [Gambas-user] Am I misunderstanding settings.clear?

2013-10-07 Thread Willy Raets
On Mon, 2013-10-07 at 23:28 +0200, Willy Raets wrote: Hi all, I've been working with settings quite a while now. Today I realised some settings where placed under a new key a while ago. So I looked at the documentation to see if I could remove the old ones. Documentation said...YES

Re: [Gambas-user] [slightly OT] No Problem with Gambas or MySql!

2013-10-07 Thread Randall Morgan
How old is this database? Is it MySQL or MSSQL? I ask because there was a time when databases did not support transactions. So some db designers did indeed use temporary tables for what was called scratch tables. These were tables where updates were collected over a period of time and then batch

Re: [Gambas-user] wrapping function based on recent Mod thread

2013-10-07 Thread Kevin Fishburne
On 10/06/2013 07:08 AM, Jesus wrote: Hi, Kevin Well, as you know, screen coordinates start in the upper left corner and grow towards the right in the X axis and towards the bottom in the Y axis. Sorry if it's too obvious. So all operations on an hypothetical spaceship, must be done on