HDTenEightyP/NetNews huggingface dataset:
From: Yuriy G. Goron <yuriy@technopolice.zgrad.su>
Newsgroups: comp.databases
Subject: Re: Foxpro: Quicker Substring Search
Date: Fri, 22 Jan 93 23:24:47 +0200
Distribution: world
Organization: Technopolis Innovation Bank
Reply-To: yuriy@technopolice.zgrad.su

>           For Example...
>           I have a file with 20,000+ Records.  It contains Account
>           information.  Suppose the user wanted to search for
>           all accounts whose company name contained the string
>           "COM".
>
>           Right now I have it set up as follows:
>
>           Select AcctMast
>           Set Order to Tag AcctNum Of AcctMast
>           Set Filter to "CON" $ AccMast->AcctName
>           Browse NoEdit
>
Try this :
           SELECT <names of fileds> ;
           From AcctMast ;
           WHERE AcctName Like "%CON%" ;
           INTO CURSOR work
           Browse Noedit

Best regards
Yuriy Goron

Newsgroups: comp.databases
From: cpetersn@iastate.edu (Clifton R Peterson)
Subject: Re: pic or pick or pik (???)
Keywords: RDBMS, pic (?)
Organization: Iowa State University, Ames IA
Date: Mon, 25 Jan 1993 18:28:12 GMT

In <1993Jan25.170844.22967@ghost.dsi.unimi.it> paola@ghost.dsi.unimi.it (Paola Formai) writes:

>I was told about a Unix Rdbms named Pick (or Pic or Pik). I never heard of it.
>Anyone could explain me what is that stuff?

>Thanks

>paola@imiucca.csi.unimi.it

>Paola Formai
>CSI- Univ. of Milano, Italy

I've never worked directly with PICK, but I develop in an environment that
was derived from PICK.

PICK's main attributes are that it is based on variable length records with
the possibility of multi-variables within single fields of a record.  Each
record is essentially a string with different kinds of delimiters to determine
the end of a field, multi-value within a field, or even sub-value withing
a multi-value and so on.  The allows for easy database restructuring and
design, but suffers some in the speed department when compared directly to
fixed field/record length database environments.

PICK was originally designed as the operating system so that the speed was
regained as actions were OS and not on top of the OS.  I don't know how the
UNIX based PICK is set up exactly.

Things that it would be very good for is if you have lots of text fields in
you database, or even pictures or any data that might need to be long, but you
don't want to have to declare a maximum length of the field.


Remember, since I've never worked directly with PICK, some of what I just
said might not be exactly right, but hopefully will give you a general
idea of what it's about.
-- 
 _________________________________________________________________________
/ Clifton R. Peterson    1108 Burnett		(515)232-5254	    	  \
| B.S. Chem E            Ames IA  50010                                   |
\_______________"42"_is_one_hell_of_an_answer!!___________________________/
From: larry@dprmpt.UUCP (Larry)
Newsgroups: comp.databases
Subject: Recommendation for dBase III+ development system/libraries
Keywords: dBase development
Date: 26 Jan 93 07:29:07 GMT
Organization: Data-Prompt

I have an application originally written several years ago in dBase
III+ that has to be upgraded so it can become a commercial product.
Over the years it has been upgraded from a single-user to a
network-based system, supports various printers, etc.  In the current
system, all data is entered by an operator directly into the
application, but future requirements mandate the ability to handle
file input (not in a format that dBase "likes").

For several reasons I would like to convert from the dBase language 
to a high-level language (preferably C) for speed and maintainability.  
I'm looking for recommendations on development systems.  

My requirements are:
1.  I don't want to distribute source code (.exe files only).
2.  I need a way to read text (ASCII) files and extract data to
    populate the database (.dbf) files and update the indexes (.ndx).
