Why Am I Getting "record Not On File (138)" On Progress4gl

[Calne]

I'm trying to check if a record exists, otherwise I want to create it.

For example,

I've got a <table> that doesn't have a tab-code equals to 2, so it is not available, then I do another find just to "call" the table to create a new item, but for some reason it doesn't "call" the table and I get a beautiful standard error: record <table> is not on file (138).

I'm still new to progress4GL, so if it's stupid I apologize profusely.

find <table> where tab-code = 2.

if not avail <table>
then do:

find last solicitacao no-lock no-error.

create <table>.
assign tab-code = 2.

end.

Continue reading...