Search results

Yes it's a variable that i've created because I use the same procedure twice one time for VERIFICATION and one is for ASSIGN so I use the parameter v_traitement to pass my traitement. I found a solution for my problem... I've put my "find first" in a DO TRANSACTION sentence and I catch the...

Is it's possible like Cringer Said before that the no-error if for the assign part and not for the find first statement ?

I'm using 10.1C, I've try to correct the "space" before the " AND ":U it's won't help in my case. For the rest I will try tomorrow morning ... I can't use physical database in my case because i'm in a compagnie so I have to work with two different environment with the same program.

Yes it's exactly why I don't understand the problem ... it's seem that my program doesn't recognize the NO-ERROR statement and send my all the error in the find , which can be erase habitually with the NO-ERROR.

So, I put the message in place where you said to me ... For the validation of the syntax, all the sentence seems to be OK ... For the available I've got yes and no, it's depend if the record already exist or not. For the lock I've got NO for all my record...

FOR EACH bf_invquotevend WHERE bf_invquotevend.no_quote = pool.invquote.no_quote NO-LOCK: DO TRANSACTION: ASSIGN v_err_query_quotevd = h_bf_arclientvd:FIND-FIRST("WHERE ":U + h_bf_arclientvd:BUFFER-FIELD("no_client":U):NAME +...

I've try to put my transaction in a DO TRANSACTION but it's won't change the situation ...

Oh thx for the advice !

I've try to indent the code but it wont work ! :(

FOR EACH bf_invquotevend WHERE bf_invquotevend.no_quote = pool.invquote.no_quote NO-LOCK: ASSIGN v_err_query_quotevd = h_bf_arclientvd:FIND-FIRST("WHERE ":U + h_bf_arclientvd:BUFFER-FIELD("no_client":U):NAME + " = ":U +...

Hi guy's, I just found this forum and I have a question for you ! In one of my program I have a dynamic buffer on a table and I made a find first on it with a no-error statement. My problem is that, most of the time, I receive a message which said to me that "Find first/last as fail ... "...