xlate on dates (OpenInsight Specific)
At 16 FEB 1999 07:07:02AM Jacob Ignatius wrote:
I had a line in a stored procedure that performed an xlate on a date field in a table. The field was of type DATE.
The xlate did not return the date value. It returned null instead.
Reading the record using 'read' and then referencing the field did the trick.
Why is this so?
At 16 FEB 1999 10:48AM amcauley@sprezzatura.com onmouseover=window.status=why not click here to send me email?;return(true)", [url=http://www.sprezzatura.com" onMouseOver=window.status=Why not click here to visit our web site?';return(true)]Sprezzatura Ltd[/url] wrote:
Because you did something wrong in the
XLATE, used the wrong key, a lowercase field name or something. All XLATE does is a read (albeit a READO opcode rather than a READ) so there should be no difference.
amcauley@sprezzatura.com
World Leaders in all things RevSoft
At 16 FEB 1999 11:02AM Jacob Ignatius wrote:
I checked and re-checked but there was nothing wrong with my xlate statement.
I tried with the field name (spelt correctly) and the field number but I got the same result - a null value.
At 16 FEB 1999 11:12AM dsig@teleport.com wrote:
Jacob,
Could you post the line of code here..
I would guess that you are using a variable for ID .. what is the value that the id is passing? Have you displayed it?
dsig@teleport.com onmouseover=window.status=you have seen the rest .. now try the best!;return(true)"
David Tod Sigafoos ~ SigSolutions
voice: 503-639-8080
At 16 FEB 1999 11:13AM dsig@teleport.com wrote:
Jacob,
Could you post the line of code here..
I would guess that you are using a variable for ID .. what is the value that the id is passing? Have you displayed it?
dsig@teleport.com onmouseover=window.status=you have seen the rest .. now try the best!;return(true)"
David Tod Sigafoos ~ SigSolutions
voice: 503-639-8080
At 16 FEB 1999 11:16AM Jacob Ignatius wrote:
I'm very sorry. On closer scrutiny, it appears to be my fault completely. I got the key and field mixed up in the xlate.