Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #9528

Re: How to open a DBF with a UNC path

Newsgroups comp.lang.clipper.visual-objects
Date 2016-07-15 06:17 -0700
References <kq6coblvsun78482jq7lj6sklvrv7pj4ul@4ax.com> <dumsqqF2jc3U1@mid.individual.net> <87mhob5ef298ccuvpfkab80sr8svmcfc5a@4ax.com>
Message-ID <1d8ca7cd-e419-4454-89f2-8086e3bcdb25@googlegroups.com> (permalink)
Subject Re: How to open a DBF with a UNC path
From sherlocksoftware@gmail.com

Show all headers | View raw


Dick

Replaced the default VO generated code to work like this.

Phil McGuinness

CLASS _RECEIPTN INHERIT DBSERVER
	INSTANCE cDBFPath	  := "\SHERLOCK32\SHERDATA\" AS STRING
	INSTANCE cName		  := "RECEIPTN.DBF" AS STRING
	INSTANCE xDriver	  := "DBFCDX"		 AS USUAL
	INSTANCE lReadOnlyMode:= .F.		 AS LOGIC
	INSTANCE lSharedMode  := .T.	 AS USUAL
	INSTANCE nOrder 	  := 0	 AS INT
	//USER CODE STARTS HERE (do NOT remove this line)

METHOD Init(cDBF, lShare, lRO, xRdd) CLASS _RECEIPTN
    LOCAL oFS := FileSpec{} AS FILESPEC             
    SELF:PreInit()
    oFS:Filename := SELF:cDBFPath + SELF:cName
    //
    lShare := IIF( IsLogic( lShare ), lShare, SELF:lSharedMode ) 
    IF IsString(cDBF)
      oFS := FileSpec{SELF:cDBFPath + FileSpec{cDBF}:FileName + FileSpec{cDBF}:Extension}
    ENDIF
    SUPER:Init(oFS, lShare, lRO, xRdd )
    SELF:oHyperLabel := HyperLabel{#_RECEIPTN, "_RECEIPTN", "", "_RECEIPTN"}
    SELF:PostInit()
   RETURN SELF

METHOD PreInit() CLASS _RECEIPTN
    	//Put your PreInit additions here
    	cDBFPath := NULL_STRING
RETURN NIL

METHOD PostInit() CLASS _RECEIPTN
	//Put your PostInit additions here
	SELF:ConcurrencyControl := CCNONE
	RETURN NIL
==========
Change your CAVODED.TPL to this code

[CLASS]
CLASS %classname% INHERIT %superclass%
	INSTANCE cDBFPath	  := "%dbfpath%" AS STRING
	INSTANCE cName		  := "%dbfname%" AS STRING
	INSTANCE xDriver	  := %rdd%		 AS USUAL
	INSTANCE lReadOnlyMode:= %ro%		 AS LOGIC
	INSTANCE lSharedMode  := %share%	 AS USUAL
	INSTANCE nOrder 	  := %order%	 AS INT

[INIT]
METHOD Init(cDBF, lShare, lRO, xRdd) CLASS %classname%
    LOCAL oFS := FileSpec{} AS FILESPEC             
    SELF:PreInit()
    oFS:Filename := SELF:cDBFPath + SELF:cName
    //
    lShare := iif( IsLogic( lShare ), lShare, SELF:lSharedMode ) 
    IF IsString(cDBF)
      oFS := FileSpec{SELF:cDBFPath + FileSpec{cDBF}:FileName + FileSpec{cDBF}:Extension}
    ENDIF
    SUPER:Init(oFS, lShare, lRO, xRdd )
    self:oHyperLabel := HyperLabel{#%hlname%, "%hlcaption%", "%hldescription%", "%hlhelpcontext%"}
    SELF:PostInit()
   RETURN SELF

[FIELDDESC]
ACCESS FieldDesc CLASS %classname%
   LOCAL aRet := {}  AS ARRAY
   LOCAL nFields := %fieldcount% AS DWORD
   IF nFields > 0
      aRet := ArrayCreate(nFields)  // DBC_SYMBOL // DBC_NAME // DBC_FIELDSPEC
      %fielddesc%
   ENDIF
   RETURN aRet

[INDEXLIST]
ACCESS IndexList CLASS %classname%
   LOCAL aRet  := {} AS ARRAY // DBC_INDEXNAME // DBC_INDEXPATH // DBC_ORDERS
   LOCAL nIndexCount := %indexcount% AS DWORD    //{<cOrder>,<lDuplicates>,<lAscending>,<cKey>,<cFor>}
   IF nIndexCount > 0
     //DBC_TAGNAME/DBC_DUPLICATE/DBC_ASCENDING/DBC_KEYEXP/DBC_FOREXP
     aRet := ArrayCreate(nIndexCount)
     %indexlist%
   ENDIF
   RETURN aRet

[PREINIT]
METHOD PreInit() CLASS %classname%
	//Put your PreInit additions here
   cDBFPath := NULL_STRING
	RETURN NIL

[POSTINIT]
METHOD PostInit() CLASS %classname%
	//Put your PostInit additions here
	SELF:ConcurrencyControl := CCNONE
	RETURN NIL

[MACROS]
FieldDesc=\r\n\t\taRet[%pos%] := { #%hlname%, \"%fldname%\",  %classname%{}} \t// %hldescription%
Index=\r\n\t\taRet[%pos%] := { \"%indexname%\", \"%dbfpath%\",; \r\n \t\t\t\t\t{%orderlist% } }
Order={ \"%tag%\", %duplicate%, %ascending%, [%keyexp%], [%forexp%] }





Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

How to open  a DBF with a UNC path D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2016-07-13 12:49 +0200
  Re: How to open  a DBF with a UNC path sherlocksoftware@gmail.com - 2016-07-13 04:10 -0700
    Re: How to open  a DBF with a UNC path D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2016-07-13 15:43 +0200
  Re: How to open a DBF with a UNC path "Wolfgang Riedmann" <wriedmann@gmail.com> - 2016-07-13 15:08 +0200
    Re: How to open a DBF with a UNC path D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2016-07-15 14:39 +0200
      Re: How to open a DBF with a UNC path sherlocksoftware@gmail.com - 2016-07-15 06:17 -0700
  Re: How to open  a DBF with a UNC path Leo_Bond <l.bond@bk.ru> - 2016-07-15 08:26 -0700
  Re: How to open a DBF with a UNC path Martin <Martin@spam.spam> - 2016-07-18 09:06 +0100

csiph-web