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


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

Re: DBF + Alias

From "Wolfgang Riedmann" <wriedmann@gmail.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: DBF + Alias
Date 2012-06-12 14:42 +0000
Message-ID <a3p2ppFniU1@mid.individual.net> (permalink)
References <4fd74cc4$0$18692$91cee783@newsreader03.highway.telekom.at>

Show all headers | View raw


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

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


Thread

DBF + Alias "Bernhard Mayer" <Idonotexist@nowhere.com> - 2012-06-12 16:05 +0200
  Re: DBF + Alias "Wolfgang Riedmann" <wriedmann@gmail.com> - 2012-06-12 14:42 +0000
  Re: DBF + Alias dlzc <dlzc1@cox.net> - 2012-06-12 12:13 -0700
  Re: DBF + Alias John Martens <adsl672100@tiscali.nl> - 2012-06-12 21:34 +0200
  Re: DBF + Alias "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2012-06-13 07:39 +1000
    Re: DBF + Alias "Bernhard Mayer" <Idonotexist@nowhere.com> - 2012-06-14 07:51 +0200

csiph-web