15 replies to this topic

[Susan Martin]

Using ProIV 5.0000 on Windows NT with MS SQL server version 7.0 I have just discovered a weird bug.
In several files I have records with the primary key field beginning with numbers or various letters of the alphabet. The records are correctly added to the SQL database (I can see all the records when I go through the SQL Server database explorer). When I look at the same file using a PRO IV GUI screen (or browser produced through Developer Studio) I can only see the records up to and including those with Primary keys beginning with 'U'. To see any starting with 'V', 'W','X','Y' or 'Z' I have to do a SEL-PARTIAL.

Has anyone met this bug before? It looks like the SQL command that ProIV is building is excluding key fields that start with V and above.

[Peter Davies]

Susan

Try setting PRODB_CHARSET=7 (or PRODB_CHARSET=8) in the pro4.ini file or as an environment variable.

That should fix it. I've seen this before with DB2 and setting this seemed to work.

Check out the PROIV Environment Guide.

Best regards

Peter

[Tim Woodall]

This is a collating sequence/charset issue. If PRODB_CHARSET=7/8 doesn't fix it then you will have to upgrade to 219 and then put PRODB_CHARSET=Z or z. (You will have to try them both to check whether keys with both upper and lowercase letters are retrieved correctly - I think you will want 'z')

I expect that PRODB_CHARSET=7 is what you need.

SQLServer shouldn't give a problem unless you are using a non european/american collating sequence and character set.

[Susan Martin]

We've tried setting PRODB_CHARSET to 7, 8, Z and z with no success so far - however the SQL Server has been installed with some American settings so we'll have to look into reinstalling it with European settings and see if this solves things. We think it may well be the SQL Server side as the SQL command that is being passed from ProIV is just
'SELECT * FROM rmtaghd'

Thanks Peter and Tim for your suggestions.

[Ralph Gadsby]

Tim obviously missed the fact that you are using a 5.0 beta kernel. As such this should be logged as a fault through the appropriate channel for the beta trial and not discussed here.

[Rob Donovan]

True, it is the 5.0 Beta Kernel....

This should be raised through the proper channels, but this is a free forum and people can discuss whatever they like....

Rob D

[Ralph Gadsby]

Not if it is the subject of a non-disclosure agreement, company confidential, state secret, etc.

[Joseph Serra]

Don't you think you should take this up with the individuals who have signed this agreement?

We SHALL discuss what we want. Do not tell us to do otherwise.

[Susan Martin]

Can we stop the quibbling and nit-picking please!

I had hoped that this forum would be a useful and friendly place to get quick answers to my questions.

I HAVE reported the problem to the PRO IV help desk but am not holding my breath waiting for an answer from them.

We urgently need to fix this problem as a customer cannot go live until it is solved.

I am sorry that Ralph feels that I should not have raised this question on this forum - as far as I understood the version of PRO IV we are using was not a Beta version - but I may be wrong.

Perhaps Rob could email me a copy of the rules so I don't upset anyone in future.

Thanks to other friendly people out there who have suggested solutions to my problem :-)

[Rob Donovan]

If there is something illegal on this forum I will remove it.

I dont consider asking about a problem with something to do with PROIV (whatever version) something illegal.

It may even turn out to be a problem with SQL.

Rob D

[Rob Donovan]

Hi,

Don't worry, you won't have upset too many people.

There are not really any rules.

I have never removed any posts and dont intend to start.

The only thing I dont agree with is anything illegal. If I am requested to remove something for this purpose I will.

I also never give out any personal details (IP, names etc) unless asked for by legal means.

Rob D

[Joseph Serra]

Sorry Susan, it is getting bad today isn't it? I guess we are all rather passionate about our beloved beast 'ProIV'. I am going to have a coffee now and think some happy thoughts...

[Susan Martin]

Thanks for the info on the 'rules' Rob.

When we find out what exactly is causing the problem I'll post the info so other people can make use of the knowledge.

Joseph - I hope you enjoyed your coffee. I wasn't getting upset - just a little put out to find I was stepping on people's toes!

Ah well - back to the codeface.

Regards

Susan :-)

[Glenn Meyers]

Does this mean that Susan is NOT going to be taken out into the courtyard and shot?

Darn.......

[Ralph Gadsby]

This fix actually went into 4.6r223 not 4.6r219.