FiveTech Software tech support forums

... thing though - I'm going to have to write some type of parser that will create sql expressions from std expressions we use in clipper to obtain a scoped recordset. I'm not sure where the convergence is between XML and GX, but the demo is on its way... I have a 'freebie' - if you try and successfully ...

... person-> groupID FOR TempGroupID TO TempGroupID ; OF oDlg ; SIZE 300, 200 If yes, then the ListBox must have the INDEX on GroupID and in the “scoped” view I can’t use the other Indexes like name, street, … anymore. Regards, Otto

... it in one case and give the code below. This code uses c:\fwh\samples\customer.dbf. The code creates necessary indexes and shows parent child scoped browses. The child table is related to the parent table with ordSetRelation. I also provided an option to choose either txbtowse or twbrowse. ...

... small file, setFilter() will be way too slow--it reads every record in the file. OrdScope() requires that the data be indexed on the field being scoped. It will read only those records within the scope so it is very fast. The sample is the code you quoted in your message. James

... campo de relacion en la tabla padre... hasta aqui creo que lo entediste bien. Ahora, en Clipper 5.3 existia el comando SET RELATION .... INTO ... SCOPED que lo hacia era hacer un SCOPE en la tabla hija con respecto al campo en la tabla padre, lo que ocmente es que ignoraba si en (x)Harbour, el ...

Scopes are great, try a scope and then a filter with the scoped database.

Or you can use the ADS LOCAL server, Filters are damn fast with ADS, even using SET FILTER and not need to use any additional indexes.

... tiene mucha complicacion. Una de las cosas que poca gente sabe, e ignoro si esta soportada en (x)Harbour y que tenia Clipper 5.3, es la clausula SCOPED dentro del SET RELATION, la clausula SCOPED establece un SCOPE automatico en la tabla hija, filtrando los registros cada vez que te mueves en ...