Gambas ONE

It's a long time since I did this:- sNew is a string variable that may contain a "'" character. hResult = hConn.Exec("SELECT * FROM gCal WHERE EventText = &1", sNew) But I always get a result with no records. No doubt I'm missing something obvious but any ideas would be welcome

Thanks Cogier - I'll do my best
Bill

This may seem strange, but is this the current forum for Gambas?
I've been away from the old nabble forum (which was always very active) for sometime and am surprised to see little activity.
Thanks

Thanks for the reply. I have a library which that performs a number of mysql routines. A connection to the database is required before the routines will run. Have tried:- Public Sub _new() Initialise() End But nothing happens. In the Gambas wiki reference is made to automatically invoking a startup ...

Does anyone know if this can be done?
At the moment I have to remember to call a startup procedure from my project each time.
GB 3.9.2