OK, this is the situation:
I have a table with clients, every client can have services, every service can have one invoice.
So this is the set:
CLIENTS ==>SERVICES-->INVOICES
The "==>" stands for one to many link, the "-->" is one to one link.
Now, in the CLIENTS_FORM I have a browse for the related services. One column of this browse is INVOICE_CODE, a field in the table INVOICES.
Now, if there is some change done with Xbasic to the value of INVOICE_CODE, alpha5 is unable to resync the new value, the only way to do this is to close the CLIENT_FORM (unlocking the set I think) and open it again.
I had the same problem in other situations, and I solved with some kind of workaround. Now is harder to find a workaround, can you help me finding a way?
My need is to refesh the INVOICE_CODE in the browse... without closing and restarting the program :-O
I tryed different refresh methods (object, browse, display), no one helped.
It seems the problem is deep in the linking engine of A5, if I try to use a field from INVOICES outside the browse but inside the CLIENTS_FORM i have the same problem.
Thank to you all for the help you keep on giving!
Enrico
EDIT: well, "an Xbasic change to the value of INVOICE_CODE" is not the right sentence.
Here what's happen:
When it's created every record from SERVICES is linked to a dummy, hidden invoice, with INVOICE_CODE value "No One"
When invoice is emitted, the related service is linked to the right invoice, usin Xbasic, with INVOICE_CODE value "2013 - 24"(just an example)
In the browse, the colum INVOICE_CODE is stuck to "No One". No refresh works, the best I can get is that the value of INVOICE_CODE simply disappears.
If I close the app and run it again the INVOICE_CODE correctly diplays "2013 - 24"
Thanks again.
I have a table with clients, every client can have services, every service can have one invoice.
So this is the set:
CLIENTS ==>SERVICES-->INVOICES
The "==>" stands for one to many link, the "-->" is one to one link.
Now, in the CLIENTS_FORM I have a browse for the related services. One column of this browse is INVOICE_CODE, a field in the table INVOICES.
Now, if there is some change done with Xbasic to the value of INVOICE_CODE, alpha5 is unable to resync the new value, the only way to do this is to close the CLIENT_FORM (unlocking the set I think) and open it again.
I had the same problem in other situations, and I solved with some kind of workaround. Now is harder to find a workaround, can you help me finding a way?
My need is to refesh the INVOICE_CODE in the browse... without closing and restarting the program :-O
I tryed different refresh methods (object, browse, display), no one helped.
It seems the problem is deep in the linking engine of A5, if I try to use a field from INVOICES outside the browse but inside the CLIENTS_FORM i have the same problem.
Thank to you all for the help you keep on giving!
Enrico
EDIT: well, "an Xbasic change to the value of INVOICE_CODE" is not the right sentence.
Here what's happen:
When it's created every record from SERVICES is linked to a dummy, hidden invoice, with INVOICE_CODE value "No One"
When invoice is emitted, the related service is linked to the right invoice, usin Xbasic, with INVOICE_CODE value "2013 - 24"(just an example)
In the browse, the colum INVOICE_CODE is stuck to "No One". No refresh works, the best I can get is that the value of INVOICE_CODE simply disappears.
If I close the app and run it again the INVOICE_CODE correctly diplays "2013 - 24"
Thanks again.
Comment