3.  Executables produced must be royalty-free.
4.  Must be multi-user, support record locking, and run on a variety of 
    LANs (i.e.  we don't want to be tied to Novell, for example). 
5.  Windows support is a plus, but not required.
6.  Must be able to translate existing dBase language programs.

I've heard a little about CodeBase (Sequiter Software) and I thought I 
might have found just what I needed.  Then someone told me to check 
into CA-Clipper (Computer Associates).  I found a catalog that listed 
a few others, i.e. ARAGO (Wordtech Systems) and FUNCky II (dLESKO, Inc) 
that looked like they might also be candidates.

I'm confused and would appreciate hearing from anyone who's had
experience with these or other development systems.  Please E-mail and
I'll summarize to the net if there is interest.

Many thanks in advance.
-- 
* - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - *
* Larry Johnson                         VOICE:  (301) 622-0900          *
* INTERNET: larry@dataprompt.com        UUCP:   ...!uunet!dprmpt!larry  *
* - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - *
Newsgroups: comp.databases
From: twallace@gmuvax2.gmu.edu (Todd Wallace)
Subject: Re: dBASE executables
Organization: George Mason University, Fairfax, Va.
Date: Tue, 26 Jan 1993 01:07:20 GMT

Does anyone here know how to turn dBASE applications into
standalone executables for DOS?
Thanks.
----------------------------------------------------------------
|    Todd Wallace               |  "A pessimist is surprised   |
|    twallace@gmuvax2.gmu.edu   |   as often as an optimist,   |
|                               |   but always pleasantly."    |
|                               |            - Robert Heinlein |
----------------------------------------------------------------
Newsgroups: comp.databases
From: sridhar@cs.scarolina.edu (M. A. Sridhar)
Subject: Record handles in database engines
Keywords: Record handles, paradox, indices
Organization: USC  Department of Computer Science
Date: 26 Jan 93 22:30:23 GMT

I recently began some work with relational databases, and wrote a
little toy database engine. I assumed the model that every record
(tuple) in a table (relation) has a unique handle; this handle can,
for instance, be the disk offset at which the record is stored. The
key property is that the handle is _fixed_, independent of other
records. This allows me to build indexes and cross-indexes and the
like using the value of the handle in the index.

Then I found out that the Paradox engine does not use this model.
Specifically, it gives you a record _number_, not a _handle_; so if
you delete record number i, then the numbers of all subsequent records
are reduced by 1 automatically! This means that I cannot use the
record numbers it gives me for my own indexes, because the index will
be invalidated as soon as a single record is deleted. So I essentially
cannot build my own indexes -- I can only use Paradox's indexing
mechanisms. (Of course, I can get around this be remembering the
deleted record numbers and adjusting the contents extracted from the
indexes, but that's beside the point.)

I am quite surprised (really, shocked) by this behavior. I thought the
notion of a record handle was pretty standard in the database domain.
Am I wrong?  Do the other database engines such as Informix or FoxPro
support the notion of a record handle -- whose value is not affected
by other records in the table? Can one create one's own indexes other
than the mechanisms supported by these engines?

Thanks in advance for your info and comments.

Sridhar


--
M. A. Sridhar                  | 
Department of Computer Science | sridhar@usceast.cs.scarolina.edu (Internet)
University of South Carolina   | (803) 777-2427 (Ma Bell)      
Columbia, SC 29208             | (803) 777-3767 (Fax)
From: zzz@byron.u.washington.edu (Sample)
Newsgroups: comp.databases
Subject: FoxPro2.0 Questions
Date: 28 Jan 93 02:03:36 GMT
Article-I.D.: shelley.1k7etoINNr2v
Organization: University of Washington
NNTP-Posting-Host: 128.95.56.210

* Is there a way to Create a scrollable window
  in foxpro2.0 so that all my output goes to
  a scrollable window instead of being scrolled
  off the top of the screen?
  
* If there a way to have a project opened up
  automatically when foxpro is evoked?

If you can tell me more then please email
me here at zzz@byron.u.washington.edu
    Jeff
From: sm_rosen@ceres.rm.fccc.edu (Steve Rosen)
Newsgroups: comp.databases
Subject: Have you used these 4GL items?
Date: 25 Jan 93 13:51:18 GMT
Reply-To: sm_rosen@ceres.fccc.edu
Organization: Fox Chase Cancer Center - Phila, PA
Originator: sm_rosen@ceres.rm.fccc.edu


Anybody used these somewhat obscure 4GL-ish products under Motif and any
database?  I'd be curious to hear general comments.

        o SuperNOVA
        o SmartStar VISION
        o Uniface

Thanks in advance.  Also if you've evaluated them to any degree, I'd be
curious.  I application calls for multi-database, Motif GUI, DEC hardware,
etc.
-- 
         ___________________________________________________________
        /                                                           \
       / Steve Rosen                     Fox Chase Cancer Center    /
      /                                  7701 Burholme Ave.        /
     /   Internet: sm_rosen@fccc.edu     Philadelphia, PA 19111   /
    /    Phone:    (215) 728-3665                                /
    \___________________________________________________________/
Newsgroups: comp.databases
From: tim@src.cppa.utah.edu (Tim Ma)
Newsgroups: comp.databases
Subject: Re: Paradox question
Date: 27 Jan 93 23:18:31 GMT
Organization: University of Utah

[stuff deleted ...]

>>> 2) I can Ask to my heart's content and it works fine, but getting a 
>>> report on the result is a pain .. I have to COPY a report type to
>>> the Answer table by hand every time I create a new Answer .. is there some 
>>> way to make this stick .. I tried copying Answer over an old table to
>>> which I had already attached a report, but that seems to lose the report 
>>> already attached.
>>
>>That's fundamental to the way Paradox works.  Forms and reports are
>>associated with particular tables.  Every time you Ask a query, you
>>create a brand new Answer table, deleting any Answer table that was
>>sitting in your current working directory.
>>
>>The way I worked was, for reports I wanted to produce often, to keep a
>>second table (I referred to it as a 'skeleton table' but this
>>terminology is strictly non-standard!) which has exactly the same
>>structure as the Answer table I wanted to report from, but no data in
>>it.  Use this second table to design reports, forms etc.  Every time
>>you do a query and want to use one of the reports or forms, do a F10
>>Tools Copy Justfamily "skeleton" "Answer".
>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>
>I believe "Copy" overwrites the table and could hose your reports....it
>is safer to empty "skeleton", add "answer" "skeleton" from a script ...
>that way you know exactly what is in the skeleton table at all times.

No, Mary was right.  The "JustFamily" option will copy only the forms,
reports, validity checks, etc.  Everything except the data in the 
the "skeleton" table will be copied.

>
>>(I'm guessing that you're more interested in manipulating your data
>>than in creating applications to assist in entering or reporting on
>>it.  If this is not true, then some other methods may be more
>>appropriate.)  

Perhaps a SETKEY macro could relieve you of some tedious keystrokes.

>>-- 
>>\   \/   /  |  
>> \/\/\/\/   |  mary.curtin@bbs.actrix.gen.nz
>>
>
>-Bob-
>
>Bob Angell                               | Data Integration (multi-platform)
>Principal, Management Systems Engineer   | Health Systems Engineering
>Applied Information & Management Systems | Database design/development
>1238 Fenway Avenue - SLC, UT 84102-3212  | Simulation/Modeling/Neural Nets
>bangell@cs.utah.edu; Voice: 801-583-8544 | Product Reviewer-Major Publication
>
>     [Standard Disclaimer: Speaking for the University of Utah, NOT!]

Tim Ma
Associate Programmer
University of Utah
Email:  tim@src.cppa.utah.edu
Xref: sparky comp.databases:9441 comp.sys.ibm.pc.misc:17140
From: wdieteri@wrdis01.af.mil (Will Dieterich)
Newsgroups: comp.databases,comp.sys.ibm.pc.misc
Subject: Help converting Clarion databases
Date: 27 Jan 93 14:12:15 GMT
Followup-To: comp.databases
Distribution: usa
Organization: 1926CCSG Robins AFB

I am looking for a program to convert Clarion version 2.1 databases files, to
text files or to dbase files.  If you know of a ftp site that has such a
program please e-mail me.



Thanks,


 Name:   Will Dieterich                             Call Sign: KD4LZE
 E-Mail: wdieteri@wrdis01.robins.af.mil
"Hello Microsoft Customer Support.  Please hold for an hour." -- MST3K
Newsgroups: comp.databases
From: aahz@netcom.com (Mean Green Dancing Machine)
Subject: Re: Paradox questions
Organization: Don't blame me, I voted for Bill 'n' Opus
Date: Fri, 22 Jan 1993 13:00:52 GMT

In article <2280@blue.cis.pitt.edu> field@.cs.pitt.edu.cs.pitt.edu (Brian Field) writes:
>
>Two questions regarding Paradox 4.0.
>
>1) I'm writing a script that changes the field types of several fields in a
>	table.  Since I couldn't figure out how to do this directly from the
>	manual, I recorded a script where I manually changed the file types,
>	and checked out the script.  The script looks something like this:
>
>	{Modify} {Restructure} {table_name} Down Down Down .....
>	Right Right Backspace Backspace "A8"

