Information générale
Titre:
There is not enough memory to complete this operation
I receive this error message when executing an SQL statement with a left join using more than 7 fields on each side of my == union. Here is my SQl expression:
SELECT D_TX,DATE_HEURE,tmpfol.CLEPERS,tmpfol.INST,tmpfol.TRANSIT,tmpfol.FOLIO,tmpfol.CD_SERV,tmpfol.NO_SERV,tmpfol.DTDETECTIO,tmpfol.CDDETECTIO FROM tmpfol LEFT JOIN ResDetectionTnmApp B ON tmpfol.clepers+tmpfol.inst+tmpfol.transit+tmpfol.folio+tmpfol.cd_serv+tmpfol.no_serv+dtos(tmpfol.dtDetectio)+tmpfol.cddetectio ==B.clepers+B.inst+B.transit+B.folio+B.cd_serv+B.no_serv+dtos(B.dtDetectio)+B.cddetectio WHERE .T. INTO TABLE c:\systoo\TEMP\52114621
I found that if I remove one of the field (any one) on each side, my SQl statement works fine. But from the moment I use more than 7 fields on each side I get the error. WHY??? Is there any maximum number of field that we can use in a join statement???
The table I use have about 10 record each, and the amount of memory available on my system is large enough (24 MB Ram available).
Thanks,
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement