DBKit and Sybase datetime fields

Thread View: comp.sys.next.programmer

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Mike Ferris Fri, 07 Aug 1992 20:43

#492

Author: Mike Ferris
Date: Fri, 07 Aug 1992 20:43

7 lines
680 bytes

Has anyone tried to use DBKit with sybase datetime fields.  How do you do  
it in modeller?  Can you just set it to string and have it auto-convert  
(this seems too easy), or must I do something ugly like define a view in  
sybase which converts the date to a string?  If I have to do a view, will  
updates work right?

Thanks in advance for any help.

Re: DBKit and Sybase datetime fields

#500

Author: William Shipley
Date: Sat, 08 Aug 1992 10:06

26 lines
1785 bytes

In article <1992Aug7.204326.1433@Trirex.COM> mferris@trirex.com (Mike Ferris)  
writes:
> Has anyone tried to use DBKit with sybase datetime fields.  How do you do  
> it in modeller?  Can you just set it to string and have it auto-convert  
> (this seems too easy), or must I do something ugly like define a view in  
> sybase which converts the date to a string?  If I have to do a view, will  
> updates work right?

Just set it to be of type string.  Note that in DBModeller all you are doing is  
setting how the property is stored internally in the DBGenericRecord  
(undocumented), you can still treat any property as any type you like.

That is to say, just because you have a column of, say, type MONEY in Sybase,  
you can still tell DBModeller to store it as a string, if you really want.   
(This would probably have some bad side effects, but would mostly work.)

Lots of things in DBKit happen magically, conversion is one of them.

Note that there is currently a bug in the way dates are handled that prevents  
you from saving an entity with dates twice in a row without getting a "Record  
modified by someone else" warning from DBKit.

I have a fix for this, but I won't get into it on the Net.  Email me for  
details, if you get stuck on this.

-W

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads