error code 444

[absns]

attempt to expand record beyond the maximum allowed size.

of course it is not true, record is short enough, that message i got when i start one procedure before trying to reach any record

 

[longhair]

absns,
can you post the code?

here is the explanation of the message:
Records are made up of fields that vary in length. The size of an individual record is the sum of the sizes of all its fields. Records must always be less than 32,000 characters long. If necessary, try splitting your record into two records, in two files, with the same key values in both.

do you need every field?

regards,
longhair

 

[absns]

Tnx longhair as i said i dont use such a long record, i got that message and error code when i start particular procedure. Records r much shorter. That is what confusing me.

 

[longhair]

absns,
again, can you post the code?
as the explanation above states, a record is made up of all of it's fields. so if you are doing something like:

for each table1 no-lock:
display table1.
end.

and table1 has a lot of very large fields then it's possible that you will reach the 32000 limit. that's why i asked to see the code.
if you change the procedure slightly to return only 1 field do you still receive the error?
take a look at your schema for the table / tables involved and see what types of fields and field lengths are associated with your procedure.
regards,
longhair

 

[absns]

lonhair really thank u, but i have to say i got that message when procedure is invited, before it is executed not even one single line

 

[longhair]

absns,
i do not understand what you are saying. "how was the procedure invited"?
is the procedure compiled?
without seeing the code associated with the procedure i do not think i can help you any further.
in order for the procedure editor to return an error either the has to be run or you have to initiate a syntax check.
regards,
longhair

 

[absns]

ok tnx anyway