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.

trying to access VFP files over 2 gig on the Command line in VFP

2 posts in FoxPro Last posting was on 2012-07-06 20:14:01.0Z
Ken Posted on 2012-07-06 14:25:08.0Z
From: "ken" <kenk@appliedinfogroup.com>
Newsgroups: Advantage.FoxPro
Subject: trying to access VFP files over 2 gig on the Command line in VFP
Date: Fri, 6 Jul 2012 10:25:08 -0400
Lines: 35
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.5512
NNTP-Posting-Host: 208.216.217.150
Message-ID: <4ff6f4d4$1@solutions.advantagedatabase.com>
X-Trace: 6 Jul 2012 07:23:16 -0700, 208.216.217.150
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.FoxPro:383
Article PK: 1109737

I have Adv Data Archetect (ADA) installed and have the ODBC driver
installed.

ADA appears to be working properly. The problem I'm having is that I can

open a Visual Fox Pro version 9 file that's close to the 2 gig limit in ADA

and add some records to it pushing it over the 2 gig limit and close the
file in ADA.



I then try and open it on the command line in VFP using the USE command and

I get a message that it's not a table. Yet before I added the records to it

in ADA I was able to open the file on the command line in VFP.



What am I doing wrong? Should I use the USE command or do I need to access

the file using another method?



Thanks.


Mark Wilkins Posted on 2012-07-06 20:14:01.0Z
From: "Mark Wilkins" <a@b.c>
Newsgroups: Advantage.FoxPro
References: <4ff6f4d4$1@solutions.advantagedatabase.com>
In-Reply-To: <4ff6f4d4$1@solutions.advantagedatabase.com>
Subject: Re: trying to access VFP files over 2 gig on the Command line in VFP
Date: Fri, 6 Jul 2012 14:14:01 -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: <4ff74697$1@solutions.advantagedatabase.com>
X-Trace: 6 Jul 2012 13:12:07 -0700, 10.6.193.219
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.FoxPro:384
Article PK: 1109738

Answered here:

http://stackoverflow.com/questions/11313857/using-foxpro-tables-and-advantage-data-architect/11364877#11364877

"ken" <kenk@appliedinfogroup.com> wrote in message
news:4ff6f4d4$1@solutions.advantagedatabase.com...
> I have Adv Data Archetect (ADA) installed and have the ODBC driver
> installed.
>
> ADA appears to be working properly. The problem I'm having is that I can
>
> open a Visual Fox Pro version 9 file that's close to the 2 gig limit in
> ADA
>
> and add some records to it pushing it over the 2 gig limit and close the
> file in ADA.
>
>
>
> I then try and open it on the command line in VFP using the USE command
> and
>
> I get a message that it's not a table. Yet before I added the records to
> it
>
> in ADA I was able to open the file on the command line in VFP.
>
>
>
> What am I doing wrong? Should I use the USE command or do I need to access
>
> the file using another method?
>
>
>
> Thanks.
>
>
>
>
>
>
>
>