[Gambas-user] SQLTE3 >date function

2010-09-19 Thread Bill-Lancaster
7;2009-07-01'). Also sometimes records 1 day older than requested can be returned. Using strftime seem very tricky for say dates between 2009-06-30 and 2010-07-01. Any thoughts? Bill Lancaster -- View this message in context: http://old.nabble.com/SQLTE3-%3Edate-function-tp29751718p2975

Re: [Gambas-user] SQLTE3 >date function

2010-09-20 Thread Bill-Lancaster
Dear Benoît, Please see attached - Ive not done this before, hope it works Bill Lancaster http://old.nabble.com/file/p29760629/demo demo http://old.nabble.com/file/p29760629/FMain.class FMain.class -- View this message in context: http://old.nabble.com/SQLTE3-%3Edate-function

Re: [Gambas-user] SQLTE3 >date function

2010-09-22 Thread Bill-Lancaster
I don't think the test programme arrived! Anyway, I have found that using the SQLitte3 DATE function solves the problem, so:- AND DATE(TransDate) >= '2009-07-01' produces the correct result. Thanks -- View this message in context: http://old.nabble.com/SQLTE3-%3Edate-function-tp29751718p29776

Re: [Gambas-user] Controlling mplayer while embeded...

2011-03-17 Thread Bill-Lancaster
Stephen - I'm trying the thing. PRINT #$hProcess, " ";'pause and PRINT #$hProcess, "q"; 'stop works fine. At the moment I'm struggling to 'jump' forward to a specific point in an audio file. Bill Lancaster -- View this mess

[Gambas-user] help with EXEC usage

2011-03-22 Thread Bill-Lancaster
This works OK in terminal:- get_iplayer --stream 12735 | mplayer -cache 3072 - But I can't get it to run in EXEC, e.g $hProcess = EXEC ["get_iplayer", "--stream", "12735", "|", "mplayer", "-cache", "3072 -"

Re: [Gambas-user] help with EXEC usage

2011-03-23 Thread Bill-Lancaster
Jussi, thanks for the advice. I forgot to mention that it worked also with SHELL but I had no control over the process. $hProcess = SHELL ("get_iplayer --stream 13280 | mplayer -cache 3072 -") FOR WRITE Neither PRINT #$hProcess, "q"; nor IF $hProcess THEN $hProcess.Kill nor

Re: [Gambas-user] help with EXEC usage

2011-03-23 Thread Bill-Lancaster
Jussi - little project attached -- View this message in context: http://old.nabble.com/help-with-EXEC-usage-tp31208112p31221079.html Sent from the gambas-user mailing list archive at Nabble.com. -- Enable your software

Re: [Gambas-user] help with EXEC usage

2011-03-23 Thread Bill-Lancaster
Sorry - I'll try again. Its so simple, hardly worth making a project. I'm using get_iplayer in a Gambas project to download past BBC radio programmes. It's working fine. To listen to the programme, this is the code - get_iplayer --stream 13142 | mplayer -cache 3072 -, where 13142 is the progra

Re: [Gambas-user] help with EXEC usage

2011-03-25 Thread Bill-Lancaster
Benoît, what do you mean by "run shell again" ? I tried:- IF hProc THEN hProc.Kill SHELL "" ENDIF with no effect Bill -- View this message in context: http://old.nabble.com/help-with-EXEC-usage-tp31208112p31235898.html Sent from the gambas-user mailing list archiv

Re: [Gambas-user] help with EXEC usage

2011-03-26 Thread Bill-Lancaster
Thank you, IF hProc.State = Process.Running THEN SHELL ("pidof get_iplayer") TO pid1 SHELL ("pidof mplayer") TO pid2 DEBUG pid1;; pid2 SHELL "kill " & pid1 & " " & pid2 hProc.Kill() ENDIF To me this is nice code - it works! Bill -- View this message in contex

[Gambas-user] Tableview use of combobox problem

2011-04-06 Thread Bill-Lancaster
I have a table view which has a list of values in column 0. I want to select from a range of items (sInstruments[]) in column 1 . This code:- IF tbvPerf.Column = 1 THEN tbvPerf.Edit(sInstruments, FALSE) works fine. But when another cell is selected the previous cell is goes blank. Where am I

Re: [Gambas-user] Tableview use of combobox problem

2011-04-07 Thread Bill-Lancaster
I wasn't using tableview properly - it's fine now -- View this message in context: http://old.nabble.com/Tableview-use-of-combobox-problem-tp31331585p31340031.html Sent from the gambas-user mailing list archive at Nabble.com.

