Re: Undefined SQLite error

[Philippe Valarcher <philippe.valarcher@xxxxxxx>]

Le dimanche 27 avril 2025 à 20:07 +0200, Benoît Minisini a écrit :
> Le 27/04/2025 à 09:56, Philippe Valarcher a écrit :
> > Here is somme images you asked for :
> > 
> > 
> > The prcedure that generate the error is DecoupeCalc in the form 
> > FPavillon.I recall that with gb.db it doesn(t do that error and it
> > is in 
> > the IDE and with the program compiled either.
> > Best regards.
> > 
> 
> So the specific sqlite request « PRAGMA table-info('maTable') »
> fails, 
> which should never happens.
> 
> Does your 'maTable' table have something special? How did you create
> it?
> 
No, it has nothing special, it is create in the code, like this :
---------------------------------------------------------------------
Private Sub creatTable() 'création de la base de données
des planches

If Not db.Current.Opened Then
db.Current.Open
Endif

db.Current.Begin

If Not MConn.hConn.Tables.Exist("maTable") Then
 myTable = MConn.hConn.Tables.Add("maTable")
 myTable.Fields.Add("id", db.serial)
 myTable.Fields.Add("Planche", db.Integer, 0)
 myTable.Fields.Add("Surf", db.Float, 0)
 myTable.Fields.Add("Diametre", db.Float, 0)
 myTable.Fields.Add("Rayon", db.Float, 0)
 myTable.Fields.Add("Distance", db.Float, 0)
 myTable.Fields.Add("Largeur", db.Float, 0)
 myTable.Fields.Add("Hauteur", db.Float, 0)
 myTable.Fields.Add("pasL", db.Float, 0)
 myTable.Fields.Add("pasH", db.Float, 0)
 myTable.Fields.Add("longL", db.Float, 0)
 myTable.Fields.Add("longH", db.Float, 0)
 myTable.PrimaryKey = ["id"]
 myTable.Update()
Else
 MConn.hConn.Delete("maTable")
Endif

db.Current.Commit

End
---------------------------------------------------------------------
Thank you.
Regards.

-- 
Cordialement
Philippe Valarcher <philippe.valarcher@xxxxxxx>