Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Request Problem

Status
Not open for further replies.

Philbzh

Programmer
Jun 21, 2001
2
GB
Hi,
I converted my access database in MySQL and the conversion is valid because i can do some basic requests. But I have a request that i can't execute on MySQL, i lost the server connection and the server go down when i execute it. The request is correct (i think!) because i can execute it on the access database with any problem.
Someone could be help me, please. I don't know if MySQL have limited size on the SELECT request, or other thing.
If someone have had the same problem...

The request is :
SELECT DISTINCT C.LIB_CONTRAINTE,C.CODE_CONTRAINTE
FROM T_PROBLEME AS Po, T_CONTRAINTE AS C,
T_LNK_PROBLCONTR AS bC, T_LNK_PROBREFERENCE AS PbR,
T_REFERENCE AS R,
T_NATURE AS N,T_ALPHA AS A
WHERE A.LIB_ALPHA LIKE 'JD' AND A.ID_ALPHA=Po.ID_ALPHA
AND C.ID_CONTRAINTE=PbC.ID_CONTRAINTE
AND Po.ID_PROBLEME=PbC.ID_PROBLEME
AND Po.ID_PROBLEME=PbR.ID_PROBLEME
AND PbR.ID_REFERENCE=R.ID_REFERENCE
AND R.ID_NATURE=N.ID_NATURE
ORDER BY C.LIB_CONTRAINTE,C.CODE_CONTRAINTE;

Thanks.
Phil.
 
I complete my precedent message, i have MySQL version 3.23.39 and i use mysql-opt, i work under Win ME . When i run the resquest i have a pop-up with title 'DBUG' and the text : 'test signal' with a OK button. When i click on, my daemon crashes.
Help !
Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top