To do this generally:
  {Modify}{Restructure} select TabName right
  LOCATE FName right [] = NewType

>2) 	How does one access the contents of a field name that have been passed
>	as an arguement to a procedure?  Do I need to use EXECUTE to do this,
>	or is there an alternative?

  MOVETO FIELD FName x=[]
-- 
                         --- Aahz (the *other* Dan Bernstein)
                             @netcom.com 

Hugs and backrubs -- I break Rule 6

Red shirts finish faster.
From: torbecvs@ucbeh.san.uc.edu
Newsgroups: comp.databases
Subject: What is Sybase anyway?
Date: 23 Jan 93 18:11:44 EST
Distribution: world
Organization: Univ. of Cincinnati

	I feel sort of foolish to ask this question, but how else are you 
        going to learn?
        Right!?

	What is Sybase?

	Thank You for your support.
Newsgroups: comp.databases,comp.os.ms-windows.programmer.misc,alt.lang.basic
From: misha@abacus.uucp ( MISHA GLOUBERMAN )
Subject: Agility/VB users?
Organization: Cicma, Concordia University, Montreal, Quebec
Date: Tue, 26 Jan 1993 00:14:33 GMT

 
I am using the Agility/VB database extension for Visual Basic to
work on a bookkeeping application.
 
Apex software, the publisher of the package, currently provides some
support services and fixes on CompuServe.
 
