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


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

Re: SP1 to SP4 CDX Tag Files

From "John S." <jsommer_notthis_@alltel.net>
Newsgroups comp.lang.clipper.visual-objects
References (5 earlier) <a9gn46F22vU1@mid.individual.net> <be352$5035521d$6215bed0$31993@ALLTEL.NET> <a9m1e7FqvhU1@mid.individual.net> <7ef12$50361781$4b75098d$23924@ALLTEL.NET> <DBrZr.758$Wo3.426@viwinnwfe02.internal.bigpond.com>
Subject Re: SP1 to SP4 CDX Tag Files
Date 2012-08-23 11:28 -0400
Message-ID <bec47$50364b5f$4b75098d$18404@ALLTEL.NET> (permalink)
Organization UseNetServer.com

Show all headers | View raw


Hi Steve,


Testing is all I have been doing <s>.  I made two small changes to my 
original example to include your suggestion.  The issue is not using a tag 
file different from the DBF name, it is creating the second tag in that 
file.  The code below will not create the second tag.  Let me know if you 
can make this work.

Thanks for your help,

John



METHOD Start() CLASS App
local cbExpression as object
local cTagName,cFileName,cIndexExpr as string
local adbfstru as array
local oServer as DbServer
adbfstru:={}
AAdd(adbfstru,{"FIELDA1","C",10,0})
AAdd(adbfstru,{"FIELDA2","C",10,0})
AAdd(adbfstru,{"FIELDA3","C",10,0})
DBCREATE('\TEMP\TEST1.DBF',adbfstru,"DBFCDX",true,"TEST1")
TEST1->DBCLOSEAREA()

oServer := DbServer{'\TEMP\TEST1.DBF', DBEXCLUSIVE, FALSE,'DBFCDX' }

oServer:SetIndex( 'TEST2.CDX' )     // Modification to original example
cFileName:="\TEMP\TEST2.CDX"   // Modification to original example

cTagName:="TAG1"
cIndexExpr:='FIELDA1+FIELDA2+FIELDA3'
cbExpression := &("{||" + cIndexExpr + "}")
if !oServer:CreateOrder( cTagName, cFileName, cIndexExpr, 
cbExpression,false)
  TextBox{nil,"System Message","Did not create "+cTagName}:SHOW()
endif


cTagName:="TAG2"
cIndexExpr:='FIELDA2+FIELDA1+FIELDA3'
cbExpression := &("{||" + cIndexExpr + "}")
IF !oServer:CreateOrder( cTagName, cFileName, cIndexExpr, 
cbExpression,false)
  TextBox{nil,"System Message","Did not create "+cTagName}:SHOW()
ENDIF



"Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> wrote in message 
news:DBrZr.758$Wo3.426@viwinnwfe02.internal.bigpond.com...
> John
>
>> This is not an issue for me as mine are all standard but I assume you can 
>> no longer create a tag file with multiple tags and a "non-standard" name 
>> post SP1.
>
> Do some more testing - if the index filename is different form the 'DBF 
> name' then you MUST open them in code.
> Eg
>    // Depends on the AUTO_OPEN setting in the enviroment.
>    oServer := DBServer{ 'TEST1.DBF' }       // Will also open TEST1.CDX 
> automatically
>    // Open a second index file that uses the same DBF
>    oServer:SetIndex( 'TEST2.CDX' )            // This is a requirement 
> when using other indices
>
> CYA
> Steve
>
> 

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


Thread

SP1 to SP4 CDX Tag Files "John S." <jsommer_notthis_@alltel.net> - 2012-08-16 13:23 -0400
  Re: SP1 to SP4 CDX Tag Files "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2012-08-17 10:47 +1000
  Re: SP1 to SP4 CDX Tag Files Sherlock <sherlock@sherlock.com.au> - 2012-08-18 07:28 -0700
    Re: SP1 to SP4 CDX Tag Files "John S." <jsommer_notthis_@alltel.net> - 2012-08-20 17:30 -0400
      Re: SP1 to SP4 CDX Tag Files "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2012-08-21 10:18 +1000
        Re: SP1 to SP4 CDX Tag Files "John S." <jsommer_notthis_@alltel.net> - 2012-08-20 20:58 -0400
          Re: SP1 to SP4 CDX Tag Files "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2012-08-21 11:15 +1000
            Re: SP1 to SP4 CDX Tag Files "John S." <jsommer_notthis_@alltel.net> - 2012-08-20 21:30 -0400
          Re: SP1 to SP4 CDX Tag Files "Wolfgang Riedmann" <wriedmann@gmail.com> - 2012-08-21 06:11 +0000
            Re: SP1 to SP4 CDX Tag Files "John S." <jsommer_notthis_@alltel.net> - 2012-08-22 17:44 -0400
              Re: SP1 to SP4 CDX Tag Files "Wolfgang Riedmann" <wriedmann@gmail.com> - 2012-08-23 06:37 +0000
                Re: SP1 to SP4 CDX Tag Files "John S." <jsommer_notthis_@alltel.net> - 2012-08-23 07:46 -0400
                Re: SP1 to SP4 CDX Tag Files "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2012-08-24 01:01 +1000
                Re: SP1 to SP4 CDX Tag Files "John S." <jsommer_notthis_@alltel.net> - 2012-08-23 11:28 -0400
                Re: SP1 to SP4 CDX Tag Files "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2012-08-24 02:18 +1000
      Re: SP1 to SP4 CDX Tag Files Karl Faller <k.faller_withoutthat_@onlinehome.de> - 2012-08-21 09:24 +0200

csiph-web