openledger-developer

[Openledger-developer] High wait time on test3.pl

[Ang T. C. <at...@ew...>]

hi
Test3.pl has a long wait time while retrieve all data for parts class. i
hope someone can help me to improve this
thanks

from
Ang TUn Chek

Re: [Openledger-developer] High wait time on test3.pl

[udono <ud...@gm...>]

Hello Ang,

Ang Tun Chek schrieb:
> hi
> Test3.pl has a long wait time while retrieve all data for parts class. i
> hope someone can help me to improve this
> thanks

I would like to test, but in the cvs isn't a file named test3.pl...
test2.pl works with some errors, i try to follow...

Greetings Udo
-- 
Udo S.

Re: [Openledger-developer] High wait time on test3.pl

[udono <ud...@gm...>]

Hello Ang,

udono schrieb:
[...]
> test2.pl works with some errors, i try to follow...
test2 works good with german Chart, but there are some minor errors 
in the query in line 850...
I quoted the Values this way, and it worked:

       $query = qq|INSERT INTO  partscustomer (parts_id, customer_id,
                   pricegroup_id, pricebreak, sellprice, curr,
                   validfrom, validto)
                 VALUES ('$self->{id}', '$vc->{customer}->{id}',
                   '$vc->{pricegroup_id}', '$vc->{"pricebreak"}',
                   '$vc->{"customerprice"}', '$vc->{"customercurr"}', |
                   .$user->dbquote($self->{"validfrom"}, 
"SQL_DATE").qq|, |
                   .$user->dbquote($self->{"validto"}, 
"SQL_DATE").qq|)|;

---------8<---------

Greetings Udo