I have tried it, even through the wizard (Field Data), and the syntax retrieved is like this
LOAD * FROM_FIELD (Facts, Year)
I have not used max() and min() yet; but I always get following message:
Cannot open file LOAD * FROM_FIELD (Facts, Year)
My target is to pass the min and max into variable in order that I build different qvd over the years
For i = $(v_Min) to $(v_Max); if not isnull(QVDCreateTime('Facts_$(i).qvd')) then Concatenate LOAD * FROM Facts_$(i).QVD (qvd) WHERE NOT(Exists (idSD)); ENDIF STORE * from Facts where OpenYear = '$(i)' INTO Facts_$(i).QVD ; next ;
1st problem: How to get min(Year) and max(Year) into variable
2nd problem: The STORE statement does not seem to allow a WHERE clause. Is it true?
Problem with the 'RESIDENT' statement is that you are re-reading the whole table, and if it is millions of records, you might want to avoid. There is one solution in the blog I have mentioned, and another one using the 'FROM_FIELD' statement. Problem is that I can't find any example on the web.
How do we use it?! I want to see its benefits. Thanks in advance,
Too bad that the 'STORE' statement does not accept any where clause. There are example to split qvd by year, but they don't show us the code to produce those qvd. And it does not make sense that I re-execute my SQL query year by year...
Did you get a solution to your problem using from_field ? I am also stuck in a similar situation where FieldX exists in Table A and FieldX also exists in Table B and both are associated via FieldX. However, I need to find min and max of FieldX only in Table A. Since the size of Table A is very big, it takes a lot of time to scan through all content. Therefore, please share your thoughts if you got a resolution to this problem.