Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!newsfeed.straub-nv.de!news-1.dfn.de!news.dfn.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "Wolfgang Riedmann" Newsgroups: comp.lang.clipper.visual-objects Subject: Re: DBF + Alias Date: 12 Jun 2012 14:42:01 GMT Lines: 25 Message-ID: References: <4fd74cc4$0$18692$91cee783@newsreader03.highway.telekom.at> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Trace: individual.net yX+9i0OB9Z9HGC+MUc1MaAYcK4vpgTNltB6rwb9VqT0iXPjtJO3IRAyMe2Ux4cPuQ= Cancel-Lock: sha1:b1o11TldkCac04WYtpVKttwwG4k= User-Agent: XanaNews/1.18.1.6 Xref: csiph.com comp.lang.clipper.visual-objects:3599 Hi Bernhard, I'm using the following function to get a unused alias: function GetFreeAlias( cAlias as string ) as string local nCounter as dword local cPartAlias as string nCounter := 0 cPartAlias := AllTrim( Left( cAlias, 6 ) ) + "_" while ( Select( cAlias ) > 0 ) ++nCounter cAlias := cPartAlias + NTrim( nCounter ) end return cAlias And then you can use the found alias to open a table. HTH Wolfgang