restricted datatype attribute violation

[crystalhelp]

I am getting the above error message when I do a select on a few particular fields from Oracle from within VB using an Oracle driver. VB help says that the problem is with my ODBC Driver, but doesn't say anything more than that. Any suggestions? I can select other fields without any problem. All the ones with problems seem to be numeric. But not all numeric fields are problems. Is the problem maybe related to the length, preicision, scale etc?

 

[ThomVF]

This has something to do with conversion from one datatype to another and appears to be coming from the ORACLE side.

I could not find much more than this. I suggest you try isolate a pattern of fields that fail and their types next.

Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com