Lookups are broken still!

[John Fligg]

Just downloaded 6.11 after Bruce said he fixed a multi lookup issue. Still not working.

See attached. I entered ONE lookup only but when the record was saved ALL other lookup fields were updated with the same ID number.

My database is normalised so it should work.

John

[attachment deleted by admin]

[Bruce]

I did fix a lookup issue, but at the same time you changed how you did lookups (for the better I suspect).
Send me an example so I can see your current technique though, and what is now broken.

cheers
Bruce

[John Fligg]

Check.zip sent Bruce. 100% wizard generated from the dct.

Add a Breed and Sex record first. Now add a patient but DO NOT add the 2nd lookup (Sex). Save the record and see how the Sex field has been saved when it should be empty.

If anyone else wants to test this, attached is that file. Again ignore the app and simply generate from the dct.

HTH and much appreciated

John

[attachment deleted by admin]

[Bruce]

It seems to be working fine.

On the priming tab, pat:breed and pat:sex are being primed to the current session value.
If the session value contains something, then it's primed to that.
You can see the defaults there, and if you clear them they stay cleared.

cheers
Bruce

[Bruce]

but, yes, I see that if you select one field, then the other one can be "set" as well, even if it appears to remain blank.

[Bruce]

fixed in 6.13
If you have 6.12 you can make the small change to netweb.tpw
line circa 5444

IF p_web.ifExistsValue('NewValue')

becomes

IF loc:ok and p_web.ifExistsValue('NewValue')

Cheers
Bruce

[Johan de Klerk]

Hi Bruce,

My lookup's in the example program I sent you are not yet working.

Using 6.12 with the above 6.13 fix.

Regards

Johan de Klerk

[Bruce]

yes Johan, but you're using very "non normalised" data, so that's not a surprise at the moment.

cheers
Bruce

[John Fligg]

Bruce - that works great. Thank you so much.

Have a great Xmas.

BTW will the latest version be updated before Xmas?

John

[Bruce]

um, nope...

[Johan de Klerk]

Hi Bruce,

My "Non Nomalised" lookups are still not working 6.14.

Any idea on a timeframe when it will be working?

Regards

Johan de Klerk