JD Edwards EnterpriseOne - Database Insert
17 October 2008
2 Comments
In the JD Edwards EnterpriseOne Report Writer… When doing and insert into a table containing the Field “FY”, which of the following values below would result in a successful update?
a) 2008
b) 8
c) 08
d) none of the above
JD Edwards EnterpriseOne Reporting Interview Questions are the property of jdeforum.com.
The truth is that I don’t remember… I came up with these questions as I was actually writing code, and like everything - Use it or loose it. If anyone knows the correct answer please write a comment.
I ve been reading along for a while now. I just wanted to drop you a comment to say keep up the good work.
Joan
Tips Beauty
The answer is b. The FY data item is defined as a numeric field and it will only contain the year value; not the century. Therefore 2008 is incorrect, and while you can pass 08 as a number, a MS SQL database table will store the value as 8.
Leave your response!