🚀 go-pugleaf

On Mon, 21 Dec 1998 15:45:35 -0800, glightsey@cari.net (Gerald Lightsey)
wrote:

>I am using Visual dBASE 5.6 and it doesn't seem to accept the CAST 
>function like version 7.0 does.  On the other hand, 5.6 seems to be 
>comfortable in returning the first character from a _NUMERIC_ value with 
>the SUBSTRING function which version 7.0 will not...go figure!
>
>Furthermore, I have run into the situation where an involved 
>age calculation will return correct values when run by itself, but when 
>combined with the rest of the SQL SELECT statement that I need that also 
>runs OK by itself or OK with _CERTAIN_ calculations to produce an age 
>value; the combination returns zero records.  I have not been able to get 
>around this obstacle to get exactly what I want.

I was under the impression that the CAST function was supported by both the
16- and 32-bit versions of the BDE. I currently do not have a copy
installed and so would need to in order to test that. That SUBSTRING might
have worked on numeric values under 16-bit BDE (nonstandard SQL behavior!)
might be attributed to the fact that SQL was actually translated to QBE and
handled by that engine. Under 32-bit BDE, though, a true SQL engine is
employed and SQL standards apply.

What error were you getting when using CAST under 16-bit BDE? Not all SQL
data types now-supported were available then. What was your exact SQL
statement?

//////////////////////////////////////////////////////////////////////////
Steve Koterski                            "Uhn!"
Technical Publications                    -- Ogg the caveman (c. 10,000BC)
INPRISE Corporation
http://www.inprise.com/delphi