SDerrick
14th September 2007, 09:55
Hello,

Does anybody know a way in which we can search for instances of extended characters (ßáéíóúýàèìòùäëïöü¿³¹§) that exist in our Baan tables?

Many Thanks

pconde
17th September 2007, 09:41
Hello,

Al these characters have an ASCII value > 127 then you can test with:
for i = 1 to len.field
n = asc(table.field(1,i))
if n > 127 then
message or print or process
endif
This test must be done only for field string or multibyte
If there are many fields then get the table structure via rdi.table.colums and retrieve position and length for fields of type db.string or db.multibyte.

Regards
Philippe