String format

[boggg1]

I have had no joy with this previous post...

In pulling VARCHAR2(12) or VARCHAR2(10) data from an Oracle database via SQL in Visual Basic in Access the string data becomes truncated at 6 characters. And yet I can pull VARCHAR2(256) strings with no difficulty.

One possible solution is to get SQL to change the string to a different type before it returns the query. Is it possible to change one string type into another before the convertion to Visual Basic has to happen ?

Boggg1

 

[rwheels]

although I'm not familiar with Oracle. It sounds like you want to use CAST. syntax would be something like:
CAST(your_field as CHAR(100))

of course, you would pick whatever datatype and length fits your needs.

 

[boggg1]

Would you believe it, we've just gone Windows 2000 and it fixed itself so I'll never get the chance to try it out.

Thanks anyway, sorry I wasted your time.