11/26/2024 5:25:45 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.
|
|
|
|
Data disappearing from remotes.
Posted: 30 Mar 07 2:34 PM
|
fiogf49gjkf0d I have a database that has been upgraded from version 4.x, and today, we modified the length of a string field on a table. When these changes synch to the remotes, all data disappears from the table. I think I have the cause tracked down. In the TEF files, SalesLogix creates a temp table, inserts all the data from the original table, drops the original table, recreates the original table, and then does a Insert Into Original Select * From Temp statement. I think that there are date fields in this table that are NOT in ISO format, and this is causing the inserts to fail.  Does anyone have anything that would identify all of the date fields in the database, and make sure that all data is in ISO format? Thanks.
Lloy |
|
|
|
Re: Data disappearing from remotes.
Posted: 31 Mar 07 7:57 AM
|
fiogf49gjkf0d Hi Lloy,
How's life on the "other side"?
I'd guess you probably have a bunch of legacy code that is not doing datetime correctly (using date vrs Now), etc.....
You can find the datetime fields by looking at sysobjects.. but it's not going to tell you which fields are datetime vrs date vrs time.
One reliable way is to look at the "blank" via the slx dbmanager.
--
rjl |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|