User profile for John Oliver

Pete, Thanks, I thought it would be in your software somewhere, was just looking for it. As I said, my SQL skills are minimal at best. / comments

Pete, Thanks, I thought it would be in your software somewhere, was just looking for it. As I said, my SQL skills are minimal at best.

0 votes

Pete, I will get a snapshot to you as soon as I work out how to do this. It should be with you within the hour. / comments

Pete, I will get a snapshot to you as soon as I work out how to do this. It should be with you within the hour.

0 votes

Peter, Many thanks, I will try this and let you know if this works. / comments

Peter, Many thanks, I will try this and let you know if this works.

0 votes

Peter I am getting the following error during the Syncronisation of the database between the two databases - The following error message was returned from the SQL Server: [468] Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. The following SQL command caused the error: /* $Header: /Tools/SQLScripts/Templates/ApplicationDB/S002_IdoColumnWithAliasView.sql 1 3/30/07 3:38p Tblosser $ */ /* Copyright � 2007 Infor Global Solutions Technology GmbH and/or its affiliates and subsidiaries. All rights reserved. The word and design marks set forth herein are trademarks and/or registered trademarks of Infor Global Solutions Technology GmbH and/or its affiliates and subsidiaries. All rights reserved. All other trademarks listed herein are the property of their respective owners. */ CREATE VIEW [dbo].[IdoColumnWithAliasView] AS WITH ColumnSchema (TableName, ColumnName, OrdinalPosition, DataType, DataLength, DataDecimalPos, ColumnDataType) AS ( SELECT TABLE_NAME , COLUMN_NAME , ORDINAL_POSITION , dbo.MongooseTypeFromSqlType(DATA_TYPE) , CASE WHEN DATA_TYPE IN (N'text', N'char', N'varchar', N'sysname') THEN CHARACTER_MAXIMUM_LENGTH WHEN DATA_TYPE IN (N'ntext', N'nchar', N'nvarchar') THEN CHARACTER_MAXIMUM_LENGTH WHEN DATA_TYPE IN (N'numeric', N'decimal') THEN NUMERIC_PRECISION ELSE NULL END , CASE WHEN DATA_TYPE IN (N'numeric', N'decimal') THEN NUMERIC_SCALE ELSE NULL END , ISNULL(DOMAIN_NAME, DATA_TYPE) FROM INFORMATION_SCHEMA.COLUMNS ) SELECT CollectionName , ColumnSchema.TableName , ColumnSchema.ColumnName , ColumnSchema.OrdinalPosition , TableAlias , TableAlias + '.' + ColumnSchema.ColumnName AS ColumnWithAlias , TableType , JoinType , JoinText , DevelopmentFlag , ColumnSchema.DataType , ColumnSchema.DataLength , ColumnSchema.DataDecimalPos , ColumnSchema.ColumnDataType FROM ido.Tables t INNER JOIN ColumnSchema ON ColumnSchema.TableName = t.TableName If there is anything you can do, I would be most grateful, as I am being contsantly asked if this has been resolved yet. / comments

Peter I am getting the following error during the Syncronisation of the database between the two databases - The following error message was returned from the SQL Server: [468] Cannot resolve the c...

0 votes

How can we help you today?

John Oliver

Comments