Search found 35 matches: dbsetrelation

Return to advanced search

Re: Reason for closing DBF file

... 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( ...
by russimicro
Wed Sep 20, 2023 2:45 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Reason for closing DBF file
Replies: 23
Views: 1102

Re: Xbrowse columnas de distintas fuentes

...     :CreateFromCode()    END WITH  El error es siempre: Error description: Error DBCMD/2001 Workarea not in use: DBSETRELATION
by JoseLuis
Sat Apr 08, 2023 9:01 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Xbrowse columnas de distintas fuentes
Replies: 5
Views: 325

Re: funciones de FWH y Harbour en un archivo .txt

... DBSetFilter(<bCondition>,[<cCondition>])->Nil DBSetIndex(<cIndexName>)->Nil DBSetOrder(<nOrdernum>)->Nil DBSetRelation(<nArea>|<cAlias>,<bExpr>,[<cExpr>])->Nil DBSkip(<nRecords>)->Nil DBSkipper(<nSkipRequest>)->nSkipResult ...
by carlos vargas
Sat Oct 21, 2017 8:44 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: funciones de FWH y Harbour en un archivo .txt
Replies: 7
Views: 5627

Re: funciones de FWH y Harbour en un archivo .txt

... 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 ...
by carlos vargas
Sat Oct 21, 2017 8:43 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: funciones de FWH y Harbour en un archivo .txt
Replies: 7
Views: 5627

Re: Xbrowse a speed problem using SCOPE ?

... 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
by James Bott
Tue Mar 01, 2016 11:46 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Xbrowse a speed problem using SCOPE ?
Replies: 30
Views: 8981

Re: Xbrowse a speed problem using SCOPE ?

... 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 ...
by James Bott
Tue Mar 01, 2016 9:59 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Xbrowse a speed problem using SCOPE ?
Replies: 30
Views: 8981

Re: Xbrowse a speed problem using SCOPE ?

... 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 ...
by ukoenig
Tue Mar 01, 2016 8:22 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Xbrowse a speed problem using SCOPE ?
Replies: 30
Views: 8981

Re: Harbour-32.dll

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...
by pgfdz
Fri May 29, 2015 8:06 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Harbour-32.dll
Replies: 5
Views: 2340

Re: Compare 2 DBF files

... 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 ...
by richard-service
Fri Jan 31, 2014 1:35 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Compare 2 DBF files
Replies: 11
Views: 3675

Re: Compare 2 DBF files

... 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 ...
by ukoenig
Thu Jan 30, 2014 4:53 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Compare 2 DBF files
Replies: 11
Views: 3675

UEStudio wordfile changes for Clipper language

... 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 ...
by Antonio Linares
Thu Apr 18, 2013 11:11 am
 
Forum: Utilities / Utilidades
Topic: UEStudio wordfile changes for Clipper language
Replies: 0
Views: 1277

Re: xbrowse

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: ...
by Franklin Demont
Wed Apr 10, 2013 6:21 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: xbrowse
Replies: 9
Views: 2820

xbrowse

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: ...
by Bayron
Wed Apr 10, 2013 4:34 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: xbrowse
Replies: 9
Views: 2820

Re: Clase TDb o TDatabase....cual usar?

... 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() ...
by Compuin
Thu Feb 28, 2013 6:28 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Clase TDb o TDatabase....cual usar?
Replies: 10
Views: 2774

Re: duda con report

Lucas:

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

Saludos
by Armando
Fri Nov 18, 2011 11:27 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: duda con report y Array [solucionado]
Replies: 4
Views: 531
Next

Return to advanced search