Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: William Sanders
  Where is William Sanders?
 Texas - United States
 William Sanders
 To: Marlon Levy
  Where is Marlon Levy?
 Marlon Levy
Subject: RE: Sys(2000) Error running SCO unix
Thread ID: 78431 Message ID: 78504 # Views: 1 # Ratings: 0
Version: FoxPro 2.x for MSDOS Category: Databases, Tables and SQL Server
Date: Tuesday, October 04, 2005 5:04:04 PM         

> I am having a bit of a problem running sys(2000) wild card file match on tinyterms' SCO UNIX emulator.
> all i wan to do is to search a directory for any file with a particular field and change the value in that field.
> well actually i am just trying to change a custmoer number for all the tables that store this number.
> help Please
> Marlon Levy
> marlonlevy@gmail.com

Yo Marlon - I don't understand the problem as stated -
but - some things to do:
1. run through files w/wintel tools on SCO file systems - map a drive from a wintel box to the sco box, and start the search with a tool running on the wintel box.
2. ok - unix emulator from tiny term is same thing as a Terminal Emulation Program - there is a set of shell commands u can use that works - try a combination of ls -lR , pipe [|] , grep , input redirect [<] output redirect [>] to come up with something like -
ls -lR > grep fieldname % > output_list

then the output list should have the list of files that contain the field value.

if you don't like using shell commands then install MC (midnight commander) on that sco box - and let it do the work for you. If you are running a linux box, mc is already installed.

3. make up a samba share on the sco box, map a drive like in #1, and then start your search. If you don't want to mess up any dbf table formatting, utilize dbf2002 viewer from http://www.dbf2002.com . It will help you (from a wintel box) to make changes in table data without screwing up the native file format.

lemme know how it works out. I like playing with unix / linux boxes - its been 13 years now... hth - mondo regards [Bill]
William Sanders / Electronic Filing Group


Sys(2000) Error running SCO unix Posted by Marlon Levy @ 10/3/2005 6:01:11 PM
RE: Sys(2000) Error running SCO unix Posted by Ken Murphy @ 10/3/2005 6:24:42 PM
RE: Sys(2000) Error running SCO unix Posted by William Sanders @ 10/4/2005 5:04:04 PM