When I do a SQL pass-through the format of the alpha fields are returned differently then they should be. The field in our Oracle database is a varchar2(40) which should be an A40 in WebFOCUS but its being returned as a A40V. Has anyone else ran into this? What is the V part of the field format?

Stands for varchar. You can include

SQL SQLMSS SET VARCHAR OFF

as part of your SQL passthru - that may help.

Rick

Is that setting only for MS SQL server? I added SET SQLORA SET VARCHAR OFF to the code but no luck.

My mistake I should have read your post correctly.

SQL SQLORA SET VARCHAR OFF worked great.

Thanks.

How is 7.1.3 running for you?

We installed it in production last week and it is running fine. We put it in to fix some problems with graph.

I like it a lot better then 7.1.0 and 7.1.1 there are still some bugs. But its working good. I'm on the fence if I like the really like the new Server and Client console layout.