Re: SQL Error- SQLBindColumn and TimeStamp Field

Please clarify "trying to insert a Timestamp field"
Are you doing Data Definition -- creating a timestamp field
or
Data Manipulation -- populating data into an existing timestamp field.

If data manipulation:
I do not know Delphi, but couldn't you execute as query string against a
connection -- a string like
"INSERT INTO my_table (my_time) VALUES ('2004-11-17 12:10:35')"?

and did you mean for the year value to be 200?

Ed Brown wrote:

> I have been trying to do an insert into a TimeStamp field in
> Postgresql 7.34 (running on Suse 9.0, if it matters). The application
> is in Delphi 7.0, but the code is similar enough that you C gurus
> should be able to see what's happening. I get the text as a string,
> parse it into the various elements, and populate the
> SQL_TimeStamp_Structure. When I execute the SQLBindColumn function I
> get the following message:
>
> Unable to Bind Parameter- State: S1003, Error # 0,
> [Microsoft][ODBC Driver Manager] Program type out of range
>
> The values in the structure are reasonable, and other elements work
> properly. Can anyone either tell me what I'm doing wrong, or show me
> an example of setting a Timestamp value that works?
>
> Thanks very much. Code Follows
>
> Ed Brown
> ------------------------------------------------------------------------
>
> New(pTimeStamp);
> DecodeDate(dtThis, i1,i2,i3);
> pTimeStamp^.year := i1;
> pTimeStamp^.Month := i2;
> pTimeStamp^.Day := i3;
> DecodeTime(dtThis, i1,i2,i3,i4);
> pTimeStamp^.Hour := i1;
> pTimeStamp^.minute := i2;
> pTimeStamp^.second := i3;
> pTimeStamp^.fraction := i4;
>
> New(piTemp);
> lIntegers.Add(piTemp);
>
> // Fails on next call
> retcode := SQLBindParameter(hSTMT, i + 1, SQL_PARAM_INPUT,
> SQL_C_TYPE_TIMESTAMP,
> SQL_TYPE_TIMESTAMP,
> SizeOf(SQL_TIMESTAMP_STRUCT), 0 ,
> pTimeStamp,
> SizeOf(SQL_TIMESTAMP_STRUCT), piTemp) ;
> ------------------------------------------------------------------------
> The values are:
>
> pTimeStamp^.year = 200
> pTimeStamp^.Month = 7
> pTimeStamp^.Day = 15
> pTimeStamp^.Hour := 11
> pTimeStamp^.minute := 15
> pTimeStamp^.second := 0
> pTimeStamp^.fraction := 0
>