[Gambas-user] DataView Help

[Gianluigi]

Il 12/07/23 01:14, T Lee Davidson ha scritto:
> On 7/11/23 08:40, Gianluigi wrote:
>> I still couldn't select the correct row though, I always end up 
>> selecting the last one
>
> It appears that DataView.Find assumes the sort order of the view is by 
> `students_id`. But, it isn't always. In fact, when the application 
> launches, the view is sorted by `surname` descending.
>
> The last inserted record is last in the database table. So, 
> DataView.Find sets the current row to the last record in the view even 
> if it is not sorted by `students_id`.
>
> It appears to me to be a bug. But, I don't know how DataView.Find 
> could determine the sort order of whichever column.
>
>
HI,

Yes, and so does DataSource.Find which, the wiki states, "Fin the first 
row matching the specified filter and return its index."

Benoit is there any chance of getting the position, if I try to enter in 
Find a second parameter that I get correctly from BeforeSave 
("students_id=&1 AND surname=&2, i, $sLastSurname"), I get an error of 
Query failed: near "&": syntax error.
Does the query only work on the key?

Regards
Gianluigi