[Gambas-user] DataSource

[Fabien Bodard]

>
>
> Hi Fabien,
>
> I have added in the last commit the Find() and FindNext() method to the
> DataSource class. They should do what your want.
>
> Thank you 😊
>
> I first thought it was impossible, but I didn't know the ROW_NUMBER()
> SQL function, that hopefully is present in Sqlite, MySQL and PostgreSQL.
> But beware, only since version 8 in MySQL.
>
> You use them that way:
>
> iIndex = DataSource1.Find("reference = &1", reference)
>
> Find() returns the index of the first matching row.
>

FindNext() returns the index of the first matching row next to the
> current DataSource position.
>
> Anyway, it will be faster to not use DataSource for that, and use direct
> requests to the database.
>

Not use for what thing ? Editing or finding the row ?

Regards,
>
> --
> Benoît Minisini
>
> ----[ http://gambaswiki.org/wiki/doc/netiquette ]----,x
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20201124/8ec8d2d8/attachment.htm>