Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

dbcconvert.prg

3 posts in FoxPro Last posting was on 2008-09-27 22:04:05.0Z
John Posted on 2008-09-21 01:34:05.0Z
From: "John" <sekritemail@yahoo.com>
Newsgroups: Advantage.FoxPro
Subject: dbcconvert.prg
Date: Sat, 20 Sep 2008 21:34:05 -0400
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 68.236.253.71
Message-ID: <48d5a318@solutions.advantagedatabase.com>
X-Trace: 20 Sep 2008 19:27:52 -0700, 68.236.253.71
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!68.236.253.71
Xref: solutions.advantagedatabase.com Advantage.FoxPro:260
Article PK: 1109615

We're using Advantage 9 with VFP 9 DBF/CDX files. We created the DBF/CDX
files in VFP and got all our CDX index TAGS setup, etc. Then we run
dbcconvert.prg to make an ADD.

We have a .NET C# app using Advantage to do all the CRUD work with the data.
All is fine.

I have a question about what we can and cannot do back in VFP without
messing up the Advantage app. For example, I know I *cannot* modify the
structure of the DBF without having to run the dbcconvert.prg again.

But... I have some FoxPro PRG scripts that I would like to run on the data
to import some new data into the file. I would like to create some
temporary index files for this process to use then delete when done. But I
don't want to mess up the ADD or Advantage side of my operation.

Can I create individual IDX files for temporary use and delete it when done?
Can I create a new TAG in the CDX for temporary use and delete it when done?

I know I could shut down the Advantage app, do all my VFP work then recreate
the ADD with dbcconvert, but I'd rather not have to do all that. I'd like
to do the import without having to shut down the Advantage app.

Thanks.


Joachim Duerr (ADS) Posted on 2008-09-22 09:25:26.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: dbcconvert.prg
Newsgroups: Advantage.FoxPro
References: <48d5a318@solutions.advantagedatabase.com>
Organization: iAnywhere
User-Agent: XanaNews/1.18.1.9
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 130.214.79.11
Message-ID: <48d75676@solutions.advantagedatabase.com>
Date: 22 Sep 2008 02:25:26 -0700
X-Trace: 22 Sep 2008 02:25:26 -0700, 130.214.79.11
Lines: 34
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!130.214.79.11
Xref: solutions.advantagedatabase.com Advantage.FoxPro:261
Article PK: 1109614


John wrote in <48d5a318@solutions.advantagedatabase.com>:

> I have a question about what we can and cannot do back in VFP without
> messing up the Advantage app. For example, I know I cannot modify
> the structure of the DBF without having to run the dbcconvert.prg
> again.

right.

> But... I have some FoxPro PRG scripts that I would like to run on the
> data to import some new data into the file. I would like to create
> some temporary index files for this process to use then delete when
> done. But I don't want to mess up the ADD or Advantage side of my
> operation.

Temporary indexes created in VFP won't hurt ADS. ADS just wouldn't use
them.

> Can I create individual IDX files for temporary use and delete it
> when done? Can I create a new TAG in the CDX for temporary use and
> delete it when done?

no. Creating a new tag in a structural index would require exclusive
access to the table. If any other user opening the table in the
meantime, ADS wouldn't crash, but the index defined in the dictionary
and the real index file wouldn't have the same structure which could
lead to some weird behaviour.
I'd better create a separate index file for that purpose.

--
Joachim Duerr
System Consultant (Advantage Database Server)
Sybase iAnywhere
advantagesupport[AT]ianywhere.com


John Posted on 2008-09-27 22:04:05.0Z
From: "John" <sekritemail@yahoo.com>
Newsgroups: Advantage.FoxPro
References: <48d5a318@solutions.advantagedatabase.com> <48d75676@solutions.advantagedatabase.com>
Subject: Re: dbcconvert.prg
Date: Sat, 27 Sep 2008 18:04:05 -0400
Lines: 43
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: 68.236.253.71
Message-ID: <48deac5f@solutions.advantagedatabase.com>
X-Trace: 27 Sep 2008 15:57:51 -0700, 68.236.253.71
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!68.236.253.71
Xref: solutions.advantagedatabase.com Advantage.FoxPro:266
Article PK: 1109619

Thanks. I am going to either create a temporary IDX index and use it, or
I'm going to create a permanent index in the CDX and only use it from the
data import routine.

"Joachim Duerr (ADS)" <jojo.duerr@gmx.de> wrote in message
news:48d75676@solutions.advantagedatabase.com...
> John wrote in <48d5a318@solutions.advantagedatabase.com>:
>
>> I have a question about what we can and cannot do back in VFP without
>> messing up the Advantage app. For example, I know I cannot modify
>> the structure of the DBF without having to run the dbcconvert.prg
>> again.
>
> right.
>
>> But... I have some FoxPro PRG scripts that I would like to run on the
>> data to import some new data into the file. I would like to create
>> some temporary index files for this process to use then delete when
>> done. But I don't want to mess up the ADD or Advantage side of my
>> operation.
>
> Temporary indexes created in VFP won't hurt ADS. ADS just wouldn't use
> them.
>
>> Can I create individual IDX files for temporary use and delete it
>> when done? Can I create a new TAG in the CDX for temporary use and
>> delete it when done?
>
> no. Creating a new tag in a structural index would require exclusive
> access to the table. If any other user opening the table in the
> meantime, ADS wouldn't crash, but the index defined in the dictionary
> and the real index file wouldn't have the same structure which could
> lead to some weird behaviour.
> I'd better create a separate index file for that purpose.
>
> --
> Joachim Duerr
> System Consultant (Advantage Database Server)
> Sybase iAnywhere
> advantagesupport[AT]ianywhere.com