I have talked to them briefly about putting these files up on the Net
somewhere. Right now, they are hesitant, as they don't know if they
have many users who would benefit from this.
 
If you are an Agility/VB user and would like to see support files
for the product available through FTP, please send me E-mail. If there
are enough people who would like to see these files available, I'm
sure the people at APEX would be willing to help us out.
 
I should point out that I know very little about uploading files
to anonymous FTP sites. I am assuming that it isn't too
hard, but have no idea how these sites are moderated. Information
on this subject would be appreciated as well.
 
                                Misha Glouberman
                                misha@abacus.concordia.ca
From: eross@uwovax.uwo.ca
Newsgroups: comp.databases
Subject: Re: clarion 3.0 => 2.1 compatibility
Date: 28 Jan 93 04:06:48 GMT
Distribution: comp.databases
Organization: University of Western Ont, London

In article <ETOAJ.93Jan27110514@storeulv.etn.ericsson.se>, etoaj@storeulv.etn.ericsson.se (Are Jrgensen) writes:
> 
> I have recently received some information about clarion 3.0 from the
> Norwegian distributer, but it do not claims that 3.0 will be able to read
> and compile applications written in 2.1  It does not claim the
> conterary either, but it makes one wonder.....
> 
> Does anybody have information about this??
> 
> Regards
> Are

