Problem with MSSQL "dummy" table 1

[RobertoMexicali]

Hi everybody, i'm using MSSQL "dummy" tables for certains process, always taking care of close my dummy table

The problem is that sometimes, doesn't free the ram memory, so my pc goes to slow, i have to stop and restart mssql agent.

Any tips to free memory from clarion code? just like free(queue) or something like that?

Thans in advance

 

[ShankarJ]

Hi Roberto,

Which version of Clarion? If you are using C6.3, use the TURBOSQL driver string. Also, I never open/close a Dummy Table every time. I open/close it in the Frame procedure.

If you minimize your application and restore it does the memory get released? If so, nothing to worry about.

Regards

 

[RobertoMexicali]

Thanks ShankarJ, i will follow your suggestions, i'm sure they'll work fine, you always have the right answer, thanks again, regards.

 

[ShankarJ]

Hi Roberto,

If you send me an email to

j s h a n k a r @ e i m . a e

I will send you my SQLQuery Procedure.

Regards