PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV Mobile 2024 → [WM23] Issue with a Query
[WM23] Issue with a Query
Débuté par ARV, 09 mar. 2019 15:42 - Aucune réponse
#1
Membre enregistré
498 messages
Popularité : +8 (8 votes)
Posté le 09 mars 2019 - 15:42
Hi all

I have an issue with a query for a really long time and I still don't know why.

My query doesn't have that difficult thing to know about, and it's really simple but on my app on Android always have this error I'm really mad about it because I don't undestand what it means.

heres my query:

SELECT
TableA.ID AS ID,
TableA.Name as Name,
FROM
TableA
LEFT JOIN
TableB
ON
TableA.ID = TableB.IDLoc
WHERE
TableB.IDLoc IS NULL


and here's it's the error this launch me:
The HFSQL security mechanism was triggered while browsing the 'QRY_TESTERROR' file on 'ID' item'.
An error occurred while filling the QRY_TESTERROR view or query:
Error returned by Server IP server:
No browse started for ID item on TableB file.


please help!

--
Best Regards
ARV
Message modifié, 09 mars 2019 - 15:43
→ Revenir à WINDEV Mobile 2024