FiveTech Software tech support forums

... secs Error occurred at: 09/19/2023, 18:31:36 Error description: Error BASE/1002 No existe el alias: CLI Stack Calls =========== Called from: => DBSETRELATION( 0 ) Called from: FUENTES\GESTION\INVENTARIOS\FACTELEC.PRG => ENVIAFEL( 593 ) Called from: FUENTES\COMUNES\FW_FUNCSST1.PRG => (b)BROWSEMY( ...

...     :CreateFromCode()    END WITH  El error es siempre: Error description: Error DBCMD/2001 Workarea not in use: DBSETRELATION

... DBSetFilter(<bCondition>,[<cCondition>])->Nil DBSetIndex(<cIndexName>)->Nil DBSetOrder(<nOrdernum>)->Nil DBSetRelation(<nArea>|<cAlias>,<bExpr>,[<cExpr>])->Nil DBSkip(<nRecords>)->Nil DBSkipper(<nSkipRequest>)->nSkipResult ...

... DBReindex DBRelation dbRename DBRLock DBRLockList DBRSelect DBRUnlock DBSeek DBSelectArea DBSetDriver DBSetFilter DBSetIndex DBSetOrder DBSetRelation DBSkip DBSkipper DBSort DBStruct DBTableExt DBTotal DBUnlock DBUnlockAll DBUpdate DBUseArea DBZap Default DefPath Deleted DeleteFile Descend ...

... primary keys. I would have a CUSTNO (or similar) in both files. And not allow users to change them. I am planning to do some speed tests with a DBSetRelation() & setScope() and with just OrdSetRelation() to see if there are any significant speed differences. James

... does add a scope, but SET RELATION does not. I thought that SET RELATION just called ORDSETRELATION() but I guess I was confusing it with DBSETRELATION(). I learned something new. Oddly, however, it is still using a scope so it should have the same speed as just setting a scope I would ...

... record number for the "go to" is based on the expression specified by <bKey> and/or <cKey>. ORDSETRELATION() is identical to DBSETRELATION() (and the SET RELATION command),. but it also sets up a scope on the order in the child work area. This means that whenever you select ...

EXPORTS HB_FUN_AADD @1 HB_FUN_ABS @2 HB_FUN_ACCELERATO @3 HB_FUN_ACCELERATOR @4 HB_FUN_ACHOICE @5 HB_FUN_ACLONE @6 HB_FUN_ACOPY @7 HB_FUN_ADEL @8 HB_FUN_ADIR @9 HB_FUN_AEVAL @10 HB_FUN_AFIELDS @11 HB_FUN_AFILL @12 HB_FUN_AINS @13 HB_FUN_ALERT @14 HB_FUN_ALIAS @15 HB_FUN_ALLTRIM @16 HB_FUN_ALTD @17 H...

... things are added to the test. ( I Still have to test using MULTIPLE index ) I added two RELATION-options // Set a relation from BILL into CUST DBSETRELATION("CUST", {|| ("BILL")->CUST_NO}, '("BILL")->CUST_NO') and // Set a selective relation from BILL into ...

... things are added to the test. ( I Still have to test using MULTIPLE index ) I added two RELATION-options // Set a relation from BILL into CUST DBSETRELATION("CUST", {|| ("BILL")->CUST_NO}, '("BILL")->CUST_NO') and // Set a selective relation from BILL into ...

... date do data dblclick declare deleted default delete design device dialog define dbcloseall dbskip dbclosearea dbsetorder dbseek dbrelation dbsetrelation dbgobottom dbgotop dbgoto dbsetfilter dbusearea dbcommit dbrecall dbdelete dbunlock dbappend exit else elseif endif export empty endclass ...

Hi all, I have a xBrowse which has a relation between two databases... dbSETRELATION( Familia , {|| (Articulo)->CodFam}, "(Articulo)->CodFam" ) So I haveit indexed by 1.- CodFam 2.- Name I create the xBrowse like this: ...

Hi all, I have a xBrowse which has a relation between two databases... dbSETRELATION( Familia , {|| (Articulo)->CodFam}, "(Articulo)->CodFam" ) So I haveit indexed by 1.- CodFam 2.- Name I create the xBrowse like this: ...

... SetOrder( cnTag, cFile ) INLINE ( ( ::nArea )->( OrdSetFocus( cnTag, cFile ) ) ) METHOD SetRelation( ncArea, cExp ) INLINE ; ( ::nArea )->( DbSetRelation( ncArea, Compile( cExp ), cExp ) ) METHOD Skip( nRecords ) METHOD Skipper( nRecords ) METHOD UnLock() INLINE ( ::nArea )->( DBUnLock() ...

Lucas:

Podrías apoyarte en la función DBSETRELATION(), así tendrías a tu disposición todos
los campos de las DBF relacionadas.

Saludos