Re: [Gambas-user] gb.GeneralDate formatting is inconsistent

2012-02-05 Thread Zach Smith
> gb.GeneralDate prints the date part the short way (dd/mm/yy) and prints > the time if it is not zero. The middle example is still inconsistent if one expects 00:00:00 to be a valid time, that is, midnight (12:00 AM). Also note that the format is mm/dd/yy only if the time is not 00:00:00. One c

Re: [Gambas-user] How To INSERT INTO in MySQL?

2012-02-05 Thread Алексей Беспалов
abbat, see exeple http://gambas.pro/gambas/gambas_mysql_podkluchenie.htm 2012/2/6 Robert Juhasz > On 02/06/2012 12:45 AM, abbat wrote: > > I cant make to work the command for MySQL which works perfect on VB.NET > > > > Dim COMMAND = New MySqlCommand("INSERT INTO statistic ("& > >

Re: [Gambas-user] How To INSERT INTO in MySQL?

2012-02-05 Thread Robert Juhasz
On 02/06/2012 12:45 AM, abbat wrote: > I cant make to work the command for MySQL which works perfect on VB.NET > > Dim COMMAND = New MySqlCommand("INSERT INTO statistic ("& > "TimeCode, SessionStart, SessionEnd, Kluch, Comp) VALUES ('"& > T& "', now(), now(),'"& kluch& "','"& Nc

Re: [Gambas-user] How To INSERT INTO in MySQL?

2012-02-05 Thread GMail
On Sun, 2012-02-05 at 15:45 -0800, abbat wrote: > I cant make to work the command for MySQL which works perfect on VB.NET > > Dim COMMAND = New MySqlCommand("INSERT INTO statistic (" & > "TimeCode, SessionStart, SessionEnd, Kluch, Comp) VALUES ('" & > T & "', now(), now(),'" & kluch

[Gambas-user] How To INSERT INTO in MySQL?

2012-02-05 Thread abbat
I cant make to work the command for MySQL which works perfect on VB.NET Dim COMMAND = New MySqlCommand("INSERT INTO statistic (" & "TimeCode, SessionStart, SessionEnd, Kluch, Comp) VALUES ('" & T & "', now(), now(),'" & kluch & "','" & Nc & "')") How to make it work? Thanks -- V

[Gambas-user] DataSource & DataBrowser problem

2012-02-05 Thread John Rose
To try & clarify this problem, my code for the button (in my FMain form) click that opens the form which contains the DataSourceCountry & DataBrowserCountry controls is shown below. When the project runs, the FCountryMaintence form is displayed OK except that the DataSourceCountry control is empty

Re: [Gambas-user] extern library

2012-02-05 Thread Wally
talking about Gambas 3: When i place my library to /usr/local/lib and run ldconfig it works and my_gb3_project can find the lib and its functions. When i put it into my_gb3_project folder the library can not be found. Where to place the library ganbas3 may find it ? In e.g. my_gb3_Project/ or

[Gambas-user] gb.db.form driver missing

2012-02-05 Thread John Rose
Michael, I've been trying to get the DataSource & DataBrowser controls working on Gambas3 revision #4445 and I also ran into this problem of 'Driver Missing'. I goggled & found yours & Tobias' posts on this. I've tried to implement your method. When I set my attached Test project to use a module

[Gambas-user] DataSource & DataBrowser problem

2012-02-05 Thread John Rose
I found a message from 16 December 2011 re this problem. The author's solution (author is michael) is: "keep all Db access in a separate class called "data" which handles all communication with the database. I then start my apps with a "Main" module not a form. The Main module will load resources

Re: [Gambas-user] how to insert hImage into table sqlite base

2012-02-05 Thread Benoît Minisini
Le 03/02/2012 08:10, Алексей Беспалов a écrit : > Thank you. > > My code: > Dim sql As String > Dim ImageBlob As String > Dim ResultImg As Result > ImageBlob = File.Load(sFile) > Conn = Connections["Connection1"] > > This code works: > ResultImg = Conn.Create("images_test") > Re

Re: [Gambas-user] gb.GeneralDate formatting is inconsistent

2012-02-05 Thread Benoît Minisini
Le 05/02/2012 08:40, Benoît Minisini a écrit : > Le 03/02/2012 05:41, Zach Smith a écrit : >> The gb.GeneralDate formatting appears to be inconsistent in the >> handling of time 00:00:00.. >> >> ... > > Actually the third formatting is inconsistent. > > gb.GeneralDate prints the date part the shor