data pipe number or decimal field

Discuss DataPipe. Get help with installation and running it, notify us of bugs, request new features and enhancements.

Moderators: DataMystic Support, Moderators

sheridany
Posts: 39
Joined: Thu Nov 15, 2007 4:20 am

data pipe number or decimal field

Postby sheridany » Fri Mar 26, 2010 2:23 am

I am trying out datapipe and it is returning both number fields with the following error in each row of the two columns.

Unknown Type - 131

I tried to cast it as a different type but that did not work.

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: data pipe number or decimal field

Postby DataMystic Support » Fri Mar 26, 2010 8:21 am

According to documentation, type 131 is "An exact numeric value with a fixed precision and scale" - and OLE should be converting this for us.

Can you exclude it from the query by just selecting the primary key and other fields you need?
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “DataPipe Support”

Who is online

Users browsing this forum: No registered users and 1 guest