[Gambas-user] Adding "not in list" item to a combobox

2011-04-09 Thread Bill-Lancaster
I have a combobox that is filled when the form is opened. How can the user add an item to the list? -- View this message in context: http://old.nabble.com/Adding-%22not-in-list%22-item-to-a-combobox-tp31362490p31362490.html Sent from the gambas-user mailing list archive at Nabble.com.

Re: [Gambas-user] Adding "not in list" item to a combobox

2011-04-10 Thread Bill-Lancaster
Continued... Using the "Activate" property does the job in the main form. When the combobox is in a sub form the Activate event doesn't fire. The sub form is called using fEditInfo.Show i.e. not modal Gambas 2.21, Ubuntu 10.10 Bill Lancaster -- View this message in

Re: [Gambas-user] Adding "not in list" item to a combobox

2011-04-10 Thread Bill-Lancaster
Whats more, I created another subform but this time not checking "Dialogbox management" and the activate event fires properly Bill Lancaster -- View this message in context: http://old.nabble.com/Adding-%22not-in-list%22-item-to-a-combobox-tp31362490p31362684.html Sent from the gambas-us

Re: [Gambas-user] Adding "not in list" item to a combobox

2011-04-10 Thread Bill-Lancaster
In fact this is really an issue about the Active event not firing in circumstances so I'll raise it as issue separately. Thanks for all your comments Bill Lancaster -- View this message in context: http://old.nabble.com/Adding-%22not-in-list%22-item-to-a-combobox-tp31362490p31363072.html

[Gambas-user] Printing - first lines of text won't print

2011-10-02 Thread Bill-Lancaster
The first 40 lines of text do not print. Running the "Printing" example this still happens. In ModulePrintText.PrintText, if I change 'pagePosition = 0' to 'pagePosition = 3608' then all the text is printed. Any ideas where I'm going wrong Bill Lancaster

[Gambas-user] gb.report Gambas 3 - I'm struggling

2011-12-10 Thread Bill-Lancaster
First, the report example doesn't work for me - it just hangs. I want to print information onto a pre-printed form (one A4 sheet) so there would be a number of fields in specific positions on the page. Building a new project using the same components as the example I can get a form to print OK b

Re: [Gambas-user] gb.report Gambas 3 - I'm struggling

2011-12-11 Thread Bill-Lancaster
Dear Fabien, OK, I have one main form with a button that opens Report1 (a report type of form - is that what you call a 'panel'?) The I added a ReportTextLabel set width, height, x & y. Then in code for Report1 I have, Public Sub TextLabel_Data() Last.Data = "KK" End When I run i

Re: [Gambas-user] gb.report Gambas 3 - I'm struggling

2011-12-11 Thread Bill-Lancaster
A step forward! Have discovered if I insert a ReportTextLabel in Report1 then select 'embed into a container' from its properties I get Panel1 containing the ReportTextLabel. So now I know what you meant by a 'panel' and the error 'Unknown Symbol etc' has gone away. I couldn't see an item calle

Re: [Gambas-user] gb.report Gambas 3 - I'm struggling

2011-12-11 Thread Bill-Lancaster
sorry, I can't find what svn version means! -- View this message in context: http://old.nabble.com/gb.report-Gambas-3---I%27m-struggling-tp32951969p32956050.html Sent from the gambas-user mailing list archive at Nabble.com. --

Re: [Gambas-user] gb.report Gambas 3 - I'm struggling

2011-12-13 Thread Bill-Lancaster
SVN Have installed it (I think!). If I run Gambas3 from where I did the install I get Gambas 2.99.6 - is this the svn? running the report example produces "not enough arguments" when Print button clicked -- View this message in context: http://old.nabble.com/gb.report-Gambas-3---I%27m-struggl

[Gambas-user] Gambas3 Printing - text width

2011-12-17 Thread Bill-Lancaster
I'm using Paint.DrawRichText(MoneyValue, x, y) and want to have money values right justified (ideally '.' justified). The Align.Right option doesn't help. Any ideas? Gambas 2.99.6, qt4 -- View this message in context: http://old.nabble.com/Gambas3-Printing---text-width-tp3299175

Re: [Gambas-user] Gambas3 Printing - text width SOLVED

2011-12-17 Thread Bill-Lancaster
OK, didn't try hard enough! Paint.Font.RichTextWidth(TextString) should do the trick. -- View this message in context: http://old.nabble.com/Gambas3-Printing---text-width-tp32991752p32992108.html Sent from the gambas-user mailing list archive at Nabble.com. ---

