NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Alberto on February 18, 2009, 01:44:21 PM

Title: Form/Browse/Refresh problem
Post by: Alberto on February 18, 2009, 01:44:21 PM

Hi, another problem with PR32 (regresion I beleive)
Form with Child Browse
When you insert/cancel, insert/save, delete the browse sais "not records found', you have to save the form and enter it again to see the child records in the browse.

Note: this does not happend in every From/browse/form, this is a simple Form/Browse/Form without any embed, I´ve deleted them and recreated and the problem is still there.

Thanks
Alberto

Title: Re: Form/Browse/Refresh problem
Post by: Alberto on February 18, 2009, 02:16:33 PM

More debug:

I put  message(loc:filterwas) in the browse.
Once I enter the form

loc:filterwas : U2C:ID_CLINIC = 6

which is ok and the browse works ok

press the insert button, cancel the form an r

loc:filterwas : U2C:ID_CLINIC = 0

Then I change the filter manually like:

loc:filterwas : U2C:ID_CLINIC = p_web.GetSessionValue('CLI:ID')

and the browse still shows "No records found"

Any idea??

Title: Re: Form/Browse/Refresh problem
Post by: Bruce on February 19, 2009, 12:17:14 AM

Hi Alberto,

can you duplicate the effect in any of the examples?

Cheers
Bruce

Title: Re: Form/Browse/Refresh problem
Post by: Alberto on February 19, 2009, 05:33:04 AM

Mmmhhh nop,
I think its something related to MsSql.
If you want I can send you app,dct and database backup (very samll indded)
Alberto

Title: Re: Form/Browse/Refresh problem
Post by: kevin plummer on February 19, 2009, 02:51:39 PM

I'm having a similar problem with MSSQL.

If I have a browse that is a child of a form, change and delete items in the browse works fine, but if I insert a line when I return to the Form\Browse page, the browse is empty.

I tend to use a lot of EIP pre-filling browses with blank lines so had not noticed this until yesterday.

I'm running CW 6.3.9058 NTV4.31.29

Title: Re: Form/Browse/Refresh problem
Post by: Bruce on February 19, 2009, 09:39:52 PM

feel free to send the example in MsSql - with instructions on how to duplicate the effect here.
I can restore your db onto our Sql server.

Cheers
Bruce

Title: Re: Form/Browse/Refresh problem
Post by: Alberto on February 20, 2009, 07:20:21 AM

Sent

Title: Re: Form/Browse/Refresh problem
Post by: ajosuna on February 22, 2009, 10:49:13 PM

Try making the fields in your filter hot. This might help.

Regards

Anthony

Title: Re: Form/Browse/Refresh problem
Post by: Alberto on February 23, 2009, 03:10:52 AM

THnks Anthony but... no, this does not helps.

Title: Re: Form/Browse/Refresh problem
Post by: Alberto on February 24, 2009, 06:31:30 AM

Bruce,
About the example I sent to you:

bClinics: I´ve change the File Relational filter to a conditional filter like:
C2U:ID_CLINIC = p_web.GetSessionValue('cli:ic')
and it began to work ok.

I think File Relational filter is not working.

Regards,
Alberto

Title: Re: Form/Browse/Refresh problem
Post by: Bruce on February 24, 2009, 07:34:59 AM

ok, thanks for the update. I'm unfortunately working under a deadline at the moment so I haven't had a chance to check the example yet...

Cheers

Bruce