Form/Browse/Refresh problem

[Alberto]

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

[Alberto]

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??

[Bruce]

Hi Alberto,

can you duplicate the effect in any of the examples?

Cheers
Bruce

[Alberto]

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

[kevin plummer]

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

[Bruce]

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

[Alberto]

Sent

[ajosuna]

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

Regards

Anthony

[Alberto]

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

[Alberto]

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

[Bruce]

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