Gambas ONE

Example:-
I have a library (LibDb) that deals with database functions. Some of those functions need to call functions held in another library(LibXX).

Incorporating LibXX in LibDb causes an error :- Any advice would be welcome

I realised that a more positive indication that the value entered wasn't acceptable so a message was really called for so:- Public Sub gdvInvoices_Click() bSet = True gdvInvoices.Edit End Public Sub gdvInvoices_Save(Row As Integer, Column As Integer, Value As String) If Value = "not acceptable&...

Thanks, that is a neat work around.

I want to test the value being entered in a cell and if the test fails, then the value isn't entered. Trouble is that the warning message appears twice ' Gambas class file Public Sub Form_Open() tbvInvoices.Columns.Count = 3 tbvInvoices.Rows.Count = 5 End Public Sub tbvInvoices_Click() tbvInvoices.E...

Thank you so much.
I thought that was where I'd started - must have been mistaken
Thanks again

I hope it's not a problem posting a mysql issue here! I have a table 'transactions' with a number of fields including 'TransRef and TransDate). I want to select 'TransRef' as DISTINCT and ORDER BY TransDate. I've read a number of learned items on this but can't solve the problem. For example, the ta...

Thanks for all the suggestions - am happily printing and modifying drawing area

I have a programme that draws a chart in a drawingarea using paint.begin etc. How can I clear the drawingarea for a different form of chart. drawingarea.clear doesn't do it and I can't see a paint method. Also,is there a convenient way to print the drawingarea image to a printer? Any advice would be...

Ah yes!
The problem was with a record in the db that contained a single (').
Using Gambas Replace function in the SQL statement solves the problem.

SELECT * FROM gCal WHERE EventText = '" & Replace(sNew, "'", "''") & "'"

Thanks for the help.

Exactly!
Here is the offending string:-

John Lancaster's birthday