🚀 go-pugleaf

"Bill Todd" <bill@notthis.dbginc.com> wrote in message
news:s5tkuuklumb7k0o2tdo46fjujjtpf2v998@4ax.com...
> Assuming you are using Delphi,
>
> V := IBDataSet1.FieldByName('SomeField').Value;
>
> will give you the value of any field as a variant.

That's not the question. The question is: how do I convert DATE, TIME, and
TIMESTAMP variant values to values I can use in an SQL statement. Does SQL
using these types accept a 32 bit integer number, a 32 bit integer number,
or a 64 bit integer number respectively for each of these values, or do
these values have to be in some sort of string format, ie. for DATE "Dec
01,2002", to be accepted. If SQL accepts these values as just integer
numbers, then everything is fine, but if SQL needs some sort of string
values, then I have to convert them to some sort of acceptable string
format.

>
> On Sun, 1 Dec 2002 13:10:35 -0500, "Edward Diener"
> <eddielee@tropicsoft.com> wrote:
>
> >What are the equivalent variant types for the Interbase data types ? Some
of
> >these I can guess, particular the numeric, float, and character, but how
are
> >the DATE, TIME, and TIMESTAMP stored in Variants and what are the
equivalent
> >Variant types ?
> >
> >I want to take a Variant value and use its output streaming ability to
> >create values for an SQL INSERT or UPDATE statement. As far as I can see
> >this will work properly for INTEGER, SMALLINT, FLOAT, DOUBLE PRECISION,
> >NUMERIC, DECIMAL, CHAR, and VARCHAR but I do not think it will work for
the
> >DATE, TIME, and TIMESTAMP values without using low-level isc_ functions
that
> >convert these values in Variants to a form which SQL recognizes.
> >
>
>
> --
> Bill (TeamB)
> (TeamB cannot respond to questions received via email)