[Gambas-user] Document viewing in 3.0

2012-01-17 Thread Bill-Lancaster
What is the best way to view documents in Gambas 3.0? I believe the drawingarea control is not available. In particular I wish to view .pnm and .pdf files. The new pdf viewer is fine for pdf files. -- View this message in context: http://old.nabble.com/Document-viewing-in-3.0-tp33153744p3315374

Re: [Gambas-user] Document viewing in 3.0

2012-01-17 Thread Bill-Lancaster
I wish to display the content of .pnm files in a form -- View this message in context: http://old.nabble.com/Document-viewing-in-3.0-tp33153744p33154217.html Sent from the gambas-user mailing list archive at Nabble.com. --

Re: [Gambas-user] Document viewing in 3.0

2012-01-17 Thread Bill-Lancaster
A search in http://gambasdoc.org/help/ for "DrawingArea" resulted in this message:- "This class does not exist in version 3.0. " I don't really know what that means because I can use DrawingArea in my Gambas 3.0 project OK. So - problem solved -- View this message in context: http://old.nab

Re: [Gambas-user] Document viewing in 3.0

2012-01-17 Thread Bill-Lancaster
Just tried opening a .ps file, "bad PDF Format" was the result! Bill -- View this message in context: http://old.nabble.com/Document-viewing-in-3.0-tp33153744p33154883.html Sent from the gambas-user mailing list archive at Nabble.com. ---

[Gambas-user] Gridview sort function

2014-12-23 Thread bill-lancaster
After setting the sort option (TableView1.Sorted = True) does a click on a column change the state of TableView1.Columns.Sort or do I need to change it myself? -- View this message in context: http://gambas.8142.n7.nabble.com/Gridview-sort-function-tp49863.html Sent from the gambas-user mailin

Re: [Gambas-user] Gridview sort function

2014-12-23 Thread bill-lancaster
Thanks for that Lee, Please see the attached example. The result of the column_click event does not agree with the results of button1_click which reports on the state of .Ascending. In fact after two column_clicks there is no change of state with the Ascending property with the column_click even

Re: [Gambas-user] Gridview sort function

2014-12-24 Thread bill-lancaster
Thanks for taking the time Lee, In fact I made that error when composing a simple example, my main programme didn't have that error. To make things simple for myself I toggle a boolean value every time the gridview1_ColumnClick event occurs rather than use the Ascending value. Thanks again Bill

Re: [Gambas-user] Gridview sort function

2014-12-28 Thread bill-lancaster
Bruno and Lee, thank you for the Christmas present! Bill -- View this message in context: http://gambas.8142.n7.nabble.com/Gridview-sort-function-tp49863p49878.html Sent from the gambas-user mailing list archive at Nabble.com. ---

[Gambas-user] Gridview cell coordinates

2015-01-02 Thread bill-lancaster
I want to position a balloon by the gridview cell that was right clicked. It is necessary to scroll down to the lower rows. I'm struggling with this so any suggestion as to the best way to do this would be welcome. -- View this message in context: http://gambas.8142.n7.nabble.com/Gridview-cell-

Re: [Gambas-user] Gridview cell coordinates

2015-01-03 Thread bill-lancaster
Thanks for the several ideas. The example from Ru works except when the user scrolls down, then the balloon is placed well below the gridview control because the cell position has moved relative to the control. Using the GridView[Row, Column].EnsureVisible() has the same problem. BTW the control

Re: [Gambas-user] Gridview cell coordinates

2015-01-03 Thread bill-lancaster
Sorry about this, I thought I'd tried this already - it works fine Public Sub GridView1_MouseDown() Balloon.Info(GridView1[GridView1.Row, GridView1.Column].Text, GridView1, Mouse.X, Mouse.Y) End -- View this message in context: http://gambas.8142.n7.nabble.com/Gridview-cell-coordinates-tp

[Gambas-user] How to check a number of textboxes for data

2015-01-31 Thread bill-lancaster
This must be simple but I can't see it! I have a 5 textboxes on a form and wish to ensure that they all contain data before creating a new record in a database. By setting them all with Tag ="Data" the following code finds the controls. Dim c As Control For Each c In Me.Controls If

Re: [Gambas-user] How to check a number of textboxes for data

2015-01-31 Thread bill-lancaster
Thanks Jussi - it works fine -- View this message in context: http://gambas.8142.n7.nabble.com/How-to-check-a-number-of-textboxes-for-data-tp50440p50443.html Sent from the gambas-user mailing list archive at Nabble.com. --

