N
nix1016
Guest
I've tried using DBTOOL to fix the sql width but it's still not working even though it's no longer posting any errors when I run it. I tried to find the culprit records using the Buffer record length and I couldn't find any records greater than 32000 (code below). I did find a couple greater than 31000 and have since truncated them but dbanalys is still giving me >32k max record length for this inventory table. We have a notes field inside the table which is probably why certain records can grow to be this large. Is there any other way I can find the problem records? DEFINE VARIABLE hBufferHandle AS HANDLE NO-UNDO. hBufferHandle = BUFFER inventory:HANDLE. FOR EACH inventory: if hBufferHandle:RECORD-LENGTH > 32000 then message hBufferHandle:RECORD-LENGTH. END.
Continue reading...
Continue reading...