FORUMS PROFESSIONNELS
WINDEV
,
WEBDEV
et
WINDEV Mobile
Accueil
|
Messages récents
|
Connexion
|
Déconnexion
|
Français
Accueil
→
WINDEV 2024
→
[WD20] HFSQL Update
[WD20] HFSQL Update
Débuté par Curtis, 12 juin 2017 22:41 - 2 réponses
Connectez-vous…
Curtis
#1
Posté le 12 juin 2017 - 22:41
I am using HFSQL C/S files. I have a Payment file and a Receipt file. Payment is linked to Receipt by ReceiptID. How can I write a valid query that matches Payments with Receipts and sets Payment.Amount to the matching Receipt.Total?
UPDATE Payment SET Payment.Amount = (SELECT Receipt.Total FROM Receipt WHERE Payment.ReceiptID = Receipt.ReceiptID) //ERROR : No analysis opened: Receipt file not described. UPDATE Payment SET Payment.Amount= Receipt.Total FROM Payment INNER JOIN Receipt ON Payment.ReceiptID = Receipt.ReceiptID //ERROR : Unexpected word: FROM. UPDATE Payment INNER JOIN Receipt ON Payment.ReceiptID = Receipt.ReceiptID SET Payment.Amount= Receipt.Total //ERROR: Unable to cast data to type of JOIN.AppliedAmount item. UPDATE Payment SET Payment.Amount = (SELECT Receipt.Total FROM Receipt WHERE Receipt.ReceiptID = Payment.ReceiptID) WHERE EXISTS (SELECT * FROM Receipt WHERE Receipt.ReceiptID = Payment.ReceiptID) //ERROR : No analysis opened: Receipt file not described. UPDATE Payment,Receipt SET Payment.Amount = Receipt.Total WHERE Payment.ReceiptID = Receipt.ReceiptID //ERROR: Unable to cast data to type of JOIN.AppliedAmount item.
Signaler
0
0
kingdr
#2
Posté le 12 juin 2017 - 23:15
You should do this as below:
UPDATE Payment JOIN Receipt ON Payment.ReceiptID = Receipt.ReceiptID SET Payment.Amount= Receipt.Total
and it should work with analysis file.
HTH
King
Signaler
0
0
Curtis
#3
Posté le 12 juin 2017 - 23:58
Oops. Payment.Amount was set to text instead of currency. Now it works.
Thanks kingdr.
Signaler
0
0
→ Revenir à WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (précédentes versions)
Français
English
Español
Portuguesa
Fermer cette fenêtre
Type de recherche
Uniquement les sujets
Tous les messages
Période de recherche
Date indifférente
Moins d'une heure
Moins de 24 heures
Moins d'une semaine
Moins d'un mois
Moins d'un an
Annuler
Aperçu de votre message
Ajouter une image
Importer une image depuis une URL
Envoyer une image depuis un fichier de votre disque
Déposez ici un fichier ou cliquez sur "Parcourir..."
ou
Annuler
0%
WLangage
SQL
XML, HTML
JAVA, Javascript
Texte