gerd_renz3
VIP Member
Hi List,
I have been asked to create row security for a date-type column on F43214 and it does not seem to work.
When I type in the ranges in P00950 I have to type the date ranges in dd/mm/yy format. The values are stored in this same format in F00950. When I run the application the SQL shows some funny characters:
where (PRTRDJ BETWEEN yyy and zzz )
(I replaced the funny characters with yyy to be able to post here).
I then changed the date ranges to julian format using SQL on F00950. Now the JDEDEBUG looks like
where ( PRDGL BETWEEN AND OR PRDGL BETWEEN AND ) .It shows blanks instead of funny characters.
Am I missing something? Am I trying to do something impossible? Has anyone ever put row security on a date field?
Thanks for any help, Gerd
E8.93, AS400, WTS
I have been asked to create row security for a date-type column on F43214 and it does not seem to work.
When I type in the ranges in P00950 I have to type the date ranges in dd/mm/yy format. The values are stored in this same format in F00950. When I run the application the SQL shows some funny characters:
where (PRTRDJ BETWEEN yyy and zzz )
(I replaced the funny characters with yyy to be able to post here).
I then changed the date ranges to julian format using SQL on F00950. Now the JDEDEBUG looks like
where ( PRDGL BETWEEN AND OR PRDGL BETWEEN AND ) .It shows blanks instead of funny characters.
Am I missing something? Am I trying to do something impossible? Has anyone ever put row security on a date field?
Thanks for any help, Gerd
E8.93, AS400, WTS
