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.

Working with Databases that are ADT and have DD

2 posts in FoxPro Last posting was on 2012-06-18 16:40:02.0Z
John Posted on 2012-06-16 12:24:13.0Z
Date: Sat, 16 Jun 2012 08:24:13 -0400
From: John <donotsendmeemail@totallybogusemailaddress.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.17) Gecko/20110414 Thunderbird/3.1.10
MIME-Version: 1.0
Newsgroups: Advantage.FoxPro
Subject: Working with Databases that are ADT and have DD
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 120616-0, 06/16/2012), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 68.84.142.145
Message-ID: <4fdc7a75$1@solutions.advantagedatabase.com>
X-Trace: 16 Jun 2012 05:22:13 -0700, 68.84.142.145
Lines: 34
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.FoxPro:381
Article PK: 1109735

Advantage has so many options and is so flexible that sometimes it's
hard to understand how to (or the best way) do something. So I will ask
here. :)

If I have an Advantage Database with a Data Dictionary and all ADT
tables (all ADS proprietary stuff, including ADT field types and things
that are not supported in any type of DBF) I need to know if it is
possible for a user to work with this data from Visual FoxPro 9.

The user would need to query data, perform updates, etc. No table or
database maintenance. This would be somewhat technical users that know
how to work with the data to tweak it. I'm not talking about the
average desktop app user here.

I know ARC is the preferred tool, but many of our users are experienced
with FoxPro. Of course they do things like BROWSE and make changes that
way in FoxPro; is that even possible to do with a connection to a DD
from FoxPro?

Is this possible and what is the best way for them to connect? Can you
reference a KB article or something showing how to make this connection?
I assume it's an OLE DB Provider connection that would be used?

ARC is nice, but I think it has some bugs. Seems like every time I use
it some kind of bug appears. Don't get me wrong, I have been an
Advantage user for over 15 years, starting in Clipper and then using it
from C#. It's a great product line but I think ARC could use a little
work. We have never used the proprietary ADT stuff, only DBF's. As we
move into the world of ADT we're a bit uncomfortable with the lost of
some of our DBF maintenance flexibility that we've had for 20 years.
When the boss asks me how we're going to maintain this new database
created using proprietary DD technology, I need to have a plan. :)


Mark Wilkins Posted on 2012-06-18 16:40:02.0Z
From: "Mark Wilkins" <a@b.c>
Newsgroups: Advantage.FoxPro
References: <4fdc7a75$1@solutions.advantagedatabase.com>
In-Reply-To: <4fdc7a75$1@solutions.advantagedatabase.com>
Subject: Re: Working with Databases that are ADT and have DD
Date: Mon, 18 Jun 2012 10:40:02 -0600
Lines: 1
Organization: Sybase
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
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: <4fdf59a8@solutions.advantagedatabase.com>
X-Trace: 18 Jun 2012 09:39:04 -0700, 10.6.193.219
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.FoxPro:382
Article PK: 1109736

Hi John,

It is probably possible to do some basic table maintenance of ADTs through
FoxPro (e.g., with cursor adapters). But I *think* it would be necessary to
write code to make it work. The DataExplorer.app allows you to easily get
to tables for browsing. Information for doing that:

http://devzone.advantagedatabase.com/dz/webhelp/Advantage10.1/index.html?master_cursor_adapters.htm

However I don't think it is possible to edit the data when using that
utility ... or rather, more accurately, I don't know how. To edit data with
a "browse" command, I had to write code to create a cursor adapter and then
specify the UpdatableFieldList property so that it could generate the UPDATE
statements appropriately.

So for general purpose maintenance, I still think your best bet is still
going to be with Advantage Data Architect.

Mark Wilkins
Advantage R&D

"John" <donotsendmeemail@totallybogusemailaddress.com> wrote in message
news:4fdc7a75$1@solutions.advantagedatabase.com...
> Advantage has so many options and is so flexible that sometimes it's hard
> to understand how to (or the best way) do something. So I will ask here.
> :)
>
> If I have an Advantage Database with a Data Dictionary and all ADT tables
> (all ADS proprietary stuff, including ADT field types and things that are
> not supported in any type of DBF) I need to know if it is possible for a
> user to work with this data from Visual FoxPro 9.
>
> The user would need to query data, perform updates, etc. No table or
> database maintenance. This would be somewhat technical users that know
> how to work with the data to tweak it. I'm not talking about the average
> desktop app user here.
>
> I know ARC is the preferred tool, but many of our users are experienced
> with FoxPro. Of course they do things like BROWSE and make changes that
> way in FoxPro; is that even possible to do with a connection to a DD from
> FoxPro?
>
> Is this possible and what is the best way for them to connect? Can you
> reference a KB article or something showing how to make this connection? I
> assume it's an OLE DB Provider connection that would be used?
>
> ARC is nice, but I think it has some bugs. Seems like every time I use it
> some kind of bug appears. Don't get me wrong, I have been an Advantage
> user for over 15 years, starting in Clipper and then using it from C#.
> It's a great product line but I think ARC could use a little work. We
> have never used the proprietary ADT stuff, only DBF's. As we move into
> the world of ADT we're a bit uncomfortable with the lost of some of our
> DBF maintenance flexibility that we've had for 20 years. When the boss
> asks me how we're going to maintain this new database created using
> proprietary DD technology, I need to have a plan. :)
>
>