DaveS
|
| Posted: 07/31/2002, 2:38 PM |
|
When I try to add a default date time of CurrentDateTime, I get a SQL error
saying that the datetime value is wrong. I think CCS isn't putting single
quotes around the datetime value as it should. ANy way around this?
-Dave
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 08/01/2002, 5:21 AM |
|
Does it happen in Grid or Record ?
What is your CCS version ?
--
Alex,
Support Engineer
CodeCharge Team
"DaveS" <dschu@dmv.state.ny.us> wrote in message
news:ai9lbt$o3k$1@news.codecharge.com...
> When I try to add a default date time of CurrentDateTime, I get a SQL
error
> saying that the datetime value is wrong. I think CCS isn't putting single
> quotes around the datetime value as it should. ANy way around this?
>
> -Dave
>
>
|
|
|
|
DaveS
|
| Posted: 08/01/2002, 6:21 AM |
|
Alex,
This is happening in RECORD. I am using the technique in the tutorial that
has you add a hidden field tied to a database datetime field and uses the
Default property to populate the hidden field with the currentdatetime on a
new record. However like I said, Access or ODBC is throwing an error about
it. The value of the datetime looks good, but I was wondering about the
quotes.
I am using CCS 1.0.7.0 and CF as the Code Language.
-Dave
P.S. One thing that we as CF developers do here is we use CF's
CreateODBCDateTime function to make a datetime string that almost always
works with all ODBC type databases.
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:aib93k$pj6$2@news.codecharge.com...
> Does it happen in Grid or Record ?
> What is your CCS version ?
>
> --
>
> Alex,
> Support Engineer
> CodeCharge Team
>
>
> "DaveS" <dschu@dmv.state.ny.us> wrote in message
>news:ai9lbt$o3k$1@news.codecharge.com...
> > When I try to add a default date time of CurrentDateTime, I get a SQL
> error
> > saying that the datetime value is wrong. I think CCS isn't putting
single
> > quotes around the datetime value as it should. ANy way around this?
> >
> > -Dave
> >
> >
>
>
|
|
|
|
|