Logix Development Corp (makers of LPM) is in the midst of writing an APP
converter for 3.0.  The one hitch is that the language has changed somewhat, so
if you have entered code in to Setup or Next Procedure or validate entry
fields, it will not convert with out some adjustments.  The converter is not
included in the pre-release (which I'm still playing with) but will be shipping
with the final release.
-- 
-------------------------------------------------------------------------------
Evan Ross
-------------------------------------------------------------------------------
Western Foot Patrol, University of Western Ontario, Lambton Hall,
1421 Western Rd., London, Ontario, N6G 4W4
(519) 661-3650	 Fax (519) 661-3687
Newsgroups: comp.databases
From: steinman@hslrswi.hasler.ascom.ch (Jan Steinman,- Bytesmiths -,Tel x3946)
Subject: OODBMS Traffic (really, Phyla)
Reply-To: steinman@hslrswi.hasler.ascom.ch
Organization: Ascom Hasler AG
Date: Tue, 26 Jan 1993 16:00:07 GMT

Well, it seems there is not enough traffic to justify an OODBMS newsgroup. The
only reason I read this group is to scan for OODBMS stuff, so I'd suggest that
anyone with OODBMS interests begin generating traffic! In that spirit...

Has anyone got a peek at Mainstay's new OODBMS for the Mac, "Phyla"? Is it a
"real" OODBMS, or merely an object front-end glued onto some ancient
technology, such as relational or hierarchical.

I've had considerable experience gluing objects onto relationals, and it
isn't the smoothest fit in the world!

: : Jan Steinman, Bytesmiths			   steinman@hasler.ascom.ch : :
: : 2002 Parkside Court, West Linn, OR 97068-2767 USA	    +1 503 657 7703 : :
: : Beundenfeldstrasse 35, CH-3013, Bern, Switzerland	    +41 31 999 3946 : :

Lines: 34
Date: Wed, 27 Jan 93 17:08:12 MST
From: ron@bert.cs.byu.edu (Ron Snyder)
Organization: BYU Computer Science
Newsgroups: comp.databases
Subject: Re: Paradox question
	<1993Jan24.144529.19009@nuscc.nus.sg>
	<1993Jan27.110322.1326@actrix.gen.nz>
	<1993Jan27.090537.17710@hellgate.utah.edu>

   >it.  Use this second table to design reports, forms etc.  Every time
   >you do a query and want to use one of the reports or forms, do a F10
   >Tools Copy Justfamily "skeleton" "Answer".
   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

   I believe "Copy" overwrites the table and could hose your reports....it
   is safer to empty "skeleton", add "answer" "skeleton" from a script ...
   that way you know exactly what is in the skeleton table at all times.

When you Copy JustFamily, it leaves the destination table (in this 
case, the answer table) alone, and just replaces any forms and reports
that existed for the answer table.  As to your other advice, in general
is a better idea to not empty "skeleton" and then add "answer" "skeleton",
because of the time involved in this procedure, especially when there is
a large amount of data that would have to be moved.  I have seen
several suggestions from the 'experts' to do a 

     copyreport "skeleton" "1" "answer" "1"
     report "answer" "1"

when this will do what is needed.  (Of course, you would have to pick
your own table names and report numbers.)  The advantage that this
method has over doing a "Copy JustFamily" is that if "skeleton" has
a lot of reports and forms, then that extra baggage stays where it
is, and you only copy the report that you want.






--
Ron Snyder <ron@bert.cs.byu.edu>   <snyderrj@coned1.byu.edu>
****************************************************************
Newsgroups: comp.databases
From: landers@comm.mgmt.purdue.edu (Chris Landers)
Subject: CLIPPER (S'87) Inkey() values for Alt-Keys
Summary: Here's the table the docs left out....
Date: Tue, 26 Jan 1993 20:46:44 GMT
Organization: Krannert Graduate School of Management, Purdue University


ATTN: CLIPPER USERS:

The manual S'87 says inkey() returns values for alt-letter keys,
and claims the values can be found in the appendex.  In fact, the 
appendix mearly contains values for function, shift-function,
ctrl-function, alt-function, SOME ctrl-letter keys, and a standard 
ASCII table.  _NO_ listing of alt-letter key values.

I wrote a quick program to trap the alt-letter key values and
below are the results.  Since I spend an hour or so on this I thought 
I'd share it and maybe save you some time too.  My goal was to
assign a procedure to alt-E, which I have been able to do.

humm... I just noticed that my manual at work is S'87, while my manual at 
home has the '88 update pages, this may be part of my problem....)
Anyway, the manual (again S'87) says inkey() return values range from 
-39 to 386, where the negative numbers are for function keys.
You'll notice that 386-255=131 and the table below has only 26 values on it.
Anyone else know what are the other values for > 255 ??

Also, anyone know why these aren't in sequence?  Looks to me like
they just go across the keyboard rather than through the char set.

Alt-A = 286
Alt-B = 304
Alt-C =   0   * I couldn't get a response here, even with setcancel()
Alt-D =   0   * and alt() both off, my guess is inkey() ignores these....
Alt-E = 274
Alt-F = 289
Alt-G = 290
Alt-H = 291
Alt-I = 279
Alt-J = 292
Alt-K = 293
Alt-L = 294
Alt-M = 306
Alt-N = 305
Alt-O = 280
Alt-P = 281
Alt-Q = 272
Alt-R = 275
Alt-S = 287
Alt-T = 276
Alt-U = 278
Alt-V = 303
Alt-W = 273
Alt-X = 301
Alt-Y = 277
Alt-Z = 300

=============================================================================


    <================================><=================================>
    ||  Christopher Landers          ||  Purdue University - KRAN 708  ||
    ||  Krannert Computing Center    ||  West Lafayette, IN  47907     ||
    <=================== landers@comm.mgmt.purdue.edu ==================>

Newsgroups: comp.databases
From: knispel@eig.unige.ch
Subject: Re: C source or LIB for database access wanted.
Organization: University of Geneva, Switzerland
Date: Tue, 26 Jan 1993 06:00:54 GMT

In article <1993Jan19.154202.9778@kth.se>, regebro@stacken.kth.se (Lennart Regebro) writes:
> I need C source or LIB's for accessing databases under MS C or Unix.
> Portable code is vastly preferred.
> 
> Thanks
> -- 
> Lennart Regebro             regebro@stacken.kth.se
> Stacken Computer Club       +46-8 649 18 51
> Don`t call before calculating my local time, please. This is GMT +1.

I have two solutions for U. First public domain DB managers for Windows.
These are avalable with source code (in C), so if U subscribe U could try
to port one on Unix. I have seen one (I think in has at cica).

Second solution : CodeBase v4.5 or 5.0 (5.0 in february).
Code Base is also with full source and it is designed to compile on Unix.
CodeBase allows access on DBase file (with index), Clipper+NTX and FoxPro
indexed files.

If you need information U should look into Byte under SEQUITER anouncer.

Cheers 
    Sven

================================================================
KNISPEL@EIG.UNIGE.CH