HMGforum.com

Martín gracias por interés, estoy usando SQLITE y creo que éste no maneja ENCODING al menos yo no he encontrado, pero cuando hago un select a la tabla SI se muestra las letras acentuadas y las ñÑ.

I used to use visual foxpro and used the select from sql functions.
I have never been able to use sql in hmg so I create temp indexes and tested. It is just as fast.
You could try it. Same type of code. Say you have a customer file.
use customer new shared
index on on name to temp for upper(city) = 'MORELIA'
browse fields name, city
delete the temp file.
This brings in all the fields of the table.
Maybe this way would bring in what you want by not using sql // select name, city from customer for upper(city) = 'MORELIA'

Franco

I might have not explained my thoughts properly.
open your sql database as usual.
Then instead of select item, next ,next, next from table order by item.
Browse or Report
Instead
Select table
Index on item to temp for item = ?.
Browse or report.
erace := temp.ntx or idx