O$816, Bind Vars Question

[Philip Tulett]

Hi Denis,

Surely " The birthdate column in the Studio Schema is Date Time, Short Date
1900..1999 " is never going to work correctly with a date in the 1700's.

Kind regards
Philip

-----Original Message-----
From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf
Of Denis Woodbury via omnisdev-en
Sent: 27 November 2018 16:05
To: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
Cc: Denis Woodbury <denis at woodmic.net>
Subject: O$816, Bind Vars Question

Hi,

Using ODBC with SQL Server

Trying to update a date column (birthdate) to '1701-11-26' using a bind
variable will result in 1969-12-31

The birthdate column in the Studio Schema is Date Time, Short Date
1900..1999 Any date inferior to 1901-12-31 using a bind variable like this:
SET birthdate=@[irwrow.birthdate] will result in storing 1969-12-31

The irwrow is set inside the table class so it is in scope, dates greater or
equal to 1901-12-31 work fine.

This works in interacive SQL
update actor set birthdate = '1701-11-26' where actor_id = '2923' 

Any Idea??


Thanks

denis woodbury


_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com Start a new
message -> mailto:omnisdev-en at lists.omnis-dev.com