We currently have a separate database that we use to store data in that is downloaded from our website, this data we wish to import into SalesLogix. We have developed a tool to do this, however when we put it into production we are having issues.
Whenever we select a record from a particular table with a Date in it does not return the row, I have produced some simple code to prove this theory;
dim ssQL,objSLXDB,SLX_DB,objRSFields
sSQL = "select * from webprops_asset where assetid = '3865'"
Set objSLXDB = NEW SLX_DB
Set objRSFields = objSLXDB.GetNewRecordSet
objRSFields.Open sSQL, objSLXDB.Connection
msgbox objRSFields("Assetmodel")
objRSFields.Close
The webprops_asset is a view of the external database (definition below)
[dbo].[asset](
[assetID] [int] IDENTITY(1,1) NOT NULL,
[assetEntityID] [int] NULL,
[assetManufacturer] [varchar](64) NULL,
[assetModel] [varchar](64) NULL,
[assetDerivative] [varchar](64) NULL,
[assetCapCode] [varchar](64) NULL,
[assetImport] [varchar](64) NULL,
[assetImportType] [varchar](64) NULL,
[assetDrive] [varchar](64) NULL,
[assetType] [varchar](64) NULL,
[assetMileage] [varchar](64) NULL,
[assetChassisNumber] [varchar](64) NULL,
[assetExtras] [varchar](64) NULL,
[assetRegNumber] [varchar](12) NULL,
[assetRegDate] [datetime] NULL,
[assetCapValue] [float] NULL,
[assetClass] [varchar](32) NULL,
[assetUseage] [varchar](32) NULL)
When using the OLE Database connection all is good, works fine! However when we use the SQLNative Client it will not return the row unless we omit the assetRegDate field from the query.
Any ideas? Has anyone else expeianced this?
|