>>> 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>