Board index » delphi » Querys are killing my my memory

Querys are killing my my memory

What do you mean by "Microsoft Client Server"? Paradox is not a database
server so you cannot create a client/server application with Paradox tables
unless you write your own server. What are the error messages you get? What
version of Delphi and the BDE are you using?

--
Bill

 

Re:Querys are killing my my memory


hi,
a have a litlle problem here.

i have an application  that my client uses trough Microsoft Client Server,
but several times when i update my queries the program stops with memory
errors.
is it possible that the queries are to heavy on the memory that client
server allows??

:first query, result with about 100 records
   dModuleVis.sqlAux.sql.Append('SELECT Tabrelvendmed.CodMed, Tabmed.NOME');
   dModuleVis.sqlAux.sql.Append('FROM "tabRelVendMed.DB" Tabrelvendmed');
   dModuleVis.sqlAux.sql.Append('INNER JOIN "Tabmed.DB" Tabmed');
   dModuleVis.sqlAux.sql.Append('ON  (Tabrelvendmed.CodMed =
Tabmed.NUMERO)');
   dModuleVis.sqlAux.sql.Append('WHERE  Tabrelvendmed.CodMan = ''' +
mvVariaveis.gvendedor + '''');
   dModuleVis.sqlAux.sql.Append('ORDER BY Tabmed.NOME');

:second query, result with about 2000 records and growing
   dModuleVis.sqlList.sql.Append('SELECT tabvis.NUMERO,
tabvis.Codigo,tabvis.DATA, tabvis.LOCAL, tabvis.TIPO, tabvis.DELEGADO,
Tabmed.NOME');
   dModuleVis.sqlList.sql.Append('FROM tabvis');
   dModuleVis.sqlList.sql.Append('INNER JOIN "Tabmed.DB" Tabmed');
   dModuleVis.sqlList.sql.Append('ON  (Tabmed.NUMERO = tabvis.NUMERO)');
   dModuleVis.sqlList.sql.Append('WHERE  Tabvis.NUMERO IN (');
   dModuleVis.sqlList.sql.Append('SELECT Tabrelvendmed.CodMed');
   dModuleVis.sqlList.sql.Append('FROM "tabRelVendMed.DB" Tabrelvendmed');
   dModuleVis.sqlList.sql.Append('WHERE  Tabrelvendmed.CodMan = ''' +
mvVariaveis.gvendedor + ''')');
   dModuleVis.sqlList.sql.Append('ORDER BY Tabmed.NOME');

i'm using paradox 7 tables.

thanks in advance.
Pedro Baptista

Re:Querys are killing my my memory


hi,
a have a litlle problem here.

i have an application  that my client uses trough Microsoft Client Server,
but several times when i update my queries the program stops with memory
errors.
is it possible that the queries are to heavy on the memory that client
server allows??

:first query, result with about 100 records
   dModuleVis.sqlAux.sql.Append('SELECT Tabrelvendmed.CodMed, Tabmed.NOME');
   dModuleVis.sqlAux.sql.Append('FROM "tabRelVendMed.DB" Tabrelvendmed');
   dModuleVis.sqlAux.sql.Append('INNER JOIN "Tabmed.DB" Tabmed');
   dModuleVis.sqlAux.sql.Append('ON  (Tabrelvendmed.CodMed =
Tabmed.NUMERO)');
   dModuleVis.sqlAux.sql.Append('WHERE  Tabrelvendmed.CodMan = ''' +
mvVariaveis.gvendedor + '''');
   dModuleVis.sqlAux.sql.Append('ORDER BY Tabmed.NOME');

:second query, result with about 2000 records and growing
   dModuleVis.sqlList.sql.Append('SELECT tabvis.NUMERO,
tabvis.Codigo,tabvis.DATA, tabvis.LOCAL, tabvis.TIPO, tabvis.DELEGADO,
Tabmed.NOME');
   dModuleVis.sqlList.sql.Append('FROM tabvis');
   dModuleVis.sqlList.sql.Append('INNER JOIN "Tabmed.DB" Tabmed');
   dModuleVis.sqlList.sql.Append('ON  (Tabmed.NUMERO = tabvis.NUMERO)');
   dModuleVis.sqlList.sql.Append('WHERE  Tabvis.NUMERO IN (');
   dModuleVis.sqlList.sql.Append('SELECT Tabrelvendmed.CodMed');
   dModuleVis.sqlList.sql.Append('FROM "tabRelVendMed.DB" Tabrelvendmed');
   dModuleVis.sqlList.sql.Append('WHERE  Tabrelvendmed.CodMan = ''' +
mvVariaveis.gvendedor + ''')');
   dModuleVis.sqlList.sql.Append('ORDER BY Tabmed.NOME');

i'm using paradox 7 tables.

thanks in advance.
Pedro Baptista

Other Threads