soumya093
15th July 2014, 11:40
Hello everyone I had created a maintain session in Baan IV where I am maintaining the yearly budget. So the problem I am facing is I am maintaining the records date wise i.e. the current date should be shown in the form,but when I am running the session it is showing the current although its maintained the day before ..
regards
Soumya
bhushanchanda
15th July 2014, 13:34
Hi,
If you keep the date as form field it will always show you the current date as its not storing the date anywhere. Is it a table field? And what have you written in your script? Snapshot and code snippet will help.
soumya093
16th July 2014, 10:45
no sir its a table field and the code is
field.tdcus300.bdat:
before.display:
selsct tdcus300.*
from tdcus300
where tdcus300._index1 = {:tdcus300.year,:tdcus300.ctyp}
selectdo
dislplay("tdcus300.bdat")
endselect
bhushanchanda
16th July 2014, 12:28
Hi,
Not sure what are you trying to do. If your main table for this maintain session is tdcus300 then you dont need to write anything in the field sections. If you just want that when a new record is created you want current date as tdcus300.bdat then just use main.table.io: section and assign current date in before.write: section.
Anyway, if your main table is something else then try using:-
field.tdcus300.bdat:
before.field:
selsct tdcus300.*
from tdcus300
where tdcus300._index1 = {:tdcus300.year,:tdcus300.ctyp}
selectdo
dislplay("tdcus300.bdat")
endselect