[Gambas-user] DataView Help

Christof Thalhofer chrisml at deganius.de
Tue Jul 11 15:38:30 CEST 2023


Am 11.07.23 um 14:40 schrieb Gianluigi:

> Getting the identity of the added student is easy, in the Save Sub just
> type:
> 
>     Dim sSQL As String = "SELECT MAX(students_id) FROM students;"
>     Dim i As Integer
> 
>     DataSource1.Save
>     i = DataSource1.Connection.Exec(sSQL)[0]
>     Print "STUDENT ID = "; i
> 
> I still couldn't select the correct row though, I always end up
> selecting the last one

This is not good, as soon as not only one person can insert data, it 
will be unreliable.

Alles Gute

Christof Thalhofer

-- 
Dies ist keine Signatur

-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_signature
Type: application/pgp-signature
Size: 840 bytes
Desc: OpenPGP digital signature
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20230711/a5231aea/attachment.sig>


More information about the User mailing list