At 05:06 PM 4/3/2002 +1000, Peter Faulks wrote:

>Does anybody actually use Embedded SQL anymore (or am I the only one?)

the engine for one.

>1) what is the deal with isc_decode_sql_date() why is the result in the tm
>struct a 2 digit year and why is the month off by 1?

Because the tm struct is a c thingy and that's the way it's
defined.

>2) a type decimal - seems to be off by a factor of 100 when fetched into a
>float or even a double - what gives?

Is the number defined as (n, 2) - where n is some number? Then
the problem may be that you're actually getting is back as an
integer and moving it. I'd have to look at the generated code.

>3) I have a query that works fine in insql but barfs in embedded sql -

All I can think of is that you've used the syntax for a singleton
select and should probably use a cursor.

Regards,

Ann