Re: [Gambas-user] Problem with Gambas and MySql

2013-10-04 Thread Willy Raets
On Fri, 2013-10-04 at 22:53 +0200, Willy Raets wrote: Nando, Fernando and Caveat, Thanks for your responses. > > Content in 'ICzakgewicht' can be like this: > | ID | Gewicht | > 345 100 > 345 100 > 345 50 > 347 200 > 347 200 > 347 200 > 347 200 @ Fernando and Caveat Above you can see that mor

Re: [Gambas-user] Problem with Gambas and MySql

2013-10-04 Thread Caveat
Hi Willy Me again! Either use LIMIT row_count on your delete statement as per http://dev.mysql.com/doc/refman/5.0/en/delete.html Or use an auto-incrementing primary key that your VB clients don't need to worry about as per http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html Ki

Re: [Gambas-user] Problem with Gambas and MySql

2013-10-04 Thread nando
For MySQL to operate properly, you MUST have a column which is a primary key. A "good" table will always have one column set as Primary Key. If you don't have one, make one as INT(9) AutoIncrement, Not NULL Name the column 'recid' and use 'recid' to delete a particular row -- Original Mes

Re: [Gambas-user] Problem with Gambas and MySql

2013-10-04 Thread Fernando Martins
Hello Willy forgive me, I haven't really tried your application, but why can't you send a SQL DELETE statement? Fernando On 10/04/2013 10:53 PM, Willy Raets wrote: > Hi All, > > In a bigger project where creating, editing and deleting records works > as a charm, only one table is giving me trou

Re: [Gambas-user] How do I add a script to a Deb file

2013-10-04 Thread Willy Raets
On Fri, 2013-10-04 at 13:19 -0700, Charlie wrote: > Thaks Willy, you have hit the nail on the head. If trying to do this is > unethical I will accept it, but I would still like to understand how to do > it. > Best solution would still be to get 3.4.2 into official repo. This means getting it into

[Gambas-user] Problem with Gambas and MySql

2013-10-04 Thread Willy Raets
Hi All, In a bigger project where creating, editing and deleting records works as a charm, only one table is giving me trouble and just won't delete a record with reason 'No primary key'. Now the table in question 'ICzakgewichten' was migrated from an Access database to MySql and in Access it was

Re: [Gambas-user] How do I add a script to a Deb file

2013-10-04 Thread Charlie
Thaks Willy, you have hit the nail on the head. If trying to do this is unethical I will accept it, but I would still like to understand how to do it. -- View this message in context: http://gambas.8142.n7.nabble.com/How-do-I-add-a-script-to-a-Deb-file-tp43475p43480.html Sent from the gambas-us

Re: [Gambas-user] How do I add a script to a Deb file

2013-10-04 Thread Willy Raets
On Fri, 2013-10-04 at 20:57 +0200, Antonio Sánchez wrote: > That way is not a good idea. You can run scripts in a deb file, but if you > want force install gambas, you should write gambas3 in the control file as > a dependency. > Hi Antonio, 1. Making Gambas a dependency is already done when th

Re: [Gambas-user] How do I add a script to a Deb file

2013-10-04 Thread Kende Krisztián
Fri, 4 Oct 2013 11:52:05 -0700 (PDT) -n Charlie írta: > Is there a way to add commands like the ones below to a Deb file > created in Gambas? > > sudo add-apt-repository ppa:nemh/gambas3  > sudo apt-get update  > > Thanks for any help. > > Charlie Ogier > Debian packages contain two install

Re: [Gambas-user] How do I add a script to a Deb file

2013-10-04 Thread Antonio Sánchez
That way is not a good idea. You can run scripts in a deb file, but if you want force install gambas, you should write gambas3 in the control file as a dependency. 2013/10/4 Charlie > Is there a way to add commands like the ones below to a Deb file created in > Gambas? > > sudo add-apt-reposito

Re: [Gambas-user] can't install my home-made-package, due to the dependencies

2013-10-04 Thread Charlie
Hi Charlie, I have asked the question in another post on how to insert the necessary code in a Deb file. Keep an eye out for any tips. Regards, Charlie Ogier -- View this message in context: http://gambas.8142.n7.nabble.com/can-t-install-my-home-made-package-due-to-the-dependencies-tp43463p4

[Gambas-user] How do I add a script to a Deb file

2013-10-04 Thread Charlie
Is there a way to add commands like the ones below to a Deb file created in Gambas? sudo add-apt-repository ppa:nemh/gambas3  sudo apt-get update  Thanks for any help. Charlie Ogier -- View this message in context: http://gambas.8142.n7.nabble.com/How-do-I-add-a-script-to-a-Deb-file-tp4347

Re: [Gambas-user] can't install my home-made-package, due to the dependencies

2013-10-04 Thread Charlie Reinl
Am Freitag, den 04.10.2013, 07:56 -0700 schrieb Charlie: > I bumped into this problem. I don't know how to automate this but if you run > the following commands in Terminal on the problem computer and then rerun > the Deb file all should be well. > > The 1st line adds the Gambas3 repository and t

Re: [Gambas-user] can't install my home-made-package, due to the dependencies

2013-10-04 Thread Charlie
I bumped into this problem. I don't know how to automate this but if you run the following commands in Terminal on the problem computer and then rerun the Deb file all should be well. The 1st line adds the Gambas3 repository and the second updates the computer. sudo add-apt-repository ppa:nemh/g

[Gambas-user] Container help

2013-10-04 Thread Charlie
I just can't seem to get my head around Containers. I am trying to get as much "stretch" as I can from "FMain" in the attached program written in Gambas3.4.2. Any help will be gratefully received. Thanks, Charlie Ogier FindFile-0.0.9.tmp.tar.gz

[Gambas-user] Program picture icon

2013-10-04 Thread Charlie
Can you advise me how to attach apicture icon so that at compile time it automatically appears on the Desktop. I noticed that if I compiled the example file "The little text editor" the icon appeared automatically but I can't see how this is done. Thanks, Charlie Ogier -- View this message in