[Gambas-user] Problem with OPTIONAL method declaration

2015-02-04 Thread bill-lancaster
I have a form with:- Public Sub _new(Optional iNr As Integer) iStatementNr = iNr End When the form is opened with:- Dim hForm As FFormName hForm = New FFormName1019) hForm.ShowModal I get this error message - "Type mismatch: wanted control, got integer instead" Wheras just:-

Re: [Gambas-user] Problem with OPTIONAL method declaration

2015-02-05 Thread bill-lancaster
Thank you both - I'm learning! -- View this message in context: http://gambas.8142.n7.nabble.com/Problem-with-OPTIONAL-method-declaration-tp50515p50541.html Sent from the gambas-user mailing list archive at Nabble.com. ---

[Gambas-user] Custom library function returns wrong value

2015-02-05 Thread bill-lancaster
I have a Procedure in MyLib to convert a 'money' string to integer value. Static Public Procedure StrMoneyToInt(sVal As String) As Integer Dim f As Float f = Val(sVal) Return f * 100 End Some values are incorrectly returned. For example:- This code calls the procedure Dim sMoney As S

Re: [Gambas-user] Custom library function returns wrong value

2015-02-05 Thread bill-lancaster
Thanks Fabien, Yes, I have done that and the problem is fixed. It was interesting that the same function in different locations can produce different answers. I suppose that is the risk with float values. Bill -- View this message in context: http://gambas.8142.n7.nabble.com/Custom-library-fun

[Gambas-user] Change value shown in Tray Icon

2015-03-06 Thread bill-lancaster
Hello, I wish to display a number (say 1 to 20) in a tray icon. I can generate an icon sized .png file with with the value in it but the displayed icon does not show the changed value. Is is possible to do this? If so, what would be the best way to do it? Thanks -- View this message in context

Re: [Gambas-user] Change value shown in Tray Icon

2015-03-10 Thread bill-lancaster
Thanks Benoît, Please see attached. a10-0.gz -- View this message in context: http://gambas.8142.n7.nabble.com/Change-value-shown-in-Tray-Icon-tp50812p50866.html Sent from the gambas-user mailing list archive at Nabble.com.

Re: [Gambas-user] Change value shown in Tray Icon

2015-03-12 Thread bill-lancaster
My mistake was to use a .png file instead of an image value. It's working fine now Thanks -- View this message in context: http://gambas.8142.n7.nabble.com/Change-value-shown-in-Tray-Icon-tp50812p50870.html Sent from the gambas-user mailing list archive at Nabble.com. -

[Gambas-user] Entry value for gambas project

