>Hello Friends,
>
> I am writing one application in VFP and i got following requirement.
>i.e. if customer's credit limit is over then automotically system should give the user reminder that pl. check this customer's status , his limit is over.
>My problem is how to give such functionality because system has to contineously check for database values with timer which is pretty slow. another solution is user will not get it as soons as limit gets over but when he logs in the system again. Is there any API solution for this ?
>
>Please help me on above.
>
>thanks very much
>John Still


It sounds like your form is going to be just a polling station. If this is the case, couldn't you create a trigger on the table (if in a .dbc) to check, and if so, add that customer's record ID to an "OVERLIMIT" table? Then users can (as needed) scan for customer verification of limit.

If this is just for a customer maintenance screen, you could do an immediate check as soon as the customer information is displayed to the customer service rep.