Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 To: Patrick McGreevy
  Where is Patrick McGreevy?
 Clarksville
 Tennessee - United States
 Patrick McGreevy
 Tags
Subject: RE: Access Oracle database with compression
Thread ID: 196337 Message ID: 196471 # Views: 26 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Friday, September 26, 2008 9:02:20 PM         
   


> I have a problem accessing a database at work which provides numerous codes for different applications, this used for creating supply catalogs and such.
>
> The program I am talking about has just been taken over by a new contractor. The new company has moved everything to an Oracle 10g database.
>
> The prog was designed for operation in the field, using, for the most part, laptop computers. So the design was to store all the data files in compressed files, utilizing a compression format that is not Microsoft.
>
> The company did, however, supply a .exe file to run batch files against the database. Each month, I run approximately 220K part numbers against it to pull price, turn-in credits, etc for each line and post this to an internal VFP table that I use for daily processing.
>
> This utility has to be run from the Windows Command window, in a batch file. It does not allow for joins, or many other SQL commands I am used to.
>
> I guess I actually have two quesions:
>
> 1. When I run the batch, the black command window echo's 'FAMM SQL'. Does this ring a bell in someone's memory? Might give me some idea what type of compression algorithm they are using.
>
> 2. We are still running under Windows XP. Are the command prompt commands still supported under Windows Vista(which we will be moving to shortly)?
>
> Any input would be appreciated.
>
> Pat


Afternoon from Canada,
FAMM I believe has something to do with memory alocation and I do not believe it is a compression method.
My Vista machine seems to have all the command window command I have in XP.

Pete "the IceMan", from the Great White North of Canada.



COMPLETE THREAD
Access Oracle database with compression Posted by Patrick McGreevy @ 9/26/2008 2:06:26 AM
RE: Access Oracle database with compression Posted by Pete Sass @ 9/26/2008 9:02:20 PM
RE: Access Oracle database with compression Posted by Patrick McGreevy @ 9/27/2008 11:44:58 PM