1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
|
Le TZQuery, propriété SQL
SELECT * FROM T_TrtForce ORDER BY for_score,for_scoexcep
Le TZUpdateSQL
1) DeleteSQL : DELETE FROM T_TrtForce WHERE for_score=:for_score AND
for_scoexcep=:for_scoexcep;
2) InsertSQL : INSERT INTO T_TrtForce
(for_score,for_scoexcep,for_ajutoucher,for_ajudegats,for_poidsauto,
for_chargemax,for_enfoncer,for_enfoncermag,for_barreaux,for_notes) VALUES
(:for_score, :for_scoexcep, :for_ajutoucher, :for_ajudegats, :for_poidsauto ,
:for_chargemax, :for_enfoncer, :for_enfoncermag, :for_barreaux, :for_notes);
3) UpDateSQL : UPDATE T_TrtForce SET for_ajutoucher=:for_ajutoucher,
for_ajudegats=:for_ajudegats, for_poidsauto=:for_poidsauto,
for_chargemax=:for_chargemax, for_enfoncer=:for_enfoncer,
for_enfoncermag=:for_enfoncermag, for_barreaux=:for_barreaux,
for_notes=:for_notes WHERE for_score=:for_score AND
for_scoexcep=:for_scoexcep; |
Partager