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.

Foxpro 2.6 and adding tables to a database

4 posts in FoxPro Last posting was on 2012-07-30 22:04:42.0Z
"CarlP" Posted on 2012-07-30 16:41:45.0Z
From: "CarlP" <>
Subject: Foxpro 2.6 and adding tables to a database
Newsgroups: Advantage.FoxPro
Date: Mon, 30 Jul 2012 17:41:45 +0100
X-Priority: 3
X-Library: Indy 9.00.10
X-Newsreader: <dedXmlGateway>
NNTP-Posting-Host: 88.198.32.147
Message-ID: <5016930a@solutions.advantagedatabase.com>
X-Trace: 30 Jul 2012 06:58:34 -0700, 88.198.32.147
Lines: 26
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.FoxPro:395
Article PK: 1109751

 Hello,

My name is Carl and I am new here. I have developed in FoxPro for many
years and just started using VS 2010 last fall. I am converting
application written in Fox 2.6 and Clipper 5 to VB.net using Advantage
Server to access the DBF tables.

I would like to add the now free tables to an Advantage Database. Both
the Fox and Clipper applications use Fox 2.6 compatable DBF and CDX
formats.

Since there are 100's of tables and dozens of Clipper and Fox 2.6
applcations running on our systems here I need to certain that adding
the table to an Advantage dtatbase will have no affect whatsoever on any
of the current application. has anyone done this in similiar
circumstances and did you run into any issues?

Also, does the Advantage Database modify the DBF or CDX file added to it
in any way at all?

Thanks, Carl




--- posted by geoForum on http://www.newswhat.com


Mark Wilkins Posted on 2012-07-30 14:56:17.0Z
From: "Mark Wilkins" <a@b.c>
Newsgroups: Advantage.FoxPro
References: <5016930a@solutions.advantagedatabase.com>
In-Reply-To: <5016930a@solutions.advantagedatabase.com>
Subject: Re: Foxpro 2.6 and adding tables to a database
Date: Mon, 30 Jul 2012 08:56:17 -0600
Lines: 2
Organization: Sybase
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8089.726
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8089.726
NNTP-Posting-Host: 10.6.193.219
Message-ID: <5016a090$1@solutions.advantagedatabase.com>
X-Trace: 30 Jul 2012 07:56:16 -0700, 10.6.193.219
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.FoxPro:396
Article PK: 1109749

Hi Carl,

Advantage makes no modifications to DBF tables or their indexes when adding
them to a data dictionary. You should be able to do a simple test to verify
this if you want. Make a copy of a table and its indexes and then add the
table (e.g., the copied one) with its indexes to a dictionary and then do a
binary file compare of the files afterward.

There is at least one thing to be aware of. If you change the structure of
a table, you need to make sure the data dictionary is "aware" of that
change. The dictionary stores the metadata of the table (field and index
information). If it has a mismatch with the physical table, it can lead to
errors. The simplest way to be sure they are in agreement is to modify the
table structure using Advantage (e.g., Advantage Data Architect). If you
modify the table structure (or add/change/remove an index) with a
non-Advantage application, then you should probably remove the table from
the dictionary and add it back in again to refresh the metadata.

Mark Wilkins
Advantage R&D

"CarlP" wrote in message news:5016930a@solutions.advantagedatabase.com...
> Hello,
>
> My name is Carl and I am new here. I have developed in FoxPro for many
> years and just started using VS 2010 last fall. I am converting
> application written in Fox 2.6 and Clipper 5 to VB.net using Advantage
> Server to access the DBF tables.
>
> I would like to add the now free tables to an Advantage Database. Both
> the Fox and Clipper applications use Fox 2.6 compatable DBF and CDX
> formats.
>
> Since there are 100's of tables and dozens of Clipper and Fox 2.6
> applcations running on our systems here I need to certain that adding
> the table to an Advantage dtatbase will have no affect whatsoever on any
> of the current application. has anyone done this in similiar
> circumstances and did you run into any issues?
>
> Also, does the Advantage Database modify the DBF or CDX file added to it
> in any way at all?
>
> Thanks, Carl
>
>
>
>
> --- posted by geoForum on http://www.newswhat.com


"CarlP" Posted on 2012-07-30 22:04:42.0Z
From: "CarlP" <>
Subject: Re: Foxpro 2.6 and adding tables to a database
Newsgroups: Advantage.FoxPro
References: &lt;5016930a@solutions.advantagedatabase.com&gt; <5016a090$1@solutions.advantagedatabase.com>
Date: Mon, 30 Jul 2012 23:04:42 +0100
X-Priority: 3
X-Library: Indy 9.00.10
X-Newsreader: <dedXmlGateway>
NNTP-Posting-Host: 88.198.32.147
Message-ID: <5016deb9@solutions.advantagedatabase.com>
X-Trace: 30 Jul 2012 12:21:29 -0700, 88.198.32.147
Lines: 13
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.FoxPro:397
Article PK: 1109750

 Hi Mark,

Thanks for the reply. I will try that test just to be sure. That is a
good idea. As for modifcations, I am well aware having been bitten by
that in VFP using the DBC and moving files from developement to
production. I'll be careful.

Regards,
Carl



--- posted by geoForum on http://www.newswhat.com


Mark Wilkins Posted on 2012-07-30 19:54:19.0Z
From: "Mark Wilkins" <a@b.c>
Newsgroups: Advantage.FoxPro
References: &lt;5016930a@solutions.advantagedatabase.com&gt; <5016a090$1@solutions.advantagedatabase.com> <5016deb9@solutions.advantagedatabase.com>
In-Reply-To: <5016deb9@solutions.advantagedatabase.com>
Subject: Re: Foxpro 2.6 and adding tables to a database
Date: Mon, 30 Jul 2012 13:54:19 -0600
Lines: 1
Organization: Sybase
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8089.726
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8089.726
NNTP-Posting-Host: 10.6.193.219
Message-ID: <5016e66b$1@solutions.advantagedatabase.com>
X-Trace: 30 Jul 2012 12:54:19 -0700, 10.6.193.219
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.FoxPro:398
Article PK: 1109752

Yes - VFP does indeed add back link information to the header. And with ADT
(the Advantage proprietary) tables, Advantage does something similar. But
with DBF tables, we do not change them specifically for the reason you
mention - so that existing non-Advantage applications can still use the
tables.

It is, of course, possible to modify the table structure with Advantage and
add a field type that would not be recognized by other applications, but
that is a pretty obvious thing that doesn't happen "accidentally". You can
also add FTS (full text search) indexes to DBFs with Advantage. I doubt
that other applications would be able to open those indexes.

Mark Wilkins
Advantage R&D

"CarlP" wrote in message news:5016deb9@solutions.advantagedatabase.com...
> Hi Mark,
>
> Thanks for the reply. I will try that test just to be sure. That is a
> good idea. As for modifcations, I am well aware having been bitten by
> that in VFP using the DBC and moving files from developement to
> production. I'll be careful.
>
> Regards,
> Carl
>
>
>
> --- posted by geoForum on http://www.newswhat.com