Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a field (Jaar) which, for some apparent reason, seems to be locked. I cannot click on the LB (it's not marked as Readonly). I'm running QV Desktop 11
Here's a shot on the Table tab in the Document properties:
script looks straightforward
LOAD
DUAL(Year(Datum) & '- 0', AutoNumberHash128(Year(Datum) & '- 0')) AS %Financieel_Periode_key,
0
AS Periode,
Year(Datum) AS Jaar,
Year(Datum) & '-Q4' AS [Jaar-kwartaal],
Year(Datum) & '- 0' AS [Jaar-periode],
'Q1' AS [kwartaal],
Makedate(Year(Datum),1,1) AS Datum,
Makedate(Year(Datum),1,1) AS Periode_begin,
YearEnd(Datum) AS Periode_eind;
LOAD
AddYears(Makedate('$(vMin_Jaar)',1,1), IterNo()-1) AS Datum
AutoGenerate(1)
WHILE Date(AddYears(Makedate('$(vMin_Jaar)',1,1), IterNo()-1)) <= '$(vFinancieelPeriode_EindDatum)';
Any idea's?
Dror
right click on tab, select properties, add field, right click field and select Unlock