query to find- which memo fields have >250 char

[twe10]

I am having some trouble with a few memo fields being truncated at 250 chars and would like to perform a query to know which entries in the memo [or notes] field has over 250 chars-- any ideas--

Thanks in advance

 

[Kliot]

twe10

I can't think of a way to do this with a query but it can be easily done with a scan in objectpal. The following code will scan the table and when it finds a record with a note field greater than 250 characters it puts the code number for that record into an array then when the scan is done it displays the array. You would probably want to create another table with the same structure as the original and use something like copyRecord() instead of the array to give you a duplicate table with the desired records.

var
tc tcursor
ar array[] anytype
endvar

tc.open("tableName&quot
scan tc for tc.note.size() > 250:
ar.addlast(tc.code)
endscan

ar.view()

Let me know if this helps
Perrin