FiveTech Software tech support forums

nageswaragunupudi wrote:
Such long code can be avoided by using SCOPED RELATIONs.
I will try to give you a sample.

That would be very very nice because my entire systems depend on this !!!

... cZoekData ) )  (cChild)->(DBGOTOP())  Such long code can be avoided by using SCOPED RELATIONs. I will try to give you a sample.

... I consider having a extended call to the function marc_setfilter(oBrwsel,"CustName") and insite the function make a selection for using scoped or filtered data do case case cData = "CustName" ... set index name ... scope the data for quick access case cData = "CustStreet" ...

... brand and just process the 700 records. There is a index on the brand Tag, but I dont think that the function is using it. In relation there is a scoped call involved... Idem.

... database, and only the child database is skipping for the number of records that match the relation with the main database. I saw something like SCOPED relation, but that is not the same as the 1-to-many command in Foxpro http://forums.fivetechsupport.com/viewtopic.php?p=221800&sid=3c2b29d525eb35873bcdbb3792cc56dc&sid=25c46c31fe1e767d08ae1588e662fc02#p221800

Can this also work with multiple dbf's linked ? I believe that only 1 set relation to... scoped can be active at a time... (Not sure) I want a one Xbrowse with 4 dbf linked by a product_id (See a line with product ID and prices from 4 different dbf's) set relation to ...

... you only read the database records you need. Way faster! Another possibility is to use a scope, then filter only the records in the scope. I use scoped filter... They are fast. BTW : Speed is not the problem. All by all... it is fast enough, but optimising code can speed things up, unless the ...

... work and now I'm very afraid, scared to start all over again other time and never get to the end of the conversion of my old application Use scoped relations. There have been a lot of improvements

... TO <exp> INTO <other_table_alias> One-to-many (parent-child) relationship: SET RELATION TO <exp> INTO <child_table_alias> SCOPED All may not be very familiar with setting relationships between two database objects using TDatabase. The intent of this post is to explain this ...

Uwe, The basis colors mosaic, can it be filled with the scoped colors from the database ? and the Metro colors can be the same data, but with the names of the Brand colors into it. In my spicific case, the dark and light browse are not needed, and coulf ...

... prestashop. Brand ColorNaam Hex Dec Rgb Brand1 Red xxxx xxxx xxxx Brand1 Green xxxx xxxx xxx Brand2 HighRed xxxx xxxx xxxx The table will then be scoped for ex. only brand1 for all his colors, and put into a browse for selecting. Thanks The shown metro colors can become one

Scoped relation is simpler and faster. Also less code less bugs

Works perfectly !! Thank you. I have a learning question : I see that you use : SET RELATION TO CODE INTO CUSTOMER SCOPED and I use : :bChange := { || SET_SCOPE(oBrw) } STATIC FUNCTION SET_SCOPE(oBrw)LOCAL cNName := fotoinde->codeDBSELECTAREA( "nofoto" )("nofoto")->( ...

On many occassions we need to create parent-child relationships between tables and browse them. In case of RDD, using scoped relations make this very easy. (cParentAlias)->( OrdSetRelation( cChild, bRelation, cRelation ) ) or SET RELATION TO <expr> INTO <child> SCOPED. ...

... you mean the top of the scope, then yes, but if you mean the top of the file, then no. A scope requires an index on the field to be scoped. It does a seek on the index key, then only reads until the key changes. Thus, if you have a file containing 1000 records but only 10 of them ...