NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: John Fligg on December 22, 2011, 02:43:59 PM

Title: Lookups are broken still!
Post by: John Fligg on December 22, 2011, 02:43:59 PM

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]

Title: Re: Lookups are broken still!
Post by: Bruce on December 22, 2011, 09:58:07 PM

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

Title: Re: Lookups are broken still!
Post by: John Fligg on December 23, 2011, 01:06:15 AM

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]

Title: Re: Lookups are broken still!
Post by: Bruce on December 23, 2011, 03:03:47 AM

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

Title: Re: Lookups are broken still!
Post by: Bruce on December 23, 2011, 03:06:03 AM

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.

Title: Re: Lookups are broken still!
Post by: Bruce on December 23, 2011, 03:13:55 AM

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

Title: Re: Lookups are broken still!
Post by: Johan de Klerk on December 23, 2011, 04:17:01 AM

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

Title: Re: Lookups are broken still!
Post by: Bruce on December 23, 2011, 04:27:44 AM

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

cheers
Bruce

Title: Re: Lookups are broken still!
Post by: John Fligg on December 23, 2011, 07:34:06 AM

Bruce - that works great. Thank you so much.

Have a great Xmas.

BTW will the latest version be updated before Xmas?

John

Title: Re: Lookups are broken still!
Post by: Bruce on December 23, 2011, 11:59:48 PM

um, nope...

Title: Re: Lookups are broken still!
Post by: Johan de Klerk on January 10, 2012, 09:15:19 AM

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