Re: [Gambas-user] MySQL and general data issues

2010-03-02 Thread Keith Clark
On Tue, 2010-03-02 at 22:44 +0100, M. Cs. wrote: > I'm using sqlite, and I think the querry should look like: > DIM answer AS Result > DIM querry As String > ... > > querry="SELECT.;" > answer=YourConnection.Exec(querry) > FOR EACH answer > > do what you want..

Re: [Gambas-user] MySQL and general data issues

2010-03-02 Thread M. Cs.
I'm using sqlite, and I think the querry should look like: DIM answer AS Result DIM querry As String ... querry="SELECT.;" answer=YourConnection.Exec(querry) FOR EACH answer do what you want. NEXT ---

Re: [Gambas-user] MySQL and general data issues

2010-03-02 Thread Keith Clark
On Mon, 2010-03-01 at 23:36 +0100, Charlie Reinl wrote: > Am Montag, den 01.03.2010, 16:22 -0500 schrieb Keith Clark: > > I am trying to access some data using the documentation "A Beginner's > > Guide to Gambas" and I've gotten this far: > > > > PUBLIC SUB SearchButton_Click() > > > > DIM $Que

Re: [Gambas-user] MySQL and general data issues

2010-03-01 Thread Keith Clark
On Mon, 2010-03-01 at 23:36 +0100, Charlie Reinl wrote: > Am Montag, den 01.03.2010, 16:22 -0500 schrieb Keith Clark: > > I am trying to access some data using the documentation "A Beginner's > > Guide to Gambas" and I've gotten this far: > > > > PUBLIC SUB SearchButton_Click() > > > > DIM $Que

Re: [Gambas-user] MySQL and general data issues

2010-03-01 Thread Charlie Reinl
Am Montag, den 01.03.2010, 16:22 -0500 schrieb Keith Clark: > I am trying to access some data using the documentation "A Beginner's > Guide to Gambas" and I've gotten this far: > > PUBLIC SUB SearchButton_Click() > > DIM $Query AS String > DIM $Result AS Result > DIM iIndex AS Integer > D

[Gambas-user] MySQL and general data issues

2010-03-01 Thread Keith Clark
I am trying to access some data using the documentation "A Beginner's Guide to Gambas" and I've gotten this far: PUBLIC SUB SearchButton_Click() DIM $Query AS String DIM $Result AS Result DIM iIndex AS Integer DIM hField AS ResultField DatabaseConnection.Connect() $Query = "sele