O$816, Bind Vars Question

Doug Easterbrook doug at artsman.com
Tue Nov 27 23:03:00 EST 2018


sorry then…   afraid I’m not use to you.

but sounds like the ODBC dam… so if you expect a lot of those dates, then I might wrap up my table class and turn this into direct sql using a substitution loop …    

its brute force .. but short of getting an ODBC dam fix …...

Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug at artsman.com
http://www.artsman.com
Phone (403) 650-1978

> On Nov 27, 2018, at 6:02 PM, Denis Woodbury via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
> 
> Hi Doug,
> 
> It's not an MSSQL issue, as mentioned in my first email, if I do:
> update actor set birthdate = '1701-11-26' where actor_id = '2923'
> 
> The record is updated correctly, the problem is when using a bind variable.
> 
> The same SET birthdate=@[irwrow.birthdate] that does not update correctly using MSSQL via ODBC works fine using Postgres, the main difference here is the DAM, Studio has a DAM specifically for Postgres.
> 
> denis woodbury 
> 
> Le 18-11-27 15:46, « omnisdev-en au nom de Doug Easterbrook » <omnisdev-en-bounces at lists.omnis-dev.com au nom de doug at artsman.com> a écrit :
> 
>    if in doubt…  google the docs.
> 
>     https://docs.microsoft.com/en-us/sql/t-sql/data-types/datetime-transact-sql?view=sql-server-2017
> 
>    I suspect it is not so much an omnis issue than an MS SQL column definition problem.
> 
> 
> 
>    Doug Easterbrook
>    Arts Management Systems Ltd.
>    mailto:doug at artsman.com
>    http://www.artsman.com
>    Phone (403) 650-1978
> 
>> On Nov 27, 2018, at 8:34 AM, David Barnett <david at fairlibertyscall.com> wrote:
>> 
>> The 1900-1999 range indicates the default century for a date entered with a 2-digit year. The actual column should be able to hold earlier dates if you use a 4 digit year.
>> 
>> David
>> 
>> David Barnett                 David at FairLibertysCall.com
>> C: 516-398-8668               www.FairLibertysCall.com
>> 
>>> On Nov 27, 2018, at 11:20 AM, Philip Tulett <philip.tulett at pdq-networks.com> wrote:
>>> 
>>> 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 
>>> 
>>> _____________________________________________________________
>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 
> 
>    _____________________________________________________________
>    Manage your list subscriptions at http://lists.omnis-dev.com
>    Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 
> 
> 
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 




More information about the omnisdev-en mailing list