Re: [Gambas-user] WebForm
http://gambasforge.org use gb.web too, and gb.image, and gb.web, and gb.pcre Le 4 octobre 2011 00:21, Benoît Minisini gam...@users.sourceforge.net a écrit : Greetings community, I have no clear how to do it and I'm lost, if I could help, I need to create a program that connects to a database and insert records but from the web, but I want to be in shrimp, is it possible and if they out, I could give an idea please. Thank you. Gambas 3 has a gb.web component that allows to write CGI scripts with an ASP- like interface to handle request, response, cookies, forms, file downloads... Adds the gb.db component to your CGI script, and you can connect to your database. I use it for the big project I'm doing for my job (sort of Microsoft Access on the web with no sql, google maps and real-time tracking functions). Regards, -- Benoît Minisini -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user -- Fabien Bodard -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Trouble with Listings
2011/10/4 Dag-Jarle Johansen dag.jarle.johan...@gmail.com: Hey everybody, I am trying to put data into a Tableview (and or gridview), but let us stay with the Tableview. I have a non-existent internet-connection on my usual PC, so I have to tip in the code from memory. I use a recordset named RSF, filled with names (an a few other properties) form a Table. It works without problem, I can see any field and type, and much more I will not need - but in the Grid. I started this way: public sub Makeheader() you need to finish your mail ! -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user -- Fabien Bodard -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Trouble with Listings
Fabien, off course I will - obviously not so comfortable with windows any more - lol - the mail just shot away. public sub MakeHeader() End 2011/10/4 Fabien Bodard gambas...@gmail.com 2011/10/4 Dag-Jarle Johansen dag.jarle.johan...@gmail.com: Hey everybody, I am trying to put data into a Tableview (and or gridview), but let us stay with the Tableview. I have a non-existent internet-connection on my usual PC, so I have to tip in the code from memory. I use a recordset named RSF, filled with names (an a few other properties) form a Table. It works without problem, I can see any field and type, and much more I will not need - but in the Grid. I started this way: public sub Makeheader() you need to finish your mail ! -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user -- Fabien Bodard -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Trouble with Listings
again 2011/10/4 Dag-Jarle Johansen dag.jarle.johan...@gmail.com Fabien, off course I will - obviously not so comfortable with windows any more - lol - the mail just shot away. public sub MakeHeader() Tableview1.Columns = 15 (better would be RSF.Count-1) (I get read-ony on this position) End so I ask myself - I want this quick and dirty - it is a databrowser for internal use, and I mislike MyPHP in the last version - how do I do this. And off course, I ask you too, you are very much better in this than I am. I have a great lot to learn. Thanks in advance and regards Dag-Jarle 2011/10/4 Fabien Bodard gambas...@gmail.com 2011/10/4 Dag-Jarle Johansen dag.jarle.johan...@gmail.com: Hey everybody, I am trying to put data into a Tableview (and or gridview), but let us stay with the Tableview. I have a non-existent internet-connection on my usual PC, so I have to tip in the code from memory. I use a recordset named RSF, filled with names (an a few other properties) form a Table. It works without problem, I can see any field and type, and much more I will not need - but in the Grid. I started this way: public sub Makeheader() you need to finish your mail ! -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user -- Fabien Bodard -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Surrogate keys and database insertions
On Mon, 2011-09-26 at 14:46 +0200, Benoît Minisini wrote: On Mon, 2011-09-26 at 14:03 +0200, Benoît Minisini wrote: This feature is missing, mainly because there is no standard way to do that in SQL, and I don't know if there is a function for that in all SQL DBMS. I was afraid of that. I'll do some research. I know it is possible in postgresql and I think it can be made generic across all inserts. As much as I hate delving in to the twisted entrails of mysql documentation I will endeavour... I don't have much expertise with firebird but there is a learning opportunity, I suppose. With sqlite, a quick look seems there is some probability. I doubt that it is possible with ODBC. I'll get back to you. Bruce Firebird being not GPL, it has been removed from Gambas. So don't worry with it. But I'd like to have the information for the others! Research results so far: 1) I expanded the frame of my original quest to see whether it is possible to implement a with re-read option for both INSERT and UPDATE queries. This would allow an automatic synchronisation of the gambas result with the true database row when the row has been updated with serial, default or computed values at the database level. The theory being that it would work regardless of whether the primary key columns were affected or not. Given the beaut way gambas works with updateable results, I think that the optimal approach would be to have an optional boolean parameter in Result.Update (i.e. Result.Update([WithReread=FALSE]) that would provide the feature but not break existing code. Alas, my C skills are not up to a point where I can try this out on my local trunk copy! Any guidance here would be appreciated. 2) Assuming the above, the internal workings of Result.Update would vary according to the dbms. Sometimes, returning the updated result is available directly from the dbms, other times it would have to be simulated via a subsequent SELECT. Further notes below. 2.1) The problem breaks down into two cases a) where the primary key columns are all provided (by the calling program) in the Result, and b) where some or all of the primary key fields are serial,default or computed. In the first case the solution is trivial, the subsequent SELECT has all it needs to query the updated row and thus refresh the Result object. The second case is more complex. However I believe it can be accomplished depending on the dbms. 2.2) For postgresql (since 8.x) the solution apears trivial as postgresql provides INSERT ... RETURNING and UPDATE ... RETURNING i.e. it can return some or all of the columns after the insert or update has completed. Further, this appears to be well protected from any concurrency or other side effects. 2.3) For MySQL (since ?.?) there is possibly a solution as there is a protected SELECT LAST_INSERT_ID(); that will return the last autoincrement for the most recently executed INSERT on a table containing an autoincrement column. By protected, I mean that it works on a per connection basis, thus avoiding concurrency side effects. Now since MySQL will only allow one autoincrement column per table, if the column is in the primary key then the above approach will work using a subsequent select on the resultant fully populated key. HOWEVER, there is still an unresolved issue if the db supplied key columns are not an autoincrement, say the key contains a db generated timestamp column. I am still looking into this. 2.4) For Sqlite the situation is similar to MySQL but simpler in some ways. It provides SELECT last_insert_rowid() to retrieve serial pkeys. I'm still looking at this as a) I'm not sure yet how far Sqlite goes in terms of the other computed column value types and b) it appears from some web pages that the version of this function in Sqlite2 has some bugs that may never have been fixed. 2.5) For ODBC, I have doubts. I'd have fewer doubts if I could actually get an ODBC driver to work at all on this machine. 2.6) Interestingly, Firebird (since 2.0) does support INSERT ... RETURNING and UPDATE ... RETURNING. Research contnues, but I'd appreciate any thoughts. Bruce -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] gb3: unable to compile on Debian Wheezy (testing)
On 10/02/2011 09:29 AM, Demosthenes Koptsis wrote: On my LMDE which i also had the first problem with the link library is # Libraries that this one depends upon. dependency_libs=' /usr/lib/libfreetype.la -lz -L/usr/lib /usr/lib/libSDL.la' i was firstly had the problem with /usr/lib/libfreetype.la and made a symlink, but after that no other problem. Now i have a working Gambas3 on a Linux Mint Debian edition. I think Debian has some wrong paths for those libs. On Sun, 2011-10-02 at 15:17 +0200, Benoît Minisini wrote: Here is the line in my own libSDL_ttf.la that points at 'libfreetype.la': --8--- dependency_libs=' -L/usr/lib/x86_64-linux-gnu /usr/lib/x86_64-linux- gnu/libfreetype.la -lz -L/usr/lib /usr/lib/libSDL.la' --8--- Compare with yours. Then fix your libSDL_ttf.la file, and recompile from scratch. In the interest of getting work done and facing the future of desktop environments, I came to a painful decision and have switched to Kubuntu 11.10. I decided that Debian Wheezy was insufficiently maintained for stability and that GNOME had become a tragic dead end with the abandonment of the 2.x branch and the pure crap that is the 3.x branch. That left me with KDE and Xfce as my only options, and loving customization and beauty I chose KDE. Hopefully the Debian or Mint team will get this mess sorted out so gb3 can compile without hacks. Thanks for the help anyway, and for anyone else who sees GNOME as the walking dead, I highly recommend Kubuntu or any other well-supported KDE distribution. I should have done this a long time ago. -- Kevin Fishburne Eight Virtues www: http://sales.eightvirtues.com e-mail: sa...@eightvirtues.com phone: (770) 853-6271 -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
