Access violation with query builder

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
GT73
User
Posts: 415

Access violation with query builder

Post by GT73 »

I only take the lines that count number of lines id> 1
╔═══════════╗
â•‘ MyTable â•‘
╠═════╦═════╣
â•‘ idA â•‘ idB â•‘
╠═════╬═════╣
â•‘ 23 â•‘ 6 â•‘
╠═════╬═════╣
â•‘ 23 â•‘ 7 â•‘
╠═════╬═════╣
â•‘ 5 â•‘ 5 â•‘
╠═════╬═════╣
â•‘ 4 â•‘ 4 â•‘
╠═════╬═════╣
â•‘ 3 â•‘ 3 â•‘
╠═════╬═════╣
â•‘ 2 â•‘ 2 â•‘
╠═════╬═════╣
â•‘ 1 â•‘ 1 â•‘
╠═════╬═════╣
â•‘ 1 â•‘ 8 â•‘
╚═════╩═════╝

╔═══════════╗
â•‘ Results â•‘
╠═════╦═════╣
â•‘ idA â•‘ idB â•‘
╠═════╬═════╣
â•‘ 1 â•‘ 1 â•‘
╠═════╬═════╣
â•‘ 1 â•‘ 8 â•‘
╠═════╬═════╣
â•‘ 23 â•‘ 6 â•‘
╠═════╬═════╣
â•‘ 23 â•‘ 7 â•‘
╚═════╩═════╝

SELECT clienti.Attivo AS Attivo,
loyaltycard.idCliente AS idCliente,
clienti.Nome AS Nome,
clienti.Cognome AS Cognome,
loyaltycard.idLoyaltyCard AS idLoyaltyCard,
FROM loyaltycard
JOIN clienti ON clienti.idCliente = loyaltycard.idCliente
WHERE loyaltycard.idCliente IN (SELECT loyaltycard.idCliente
FROM loyaltycard GROUP BY loyaltycard.idCliente HAVING
Count(loyaltycard.idCliente) > 1)
ORDER BY idCliente,
DataDisabled DESC

the query in alter view (Execute) works well and reports the correct results. When I open it again it gives me this error:
Access violation at address 00E34525 in module hphpmaker.exe. Read of address 00000008


arbei
User
Posts: 9405

Post by arbei »

You better post the table schema of the client and loyaltycard tables so other users can create the tables and try the SQL.


Post Reply