Hi Olaf Thanks for taking the time to help this lost soul.
Sory for not documenting further is not final.
Can you tell me how to index the cursors?
Yes I do group by from vertion 8 I use a command
"SET ENGINEBEHAVIOR 70"
1. edwkey = Identify the client
ssn = Social security...
The reason I'm messing with Arrays and Cursors is because it takes tree days for the code to run and I was looking for a way to better the performance of the code.
The purpose of the code is to find out since when the client is in business with the company.
The catch is that during the life of...
Thanks Guys I redid the code using cursors but didn't go any faster the code takes like tree days to run and I need it to work under a day.
In general I need to evaluate close to 370K Clients/Records that I have in one table
Another table has all 370K Clients with all the account under thous...
I'm receiving an error message "Array dimensions are invalid"
This is how I build my fist Array:
PUBLIC ARRAY A1(1,1)
PUBLIC ARRAY A3(1,1)
USE "F:\Jobs\Recurrentes\Interno\Client Since\Tablas\Import.dbf" ALIAS Temp
SELECT * FROM Temp GROUP BY acct_num order BY edwkey,open_dt1 ASC;
INTO ARRAY...
Acopy makes an exact duplicate of the first array. but i need to make a selection from the first array before coping it to the second array.
Is their any whay to add a condition to select spesific data?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.