[Gambas-user] DataSource

[T Lee Davidson]

On 11/22/20 4:59 PM, Fabien Bodard wrote:
> I need help..
> 
> I want my datasource reach a given line given one field and not a line
> index... how can I achieve that quickly ... Actually I'm doing it by a
> Force and stupid way.
> 
> 
> Static Private reference As String
> 
> Public Sub Run(Value As String)
> 
>    reference = Value
>    FClientEdit.Showmodal
> 
> End
> 
> Public Sub Form_Open()
> 
>    Dim i As Integer
>    Dim aGeo As String[]
> 
> '----- HERE HOW TO FIND LINE :-/ --------------
>    DataSource1.MoveFirst
>    For i = 0 To DataSource1.Count - 1
>      If DataSource1["reference"] = reference Then Break
>      DataSource1.MoveNext
>    Next
> '-------------------------------------------

DataSource1.Table = "SELECT * FROM `table` where `reference`='reference'"
?


-- 
Lee