[Gambas-user] How to write sql query in gambas way

Gianluigi bagonergi at gmail.com
Tue May 10 11:04:06 CEST 2022


Il giorno mar 10 mag 2022 alle ore 05:18 Safiur Rahman <isafiur at gmail.com>
ha scritto:

> Hi
>
> That cannot be the answer. The array can be of variable count and count
> may go to twenty or thirty.
>
>
I thought it was implied, you can do something like this:

Public Sub Button2_Click()

  Dim aRes As New Result[11]

  For i As Integer = 0 To 10
    aRes[i] = conn.Find("tbltest", "flddepartment = &1 ", xCountry[i])
    If aRes[i].Available Then ListBox1.Add(aRes[i]!fldtitle)
  Next

End

Regards
Gianluigi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20220510/fc040762/attachment.htm>


More information about the User mailing list