Board index » delphi » ParamByname('Time').DataType:=ftTime problem

Mark Payton

Delphi Developer
Sun, 04 Jul 2004 19:18:54 GMT

ParamByname('Time').DataType:=ftTime problem

Dear all

I have a ADOCommand connected to a ADOConnection
I have a parameter of type ftTime

i do a INSERT query specifying the Parameter as an element to be inserted.

The problem is that the field in the table shows as "00:00:00"

What am i doing wrong?

ps. My database is Access2000 (connected by ODBC system data source)

Many Thanks

Mark Payton.

 
Mark Payto

Delphi Developer
Sun, 04 Jul 2004 23:48:21 GMT

Re:ParamByname('Time').DataType:=ftTime problem


This might be worth knowing....

I have just got it to store times in an access database but only by changing
the parameter type to "ftFloat". is this a bug I wonder?

anyway just thought i would pass it on!

Mark

Quote
"Mark Payton" <mark.pay...@derbyshire.gov.uk> wrote in message

news:3c4561c3_2@dnews...
Quote
> Dear all

> I have a ADOCommand connected to a ADOConnection
> I have a parameter of type ftTime

> i do a INSERT query specifying the Parameter as an element to be inserted.

> The problem is that the field in the table shows as "00:00:00"

> What am i doing wrong?

> ps. My database is Access2000 (connected by ODBC system data source)

> Many Thanks

> Mark Payton.

Brian Bushay Team

Delphi Developer
Mon, 05 Jul 2004 13:47:49 GMT

Re:ParamByname('Time').DataType:=ftTime problem


Quote
>I have a ADOCommand connected to a ADOConnection
>I have a parameter of type ftTime

Since Access Does not have a time field type that won't work.
Try type DateTime

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Mark Payto

Delphi Developer
Mon, 05 Jul 2004 18:37:19 GMT

Re:ParamByname('Time').DataType:=ftTime problem


 This might be worth knowing....

 I have just got it to store times in an access database but only by
changing
 the parameter type to "ftFloat". is this a bug I wonder?

 anyway just thought i would pass it on!

 Mark

 "Mark Payton" <mark.pay...@derbyshire.gov.uk> wrote in message

Quote
> news:3c4561c3_2@dnews...
> > Dear all

> > I have a ADOCommand connected to a ADOConnection
> > I have a parameter of type ftTime

> > i do a INSERT query specifying the Parameter as an element to be
inserted.

> > The problem is that the field in the table shows as "00:00:00"

> > What am i doing wrong?

> > ps. My database is Access2000 (connected by ODBC system data source)

> > Many Thanks

> > Mark Payton.

Mark Payto

Delphi Developer
Mon, 05 Jul 2004 18:37:04 GMT

Re:ParamByname('Time').DataType:=ftTime problem


Quote
"Mark Payton" <mark.pay...@derbyshire.gov.uk> wrote in message news:...
> This might be worth knowing....

> I have just got it to store times in an access database but only by
changing
> the parameter type to "ftFloat". is this a bug I wonder?

> anyway just thought i would pass it on!

> Mark

> "Mark Payton" <mark.pay...@derbyshire.gov.uk> wrote in message
> news:3c4561c3_2@dnews...
> > Dear all

> > I have a ADOCommand connected to a ADOConnection
> > I have a parameter of type ftTime

> > i do a INSERT query specifying the Parameter as an element to be
inserted.

> > The problem is that the field in the table shows as "00:00:00"

> > What am i doing wrong?

> > ps. My database is Access2000 (connected by ODBC system data source)

> > Many Thanks

> > Mark Payton.

AdoAnywhere Tea

Delphi Developer
Mon, 05 Jul 2004 20:59:57 GMT

Re:ParamByname('Time').DataType:=ftTime problem


If you would like to see a complete list of ADO provider types supported by
your OLEDB provider, try the OpenSchema call on Provider Types.

On my system Access JET is showing DateTime Only.

Our tool does OpenSchema Calls in a GUI in case you get stuck with the 39
calls and criteria for them.

--
Michael Collier Bsc (Hons) Comp Sci
ADO Support Tools.
Download Free Fully Working 30-Day Trial in 7 Minutes From...
http://www.adoanywhere.com/download/aaBrowse2_6.zip

All information in this message is provided 'As is' and without warranty of
any kind. http://www.adoanywhere.com

"Brian Bushay TeamB" <BBus...@Nmpls.com> wrote in message
news:4rnc4ucqi5cdish2s9b70h2kh0oetkfq38@4ax.com...

Quote
> >I have a ADOCommand connected to a ADOConnection
> >I have a parameter of type ftTime

> Since Access Does not have a time field type that won't work.
> Try type DateTime

> --
> Brian Bushay (TeamB)
> Bbus...@NMPLS.com

Other Threads

1. Query.ParamByName('Foo').AsMemo ?

2. D5: ParamByName('Fld').Clear is NoGo

3. what's the difference between the 'time.h's in BCB

4. ADO Query parameters: ParamByName doesn't work correctly

5. ParamByName doesn't works?

6. TIBQuery.ParamByName('field'):='' becomes NULL on server?

7. TIBQuery.ParamByName('field').AsString:='' becomes NULL on server?

8. 'isc_encode_sql_date' error StoreProcedure.ParamByName('SomeDate').AsDate

9. Parambyname doesn't work.

10. decrease 'show-hint-time'