WD14 user groupware

I have extended the user groupware to operate with MS SQL, plus some other ui enhancements. Additionally a couple of extra fields were added to the users table e.g.

GPWUser.LanguageCode

If the GPWLogin form, the procedure CheckUser was modified so that
after

IF HFound(GPWUSER) THEN

we set a variable

gsLanguageCode     = GPWUSER.LanguageCode

This does not work in WD14, though it was fine in WD12.

Error

No LanguageCode item found in GPWUser file

The workaround seems to be to do a SQL Select to get the value, which works fine.

Now I know it is probably a bad idea to add extra fields to the groupware tables, and we, have considered creating another table for 'extra' data and synching the rows, but as it was only two fields, we thought we would try it and it initially worked. Quite why it doesn't now is beyond me.


Regards

Malc

Hi Malc,

I assume that you have to HOpenAnalysis(..) before being able to use it. I'd try to do a HListAnalysis(..) before the statement
gsLanguageCode = GPWUSER.LanguageCode
in order to make sure that the analysis (changed by yourself not as a fixed one from PCS!) is available to your software. As I remember, the tricky thing is to locate the analysis (switch of paradigma in test mode / exe run).

Kind regards
Guenter

Hi Guenter

I've coded around the issue now, but I will try you suggestion when I have a moment.


Cheers

Malc