🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.vdbase.data.sql
Article #336

Re: creating tables

#336
From: Gary Gary White
Date: Mon, 04 Jan 1999 00:00
38 lines
1813 bytes
On Mon, 04 Jan 1999 18:28:17 +0800, kdtc wrote:

>   True.. that I can do, but by doing so, the fixed path name might
> not work on another installed workstation.   I've thought about
> creating another BDE alias for local data access, but then again,
> I'd have to explicitly state the PATH in the BDE alias and that
> won't do either.  Mind you, I haven't tried putting "." in the
> PATH statement.   I don't think that'll work.  

dbfPathAndName = set("directory") + "\TMPX.DBF"


> Btw, is there any way of extracting the PATH from the BDE alias?
> All I could do was extract the name of the alias via the DATABASE
> OBJECT'S GETSCHEMA() method, but I don't see how that can help
> me in determining the path of the actual datafile.  

The following courtesy of Romain (of course):

FUNCTION GetDatabaseDir(oDatabase)
   if type("GetAliasPath") # "FP"
	   extern cint GetAliasPath(cHandle,cString,;
         cString,cString);
   		IDAPI32 from "DbiFormFullName"
   endif
   cRet=space(261)
   if ( GetAliasPath(oDatabase.handle,"YabbaDabbaDoo","",cRet ) == 0 )
      cRet=cRet.left(cRet.lefttrim().lastindexof("\"))
      else
      cRet=""
   endif
   RETURN cRet


Gary

Some dBASE Stuff at
http://www.AppTools.com/dbase
Technical Details
Message-ID: <3690c578.1416826@forums.borland.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <36905D71.848AE379@netfront.net> <36907CE3.6FAE22E6@ibm.net> <369097C1.615@netfront.net>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,e4cce62cc4a643dc
X-Google-Attributes: gidff5a1,public
From: Gary (Gary White)
Subject: Re: creating tables
Date: 1999/01/04
Message-ID: <3690c578.1416826@forums.borland.com>
X-Deja-AN: 428626752
Content-Transfer-Encoding: 7bit
References: <36905D71.848AE379@netfront.net> <36907CE3.6FAE22E6@ibm.net> <369097C1.615@netfront.net>
Content-Type: text/plain; charset=us-ascii
Organization: Just Me
Mime-Version: 1.0
Reply-To: Gary
Newsgroups: borland.public.vdbase.data.sql