ASA 10.0.1 with Servoy 6.1 Insert Into flips TIME Values to 12:00am

I'm having trouble with a TIME column. The front end application is Servoy 6.1

When a Time is entered into an existing record, it is saved correctly

But when a record is duplicated, with an INSERT INTO, any TIME value is saved as 12:00am

I turned on tracing, and see that the INSERT does have the correct TIME Value e.g. '1970-01-01 20:00:00.000'

and if I INSERT INTO by hand using dbisql, it also works

how could this be ? there are no auto enter or calculated values. Very strange ...

greg

insert servoy

asked 21 Apr '13, 13:38

Gregory Durniak
139●9●10●17
accept rate: 0%

I think it might help to show us some code. I.e. show us exactly what you are doing so we can help you figure out what is happening.

(21 Apr '13, 22:40) Mark Culp

Any before insert trigger on the table ?

(22 Apr '13, 08:06) Thomas Dueme...

flat view

One Answer:

0	Just to close this out ... I decided to change all my DATE and TIME columns to DATETIME. Now it works greg permanent link answered 07 May '13, 07:42 Gregory Durniak 139●9●10●17 accept rate: 0% flat view

Your answer

toggle preview

community wiki:

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

Question tags:

question asked: 21 Apr '13, 13:38

question was seen: 2,107 times

last updated: 07 May '13, 07:42

SAP SQL Anywhere