[Gambas-user] databases

[David Silverwood]

Hi All
I came across a very strange occurrence, not sure what the problem may be.I have a couple of database interfaces (sqlite3), however (and this is only the second time this has occurred) I found that when creating tables gb sometimes kicks out 'gbSerial' as in the following code:
    hTable.Fields.Add("REF", gb.Serial)    hTable.Fields.Add("DATE", gb.Date)    hTable.Fields.Add("INVOICE", gb.String)    hTable.Fields.Add("QUANTITY", gb.Float)    hTable.Fields.Add("DESCRIPTION", gb.String)    hTable.Fields.Add("PRICE", gb.Float)    hTable.PrimaryKey = ["REF"]    hTable.Update
I can only assume I am missing a library somewhere, however, when I checked the components on the other interfaces, they were all the same... so I have two interfaces that don't work and the rest do... (not in the same program). Can someone shed some light on this, please? What exactly have I done wrong on the 2 'problem children'?PS. I used the gb.db and gb.db.form components
Thanks
David
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20211014/2bcfd7fb/attachment.htm>