2015-04-21 Thread bill-lancaster
I want to start a Gambas programme from another Gambas programme. What would be the best way to pass a value to the programme? At the moment I write the value to a file from the first programme and read it in the second one. then open the ne prog with:- Exec [User.Home &/ "GambasFolder/GambasE

Re: [Gambas-user] Entry value for gambas project

2015-04-21 Thread bill-lancaster
Thank you guys - it's just what I was looking for Bill -- View this message in context: http://gambas.8142.n7.nabble.com/Entry-value-for-gambas-project-tp51346p51352.html Sent from the gambas-user mailing list archive at Nabble.com. -

[Gambas-user] Playing dv video files

2015-06-06 Thread bill-lancaster
This code works:- hProc = Exec ["mplayer", "-fps", 25, "-wid", dwgMoviePlayer.Handle, User.Home &/ "aa.dv"] The dv file plays in the drawing area. But it doesn't work when adding 'For Read Write As "Process"' to the line. Any ideas would be welcome -- View this message in context: http://gamba

Re: [Gambas-user] Playing dv video files

2015-06-06 Thread bill-lancaster
You're right Tobi, I need to look into the many settings for mplayer. It might be connected with the -wid parameter Bill -- View this message in context: http://gambas.8142.n7.nabble.com/Playing-dv-video-files-tp51701p51703.html Sent from the gambas-user mailing list archive at Nabble.com. -

[Gambas-user] Fw: new message

2015-11-18 Thread bill-lancaster
Hey! New message, please read bill-lancas...@lineone.net --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus -- _

[Gambas-user] IDE - a stupid question

2015-12-16 Thread bill-lancaster
This is embarrassing! In the Project Properties panel I had Control Properties/Hierarchy, a Help Panel and below that a panel with all the controls available. I accidentally hit a key combination that caused the controls panel to disappear. How can I get it back? -- View this message in context

Re: [Gambas-user] IDE - a stupid question

2015-12-16 Thread bill-lancaster
Ah! Yes, F4 does control the whole panel but the lower part (where all the controls are) can be made to disappear (actually made very small) by dragging the border. This I must have done with some clumsy mouse movement. Thanks for all your help. -- View this message in context: http://gambas.8

[SPAM] ☠ amazing!

2016-06-01 Thread bill-lancaster
Hey, You won't believe what I've just read, this is so amazing, read more at Good wishes, bill-lancas...@lineone.net -- What NetFlow Analyzer can do for you? Monitors

[Gambas-user] Message Box Already Displayed

2013-08-09 Thread bill-lancaster
In a fairly simple programme I get this error when only one message box is displayed Is there a known cause for this? -- View this message in context: http://gambas.8142.n7.nabble.com/Message-Box-Already-Displayed-tp42758.html Sent from the gambas-user mailing list archive at Nabble.com.

[Gambas-user] Message Box Already Displayed

2013-08-09 Thread bill-lancaster
Thanks Tobi Yes, the problem was assocaited with an event. Bill -- View this message in context: http://gambas.8142.n7.nabble.com/Message-Box-Already-Displayed-tp42758p42767.html Sent from the gambas-user mailing list archive at Nabble.com. ---

[Gambas-user] mysql seach string contains single quote

2013-08-10 Thread bill-lancaster
Have seen a couple of posts that refer to this but can't quite understand the answer I have a database which conntains a string 'Queen's Head' so hResult = hConn.Exec("SELECT contacts.* FROM contacts WHERE Title = 'Queen's Head'") produces an error. How best to solve this? -- View this

[Gambas-user] mysql seach string contains single quote

2013-08-10 Thread bill-lancaster
Johny, that's great. I spent more than an hour this morning on this. Thank you very much -- View this message in context: http://gambas.8142.n7.nabble.com/mysql-seach-string-contains-single-quote-tp42768p42772.html Sent from the gambas-user mailing list archive at Nabble.com.

[Gambas-user] Gambas in background

2013-09-08 Thread bill-lancaster
In April 2010 I asked this question. Is it possible to run a Gambas programme with only a trayicon showing? Caveat posted an excellant example which worked for me at the time. http://gambas.8142.n7.nabble.com/Gambas-in-background-td30383.html#a30384 Have just tried to re-create it and can't get

[Gambas-user] Gambas in background

2013-09-09 Thread bill-lancaster
Thank you Benoit, but the sample programme quits immediatly still. I have only just installed G 3.4.2 so presumably it current. I've never been involved with revision numbers so am embarrassed to say I've no idea if I have revision #5836 -- View this message in context: http://gambas.8142.n

[Gambas-user] POP3 message date & time

2013-09-14 Thread bill-lancaster
Have just started playing with POP3 and can't see a way of retrieving the date/time of a message. Its not part of _Pop3Client_Message. I guess its buried in the message header but -- View this message in context: http://gambas.8142.n7.nabble.com/POP3-message-date-time-tp43243.html Sent fro

[Gambas-user] POP3 email body

2013-09-15 Thread bill-lancaster
I'm struggling with this. For Each oMail In MailClient Print ; oMail.Message.Subject;; oMail.Message.Sender Wait Next This works fine but how to retrieve the body of the message? -- View this message in context: http://gambas.8142.n7.nabble.com/POP3-email-body-tp4324

[Gambas-user] Pop3

2013-09-15 Thread bill-lancaster
Print oMail.Message.Body gives:- (MimePart 0x1f1fad8) ! -- View this message in context: http://gambas.8142.n7.nabble.com/POP3-email-body-tp43248p43250.html Sent from the gambas-user mailing list archive at Nabble.com. ---

[Gambas-user] pop3

2013-09-15 Thread bill-lancaster
Oh!!! I thought I'd tried that and many others - sorry to waste your time. Yes - its fine. -- View this message in context: http://gambas.8142.n7.nabble.com/POP3-email-body-tp43248p43252.html Sent from the gambas-user mailing list archive at Nabble.com. ---

[Gambas-user] Tableview row does not show as selected

2013-09-18 Thread bill-lancaster
gridview 'mode' is set to single but clicking on a row does not highlight the row. gdvIncoming_Click() produces:- gdvIncoming.Row = 6 ( or whatever row was clicked) gdvIncoming.Rows[gdvIncoming.Row].Selected = True also does not hightlight the row. Where am I going wrong? Distribution=Ubuntu 1

[Gambas-user] Tableview row does not show as selected

2013-09-20 Thread bill-lancaster
The solution is to rebuild a fresh project and the problem goes away! -- View this message in context: http://gambas.8142.n7.nabble.com/Tableview-row-does-not-show-as-selected-tp43269p43290.html Sent from the gambas-user mailing list archive at Nabble.com. -

[Gambas-user] pop3client attachment

2013-09-27 Thread bill-lancaster
Some advice on how to extract attachment s woule be appreciated. I have a message (stored at hResultGlobal!MsgWhole) known to contain an attached .pdf hMimeMessage = New MimeMessage(hResultGlobal!MsgWhole) hMimeMessage.Headers["Content-Type"] produces - multipart/mixed; boundary="MI

[Gambas-user] pop3client attachment

2013-09-27 Thread bill-lancaster
Thank you Benoit, -- View this message in context: http://gambas.8142.n7.nabble.com/pop3client-attachment-tp43383p43392.html Sent from the gambas-user mailing list archive at Nabble.com. -- October Webinars: Code for

[Gambas-user] gb.report, help wanted to write a simple report

2013-10-16 Thread bill-lancaster
I would like a simple report, one page, a number of boxes with fixed and variable information. Have tried to manipulate the example programme (which is far more complex than my needs) but can't see how to controll the position of reportlables. Also, in a blank project, a new Report is created, a Re

[Gambas-user] gb.report, help wanted to write a simple report

2013-10-16 Thread bill-lancaster
Thanks for the reply - it helped a bit. I have two reportlables in a ReportBox in a ReportVBox. The text in both labels is showing in preview but the second label is over-writing the first. How would I have the second label display exactly below the first. BTW the first label will have multiple li

[Gambas-user] gb.report, help wanted to write a simple report

2013-10-16 Thread bill-lancaster
Making some progress now, please regard this post as closed. Thanks again. -- View this message in context: http://gambas.8142.n7.nabble.com/gb-report-help-wanted-to-write-a-simple-report-tp43672p43682.html Sent from the gambas-user mailing list archive at Nabble.com. -

[Gambas-user] mime.decode seems to fail with a pdf attachment

2013-10-27 Thread bill-lancaster
I have 3 emails from the same source, each contains a pdf attachment. Two of the decode sucessfully to a pdf file but one has quit a bit of detail missing when compared with the original. Here is some simplified code to show how I'm decoding the email:- MailClient.Open() Wait For E

[Gambas-user] mime.decode seems to fail with a pdf attachment

2013-10-27 Thread bill-lancaster
Thanks Benoît:- wast -- View this message in context: http://gambas.8142.n7.nabble.com/mime-decode-seems-to-fail-with-a-pdf-attachment-tp43877p43887.html Sent from the gambas-user mailing list archive at Nabble.com. --

[Gambas-user] mime.decode seems to fail with a pdf attachment

2013-10-27 Thread bill-lancaster
Benoît, I obtained the email provided to you by 1)forwarding it to another server, one which enable me to save it ti disc. Putting that file through the mime.decode process make a good pdf. It seems that my problems have arisen after downloading the email and saving it to a mysql db ( as type 'blo

[Gambas-user] Problems reading pdf attachment using pop3 client

2013-11-30 Thread bill-lancaster
Using the pop3Client to download emails into a mysql db sometimes attached pdf files are unreadable. Have sent a pdf document to myself, email message = testemail Then, using pop3_client it is saved to the database into a string field usi

[Gambas-user] Problems reading pdf attachment using pop3 client

2013-11-30 Thread bill-lancaster
Some further information. If I download emails containing pdf files using .Message.ToString() and save the email to file then try to decode the attachment with-: Dim hMimeMessage As MimeMessage Dim hMimePart As MimePart Dim sTemp As String Dialog.Title = "Select a text file" If Dialog.O

[Gambas-user] Problems reading pdf attachment using pop3 client

2013-12-09 Thread bill-lancaster
Thank you Benoît - it works fine now! -- View this message in context: http://gambas.8142.n7.nabble.com/Problems-reading-pdf-attachment-using-pop3-client-tp44464p44592.html Sent from the gambas-user mailing list archive at Nabble.com. ---

[Gambas-user] Blob type and segmentation error

2013-12-11 Thread bill-lancaster
I have a mysql table with a blob type field, this seems to cause Segmentation Fault (11) or Aborted(6) crashes. Is this a known problem? (other postings seem to suggest this) Or is there a work-around? -- View this message in context: http://gambas.8142.n7.nabble.com/Blob-type-and-segmentation-

[Gambas-user] Blob type and segmentation error

2013-12-12 Thread bill-lancaster
Thank you Tobias and sorry Benoit. Here is a small programme:- Public hConn As New Connection Public hResult As Result Public Sub _new() With hConn .Type = "MySQL" .Host = "localhost" .Login = "root" .Port = "3306" .Name = "xxx"

[Gambas-user] Blob type and segmentation error

2013-12-12 Thread bill-lancaster
This may be significant, the mysql db was created using MySQL Workbench and field (column) MsgBlob is set as data type LONGBLOB -- View this message in context: http://gambas.8142.n7.nabble.com/Blob-type-and-segmentation-error-tp44631p44642.html Sent from the gambas-user mailing list archive at

[Gambas-user] Blob type and segmentation error

2013-12-12 Thread bill-lancaster
Benoît, BlobTest-0.0.1.tmp.tar.gz and some mysql BackUpOfBlobTest.sql Hope this is OK. -- View this message in context: http://gambas.8142.n7.nabble.c

[Gambas-user] Writing a text file from the contents of a text area

2013-12-14 Thread bill-lancaster
You could try File.Save("~/test.txt", TextArea1.Text) Although this doesn't answer your question about the OPEN statement -- View this message in context: http://gambas.8142.n7.nabble.com/Writing-a-text-file-from-the-contents-of-a-text-area-tp44675p44676.html Sent from the gambas-user mail

[Gambas-user] Anotating a pdf image

2014-01-10 Thread bill-lancaster
I have a number of files in pdf format and I'd like to add some text to the image and save as a pdf file. Is this possible? If so, some hints as to how would be appreciated. Gambas 3.5.1 Kubuntu 13.04 -- View this message in context: http://gambas.8142.n7.nabble.com/Anotating-a-pdf-image-tp451

Re: [Gambas-user] Anotating a pdf image

2014-01-12 Thread bill-lancaster
Thanks for the ideas and encouragement Tobi I've got something working now. -- View this message in context: http://gambas.8142.n7.nabble.com/Anotating-a-pdf-image-tp45108p45140.html Sent from the gambas-user mailing list archive at Nabble.com. -

[Gambas-user] gridview column clicked indicator

2014-02-06 Thread bill-lancaster
I thought I had seen an added feature to gridview where the ColumnClick event results in a small indicator in the column header but can't find it now. Anyway, such a feature would be helpful to show which column in a table had been sorted (and also if 'up' or 'down' sorted). Any ideas? -- View t

Re: [Gambas-user] gridview column clicked indicator

2014-02-06 Thread bill-lancaster
Thanks Jorge, can the indicator be changed to point up as well as down? -- View this message in context: http://gambas.8142.n7.nabble.com/gridview-column-clicked-indicator-tp45567p45570.html Sent from the gambas-user mailing list archive at Nabble.com. -

Re: [Gambas-user] gridview column clicked indicator

2014-02-07 Thread bill-lancaster
Oh! I should pay better attention. Thanks again -- View this message in context: http://gambas.8142.n7.nabble.com/gridview-column-clicked-indicator-tp45567p45583.html Sent from the gambas-user mailing list archive at Nabble.com.

[Gambas-user] FileChooser Filter

2014-02-21 Thread bill-lancaster
I have a list of files including some .jpg. Setting FileChooser1.filter to ["*.jpg;*.jpeg;", "Photo files"] is fine. But can I exclude certain files from the display i.e. those whose name start with "GPR" (GPR0098.jpeg for example)? -- View this message in context: http://gambas.8142.n7.nabble

[Gambas-user] displaying pnm and pdf files

2014-05-23 Thread bill-lancaster
I have a collection of documents in both pdf & pnm formats and wish to view them with the facility to enlarge the image. The gb.pdf is fine for pdf items while drawingarea seems suitable for enlarging pnm items What is the best way of doing this? -- View this message in context: http://gambas.8

Re: [Gambas-user] displaying pnm and pdf files

2014-05-23 Thread bill-lancaster
Thank you Fabien, I now have both pnm & pdf items displayes in a drawing area. Regards -- View this message in context: http://gambas.8142.n7.nabble.com/displaying-pnm-and-pdf-files-tp46649p46652.html Sent from the gambas-user mailing list archive at Nabble.com. --

[Gambas-user] DateChooser time value

2014-05-29 Thread bill-lancaster
A DateChooser control when set mode = time only does not respond to the change event. Public Sub DateChooser3_Change() Print "time";; DateChooser3.Value End prints nothing Is this a bug or am I doing something wrong? -- View this message in context: http://gambas.8142.n7.nabble.com/Da

Re: [Gambas-user] DateChooser time value

2014-05-29 Thread bill-lancaster
Sorry, Should have said I'm using Gambas 3.5.90 running in Kubuntu 13.10 -- View this message in context: http://gambas.8142.n7.nabble.com/DateChooser-time-value-tp46715p46716.html Sent from the gambas-user mailing list archive at Nabble.com. ---

[Gambas-user] Help needed with installing Gambas 3.5.35

2014-06-15 Thread bill-lancaster
This is what I have done so far:- 1 Download latest gambas version 2 In terminal CD to install directory 3 run ./reconf-all 4 run ./configure -C so far everything seems OK 5 run make - two error reported. Hers is the result:- make all-recursive make[1]: Entering directory `/home/bill/GambasFolder

Re: [Gambas-user] Help needed with installing Gambas 3.5.35

2014-06-15 Thread bill-lancaster
Ah! This is a fresh install of Kubuntu 14.04 I don't know anything about g++ but will look into it. Thanks for the reply -- View this message in context: http://gambas.8142.n7.nabble.com/Help-needed-with-installing-Gambas-3-5-35-tp46994p46996.html Sent from the gambas-user mailing list archi

Re: [Gambas-user] Help needed with installing Gambas 3.5.35

2014-06-16 Thread bill-lancaster
Thanks gianluigi Not speaking Italian I wasn't confident in following the instructions in the link - sorry. Thanks also Jesus-21, but still had errors. I found this link:- http://kalaharix.wordpress.com/2012/04/22/installing-gambas-3-on-ubuntu-12-04-lts-precise-pangolin/ It worked fine -- View

[Gambas-user] fit jpg into drawingarea

2014-07-08 Thread bill-lancaster
I thought I'd sorted this a long time ago but need some help. hImage = Image.Load("/home/xxx.jpg") '(the jpg file is a scan of an A4 document) Public Sub DrawingArea1_Draw() Draw.Image(hImage, 0, 0) End Whatever I try I can never fit the jpg image into the drawing area, this is the nearest

Re: [Gambas-user] fit jpg into drawingarea

2014-07-08 Thread bill-lancaster
Thanks, please see attached. -- View this message in context: http://gambas.8142.n7.nabble.com/fit-jpg-into-drawingarea-tp47333p47338.html Sent from the gambas-user mailing list archive at Nabble.com. -- Open source b

Re: [Gambas-user] fit jpg into drawingarea

2014-07-08 Thread bill-lancaster
-- View this message in context: http://gambas.8142.n7.nabble.com/fit-jpg-into-drawingarea-tp47333p47339.html Sent from the gambas-user mailing list archive at Nabble.com. -- Open source business process management su

Re: [Gambas-user] fit jpg into drawingarea

2014-07-08 Thread bill-lancaster
Thanks - please see attached a3-0.gz -- View this message in context: http://gambas.8142.n7.nabble.com/fit-jpg-into-drawingarea-tp47333p47340.html Sent from the gambas-user mailing list archive at Nabble.com.

Re: [Gambas-user] fit jpg into drawingarea

2014-07-08 Thread bill-lancaster
Sorry, I wasn't displaying the whole of the drawingarea! -- View this message in context: http://gambas.8142.n7.nabble.com/fit-jpg-into-drawingarea-tp47333p47343.html Sent from the gambas-user mailing list archive at Nabble.com. -

[Gambas-user] Tableview behaviour

2014-10-04 Thread bill-lancaster
The attached example has a tableview with values in column 0, click on one of those values and it goes into column 1. Alternatively a new value may be entered in column 1. It all works fine but the return key causes unwanted data in column 1. Where am I going wrong? TableviewExample.gz

[Gambas-user] Problem running mplayer from EXEC

2014-10-20 Thread bill-lancaster
this code:- Exec ["mplayer", "/folder/somemusic.mp3"] runs ok, but when trying to capture the mplayer ouput by adding] 'For Read As "Process_Run"', mplayer doesn't run and this message is displayed. in Sub Process_Run_Read() MPlayer 1.1-4.8 (C) 2000-2012 MPlayer Team Terminal type `unknown' i

  1   2   3   >