[Gambas-user] DataView Help
gradobag at gradobag.it
Tue Jul 11 14:40:29 CEST 2023
Il 11/07/23 14:31, T Lee Davidson ha scritto:
> On 7/11/23 07:53, Benoit Minisini wrote:
>> Otherwise, you can use the DataView.Find() method to move the view to
>> a specific record from a SQL where clause. It's easy if you know the
>> primary keys of the record you just have created.
> The `students` table has no columns set as unique and the only primary
> key is `students_id` which is not available until after the record is
> To have a high confidence of finding the very record that was just
> saved, you will need a record signature that is as unique as possible.
> The only way I can think to come close to that is to construct a
> 'where' clause using all the available field values (which does not
> include `students_id`), save it to a global variable in the
> DataSource.BeforeSave event handler, and then use it with Find after
Getting the identity of the added student is easy, in the Save Sub just
Dim sSQL As String = "SELECT MAX(students_id) FROM students;"
Dim i As Integer
i = DataSource1.Connection.Exec(sSQL)
Print "STUDENT ID = "; i
I still couldn't select the correct row though, I always end up
selecting the last one
More information about the User