HDTenEightyP/NetNews huggingface dataset:
From: durai@ortta.umn.edu (Durai Venkatasubramanian)
Subject: Re: FoxPro: Help needed with scrollable windows
Organization: U of Mn
Date: Thu, 7 Jan 1993 22:47:24 GMT

In article <C0I7nF.H3G@unccsun.uncc.edu> alsimmon@uncc.edu (Amber Leigh Simmons) writes:

>I am currently working on a program in FoxPro for a large hospital
>in my area.  I want to be able to implement my forms so that they 
>can be larger than the screen.  Therefore I need to have window 
>which act like the FoxPro system windows with scroll bars across
>the top and bottom, to scroll around the form.  I know this can be
>done because I have seen an application using this concept.


1. If your window has to be necessarily larger than the screen, you can 
   define a window of any size and control as you want.  But manipulating 
   the window (using controls) will be a very big hassle.  If you are using 
   the screen generator, you cannot use the system window controls for too 
   large a window size.  I think you can go upto 27*82.  

2. I would suggest that you use multiple windows, coordinated with one 
   single read.  This will enable the user go up and down as they wish.
   This is not only easy to define, but also easy to maintain.  Foxpro 
   screen generator can handle the code.

Newsgroups: comp.databases
From: rgams@magnus.acs.ohio-state.edu (Richard A Gams)
Subject: Re: db_vista database? What is it, and are there any report gens. for
Organization: The Ohio State University
Distribution: na
Date: Fri, 8 Jan 1993 23:30:20 GMT

db_Vista is now known as Raima Data Manager.  It is a system that uses the 
extended network data model which involves setting up owner/member set 
relations.  There is a report writer called db_Query that uses a form of SQL.  
If it is a "btrieve" format database, then it's not db_Vista.  Please let me 
know if I can help you figure this out.

-- Dick Gams, gams.1@osu.edu
From: steve@soi.com
Newsgroups: comp.databases
Subject: Do you use IBM's Relational Design Tool?
Date: 7 Jan 93 21:23:59 GMT
Article-I.D.: das.1993Jan7.212359.11696
Followup-To: steve@soi.com
Organization: Courant Institute, New York University

Do you use IBM's Relational Design Tool for SQL/DS?

If you use or have used IBM's Relational Design Tool
I would like very much to hear about how you use(d) it.

What is your overall judgment of the product's utility?

What are its major advantages?  Disadvantages?

How good are the designs it produces?

How well does it do on complicated schemas?

What would be the most useful improvement that could be made to it?

I will summarize if interest warrants.

Thank you,

Steve

---------------------+---------------------------------------------------------
Steve Rozen          | steve@soi.com   {harvard,uupsi}!soi!steve
SOI                  | 617-497-5054
22 Hilliard Street   | 
Cambridge MA 02138   |
USA                  |
From: mmap+@andrew.cmu.edu (Michele L. Moe)
Newsgroups: comp.databases
Subject: Foxpro 2.0 patch for Lantastic?
Date: 12 Jan 93 22:30:24 GMT
Organization: Doctoral student, English, Carnegie Mellon, Pittsburgh, PA

We have a communication from Artisoft, the developer of Lantastic,
that a patch is needed for FOXPRO 2.0 if it is to run correctly
under Lantastic.  This patch is supposedly to correct an error
message saying "System resource exhausted".   We called Fox/Microsoft
and no one in customer support had any information about this patch.

Does anyone know anything about this patch's existence/non-existence?
We are wondering if this is just a problem with dos SHARE /f /l switch
settings being to low?

Thanks for any help you can provide.
From: nadsap@violet.ccit.arizona.edu
Newsgroups: comp.databases
Subject: dbase compatible objects for visual basic?
Date: 11 Jan 93 18:12:10 GMT
Distribution: world,local
Nntp-Posting-User: nadsap


Can anyone recommend a good dbase compatible object set for visual basic?
Basically I would like to read and write dbase files from a visual basic
application.

Thanks
Mike
NADSAP@CCIT.ARIZONA.EDU
Newsgroups: comp.databases
Subject: Re: Arev 3.01
From: D.M.Todd@massey.ac.nz (D.M. Todd)
Date: Mon, 11 Jan 93 03:49:13 GMT
Organization: Massey University, Palmerston North, New Zealand
Keywords: Revelation FAQ proposal
Summary: Couple of questions
X-Reader: NETNEWS/PC Version 2c

I would second the idea of a Revelation FAQ.  (And it is not just
because my first name is also David and I am also currently in
Palmerston New Zealand!  My residence here is only temporary, and
I've never met David A.).

Newsgroups: comp.databases
From: welling@let.rug.nl (George Welling)
Subject: Re: HELP - HELP : CLIPPER BUG ???!!
Followup-To: Clipper-Bug 
Keywords: Clipper
Organization: Faculteit der Letteren, Rijksuniversiteit Groningen, NL
Date: Wed, 6 Jan 1993 13:50:35 GMT

This is not a special Clipper bug. Comparing the results of transactions with
REAL's is always a problem, since REAL's are represented as approximations in 
binary format. You can only make good comparisons with INTEGERS. You could
solve your problem by multiplying all figures by 100 and then treat them as
INTEGERS.


Newsgroups: comp.databases
From: durai@ortta.umn.edu (Durai Venkatasubramanian)
Subject: Re: Pls help: algorithm wanted (xbase, pref foxpro)
Organization: U of Mn
Date: Mon, 4 Jan 1993 22:24:37 GMT

In article <1993Jan4.201319.9088@almserv.uucp> g9utxu@fnma.COM (Tanin Uthayanaka) writes:

>I beleive I made the same mistake on my first version, then I corrected it on my 
>second version with one bug which no one has found yet.


I really appreciate the time and effort Tanin and Tom have taken to help me (
and others, probably) out.  I am yet to translate(!)  Tom's code to foxpro.

Just to set the records straight, I would like to share the results of 
running Tanin's code.  No offence please.   I am not here to point out bugs 
or inefficient coding, but just to acknowledge the fact about how the code 
works.  

Records in my rate.dbf

Rate  Start_date   End_date   Status
01    07/01/91     06/30/93   Provisional
02    07/01/92     06/30/93   Final
03    07/01/93     12/31/93   Provisional


Test data 1:  dstart = 01/01/92, dend = 01/06/93

Results:  01/01/92 - 12/31/93  Provisional
          01/01/94 - 01/06/93  Uncovered

whereas, the results should have been
          01/01/92 - 06/30/92  Provisional
          07/01/92 - 01/06/93  Final

Test data 2: dstart = 07/01/91, dend = 12/31/93

Results: 07/01/91 - 06/03/93  Provisional
         07/01/92 - 06/30/93  Final
         07/01/93 - 12/31/93  Provisional
         01/01/94 - 12/31/93  Uncovered

whereas, the last line should not have even appeared, forget the 
error (12/31/93).  I amended the code a little bit, and eliminated 
the last line.  

The code works fine as long as the records in the database match the dstart 
and dend variables.  Most of the times, the contract periods either start 
before, or end after, the rate agreement dates.  These algorithms tend to 
ignore the fact.

Anyway, I am really thankful to Tanin and Tom, for giving me a sense of 
direction as to how to approach this issue.

Newsgroups: comp.databases
From: ortiz@edmund.cs.andrews.edu (Victor Ortiz)
Subject: IQ + MF Cobol + Variable Length Records?
Organization: Andrews University
Date: Wed, 6 Jan 1993 22:01:28 GMT

People:
  If there is anyone out there using Intelligent Query with MF/Cobol 2 could
you please tell me if you use variable length records in your data dictionary
and how?

Thanx, Victor Ortiz
[ortiz@edmund.cs.andrews.edu]
From: an662@cleveland.Freenet.Edu (Michael Leach)
Newsgroups: comp.databases
Subject: re:  comp.databases.xbase
Date: 6 Jan 1993 13:15:53 GMT
Organization: Case Western Reserve University, Cleveland, Ohio (USA)
NNTP-Posting-Host: hela.ins.cwru.edu


I'm definitely in favor of a comp.databases.xbase.

Mike Leach
Programmer/Analyst
University of Cincinnati
an662@cleveland.freenet.edu
leachmj@uc.edu
Xref: sparky comp.databases:8828 comp.lang.c:19269
From: BOB@ysub.ysu.edu (Bob Quigley)
Subject: form driven QBE
Organization: Youngstown State University
Date: Mon, 11 Jan 1993 22:07:48 GMT

I'm looking for a database with a QBE search feature that will allow me
to display a customized query screen and search the database on either
exact matches or "record contains" type matches. This is going to be used
by a local volunteer fire department to assist in dispatching. If a partial
address or phone number is given likely records can be displayed and/or
printed. (We currently have PARADOX 4.0)
 
Any help will be greatly appreciated!
 
Bob Quigley (bob@ysu.edu)
Youngstown State University
From: dliao@aludra.usc.edu (David Liao)
Newsgroups: comp.databases
Subject: Paradox Engine 3.0/Database Framework
Date: 9 Jan 1993 19:06:01 -0800
Organization: University of Southern California, Los Angeles, CA
Distribution: world
NNTP-Posting-Host: aludra.usc.edu

	Borland recently released Database Framework which is supposed to
encapsulate Paradox Engine's functions.  I believe the Database Framework 
will offer more than just PE encapsulations that will make PE programmer's 
life a bit easier.

	I ordered the Paradox Engine 3.0/Database Framework last week.  But
from hearing some complains from the PE programmers on the net, I have doubt
about using the product.  Hopefully, Database Framework will change all that.
It's strange that Paradox Engine has not become as popular as other Borland
products after more than two years of release.  

	I have been looking around last six months for a database engine
platform that I can write with either C or C++.  I found Paradox Engine
and another product called CodeBase.  I didn't hear too much about CodeBase.
Paradox Engine was in the vicinity of unknown as well.  Can some recommend
other database engine?  I am not looking for Clipper and Foxpro, because I
think they lack the speed and flexibility of programming in C unless someone
can prove me wrong :)

	BTW, I hope to hear from other Paradox Engine programmers on this
newsgroup.  I could not find any relevant source, discussion or book relating
to the Paradox Engine.  It seems like all Paradox Engine programmers are 
stranded on an island with their superb Paradox Engine documentation.


David Liao
dliao@aludra.usc.edu
University of Southern California

Newsgroups: comp.databases
From: cpetersn@iastate.edu (Clifton R Peterson)
Subject: Re: Arev 3.01
Keywords: Revelation FAQ proposal
Organization: Iowa State University, Ames IA
Date: Mon, 11 Jan 1993 04:37:14 GMT

A revelation FAQ would be a good idea, but...

I'm not sure we have enough traffic on here to make it worthwhile.  I don't
have the time to build it up myself.  Most of the questions traffic is
definitely on Compuserve.  I've suggested several times that Revelation
Technologies do this for CI$ and then we'd be able to also put it up
here.  Scott, how does the HR sale affect your?,  Good, Bad?

Clif
-- 
 _________________________________________________________________________
/ Clifton R. Peterson    1108 Burnett		(515)232-5254	    	  \
| B.S. Chem E            Ames IA  50010                                   |
\_______________"42"_is_one_hell_of_an_answer!!___________________________/
Newsgroups: comp.databases
From: des@helix.nih.gov (David E. Scheim)
Subject: Microsoft SQL Server and TCP/IP
Organization: NIH
Date: Tue, 5 Jan 1993 22:01:07 GMT

We wish to access an OS/2 Microsoft SQL Server v. 4.2a (on Lan Manager 2.1)
via TCP/IP.  The server is running Microsoft's TCP/IP.
Our database server has been working fine accessed via named pipes, using
SAF and JYACC's JAM as front ends, and we wish to know how to access the
database via a workstation running either Microsoft or FTP TCP/IP.
Specifically, we would like to run, for example, SAF or ISQL.  Also, we'd
like to compile a version of JAM for access via TCP/IP, but I assume we may
need some additional help from JYACC's tech support to do this.
Is this what SQL bridge does, and if so, how do we obtain it?  Does it come
standard with SQL server?

Thanks for the information.

/*********************************************************************/
/*                      --- David E. Scheim ---                      */
/* BITNET: DES@NIHNEI31                                              */
/* INTERNET: desl@helix.nih.gov          PHONE: 301 496-2194         */
/* CompuServe: 73750,3305                  FAX: 301 402-1065         */
/*                                                                   */
/* DISCLAIMER: These comments are offered to share knowledge based   */
/*   upon my personal views.  They do not represent the positions    */
/*   of my employer.                                                 */
/*********************************************************************/
From: news@hrd769.brooks.af.mil (InterNet News)
Newsgroups: comp.databases
Subject: Re: Memo of the month <hail ibm>
Date: 6 Jan 1993 09:21:10 -0600
Organization: Armstrong Lab MIS, Brooks AFB TX
NNTP-Posting-Host: hrd769.brooks.af.mil

In article <1993Jan6.145255.9860@magnus.acs.ohio-state.edu> jmorrill@magnus.acs.ohio-state.edu (John M Morrill) writes:
>
>I *strongly* suspect this memo is a hoax.
>-- 

  I would suspect it as well, since I have a copy of the EXACT same message 
from over three years ago.

  Remember, there are NO new jokes, just new audiences. - George Burns

TSgt Dave Burgess
NCOIC AL/MIS
Brooks AFB, TX
Newsgroups: comp.databases
From: goudswaa@fraser.sfu.ca (Peter Goudswaard)
Subject: Good DBMS for low-end machines?
Organization: Simon Fraser University, Burnaby, B.C., Canada
Date: Wed, 13 Jan 1993 01:19:30 GMT

If I have potentially hundreds of customers with PCs ranging from lowly
8086-based ones up to 486 killers, what would be a good system?  I know
that it is not an easy question to answer with the limited data I've
provided, but what they need is a membership-type application (fairly
simple) with anywhere between hundreds to perhaps a max of 10,000 
(members) records.  I'm thinking Foxpro, since I've seen what it can
produce, and my partner is pushing Paradox.  Oh, and we're basically
looking at DOS-only for the time being.  (But certainly Windows in the
next few years.)  I know that a year from now I might need to also 
produce a Windows version, and Foxpro and Paradox will (I think) fit
the bill as well.

I'm concerned with minimum system requirements, too.  Anyone know what
they and other packages need?

Peter Goudswaard
goudswaa@sfu.ca

Newsgroups: comp.databases.sybase
From: spencer@med.umich.edu (Spencer W. Thomas)
Subject: APTEXEC bug (5.0)
Date: Mon, 11 Jan 93 15:58:47 EST
Organization: University of Michigan
Distribution: comp

 SQL Server/4.8/P/Sun 4/SunOS 4.1.X/5/OPT/Fri Apr 24 10:15:10 PDT 1992 
 APT Workbench/5.0/P/Sun4/SunOS 4.1/1/Fri Jan 24 21:41:00 PST 1992

I've got a form that works fine under apt(edit), and under aptexec
UNLESS I specify -P passwd (e.g., I type
	aptexec form 1 -P $PASSWD where $PASSWD contains my database
password).  The form contains two "float" fields, the corresponding
database columns are of type "real".  When I try to "find by example",
I get a warning message "... SQL column xxx is datatype real and xxx
is float."  This happens on the opensql statement for the row.  Then I
get a fatal message when it actually tries to assign the value from
the row to the form field.

To reproduce it:

create table testbug (
	x real
)
go
sp_primarykey testbug,x
go

Then, run apt and create a test form.  Choose "testbug" as the table,
and build an application.  Add a few rows to the table.  Clear the
form and choose "find/by example".  Works fine, right?

Now run aptexec (without -P).  Again, find/by example works fine.
Now, run aptexec -P passwd.  See the error message.

Question: does anyone know if this has been fixed?  If I take the time
and effort to do the 4.8->4.9 upgrade (and APT 5.0->5.2) will it fix
it?  


--
=Spencer W. Thomas 		|  Info Tech and Networking, B1911 CFOB, 0704
   "Genome Informatician"	|  Univ of Michigan, Ann Arbor, MI 48109
Spencer.W.Thomas@med.umich.edu	|  313-747-2778, FAX 313-764-4133
Newsgroups: comp.databases.sybase
From: casavant@elmer.orl.mmc.com (John Casavant)
Subject: Microsoft ODBC driver for Sybase 4.9
Organization: Martin Marietta
Date: Mon, 4 Jan 1993 16:01:16 GMT

Where can we find a driver for Sybase 4.9 that works with Microsoft ODBC?
Is there an ftp site that has drivers for ODBC?



Thanks,

John Casavant
From: mparsons@fleming.csc.bcm.tmc.edu (Mark Parsons)
Newsgroups: comp.databases.sybase
Subject: Re: APT bug
Date: 8 Jan 1993 22:15:03 GMT
Organization: Baylor College of Medicine, Houston, Tx
Distribution: world
NNTP-Posting-Host: fleming.csc.bcm.tmc.edu
Originator: mparsons@fleming.csc.bcm.tmc.edu


In article <1993Jan7.164558.16288@sunova.ssc.gov>, chow@cssn0b.ssc.gov (Ivan Chow) writes:
> Hi,

YO!

>    I have used APT to develop a database frontend application.
> Now, I ported that to the APT version 5.0 (from 4.2) and I
> have a problem:
> I have a choice field, called rptchoice, on my form.
> Now I use APT-SQL to set the choice field to
> 
> rptchoice:visible = FALSE
> 
> but it does not work -- rptchoice is visible and highlighted. 
> (it works fine in version 4.2)
> Can someone please help?

Hmmmmm, I've just started playing with choice fields(in APT 5.0)
and have not tried turning one on or off(visibility) but I have
been able to turn off tabability.

According to the (5.0) manual you can not affect the visibility
(and probably the tabability?) of a field if you are in that
field.  It also states that trying to reset the visibility can 
not be done in the pre-process of the field.

Could you go back to the version in 4.2 and see if this is the
case, i.e., you can turn it off as long as you're not in the field,
but you can't turn it off if in the field?

If there's a discrepancy in the way the two systems work I'd
give Sybase Tech Support a call.

Oh, yeah, I got my info from the APT Workbench Reference Manual,
APT-SQL Reference Manual/Section, Objects and Properties Chapter,
p. 4-10 ;-)

> 
> Ivan
> ---------------------------------------------------------
> Disclaimer:
> I know... I know... I should NOT use APT at all.. at all..
> frustrations will keep coming up.....!!!!!!!

Amen to that brother!! ;-)

Mark

$0.82(?) and couting . . . 
Newsgroups: comp.databases.sybase
From: esh@prague.tss.com (Edward S. Hirgelt)
Subject: Re: Questions sbout time based queries
Organization: Teknekron Software Systems, Inc.
Distribution: na
Date: Mon, 11 Jan 1993 17:56:41 GMT


On 8 Jan 1993 21:54:22 GMT,
jimj@meaddata.com (Jim Johnstone) said:



Jim> We have a need to query out all rows entered by a given user since
Jim> a specified time.  My first thought was to use timestamp columns in
Jim> all tables. So (I am very new to Sybase, so please be nice) my
Jim> questions are:

Jim> 1. Are timestamps the best way to go? 
Jim> (nice because they are automatic, bad because they can't be
Jim> CONVERTed)

Depending on what you haven't said about your requirements, I probably
wouldn't use timestamps. They do get changed when someone updates the
row. This may or may not be the same person who did the insert. You may
or may not care. Also rows bcp'd in do not appear to get their
timestamps set. Or rather, timestamps columns seme to be set to 0. 

I tend to use timestamps to notice when someone updated a row out from
under a browse rather than for anything else. Perhaps this is too narrow
a view for timestamps. My solution follows below:

Jim> 2. Should I just use datetime in each table?
Jim> ... insert TABLE values(..., getdate(), ...) 
Jim> then 
Jim> ... select * from TABLE where date > @threshold and user = @user

This is what I would do. However I would define a trigger that
automatically set the date field to the current date when the row is
inserted. This ensures that no one can subvert the dating mechanism. You
also get to decide what to do on updates. 

Your select above works nicely.

Jim> 3. Is there some Sybase table/feature that will allow me to meet the 
Jim> requirement directly?

See above -- triggers.

Hope this helps.

Ed
--
Ex vitio alterius	|Ed Hirgelt			|esh@tss.com
sapiens emendat suum.	|Teknekron Software Systems, Inc|
(Publilius Syrus)	|Palo Alto, Ca.			|
Newsgroups: comp.databases.sybase
From: kdomb@ctp.com (Kevin Dombroski)
Subject: group by, max(), and unexpected results
Keywords: unexpected results :-(
Organization: Cambridge Technology Partners
Distribution: usa
Date: Mon, 4 Jan 1993 19:41:00 GMT


Folks,

	I'm trying to select a list of fields, grouping by field1, and gather
ALL the fields for the row that has the maximum value (max(field2)). Asking
for field1, max(field2) yields the results I want. However, if asking for 
more fields than field1, field2 yields unexpected results.

	Here is a full, working example:


create table #junk
(
	field1 	int,
	field2	int,
	field3	int
)

insert #junk values (1, 1, 5)
insert #junk values (1, 2, 10)
insert #junk values (1, 99, 15)

insert #junk values (2, 5, 200)
insert #junk values (2, 10, 300)
insert #junk values (2, 15, 400)

insert #junk values (3, 0, -1)

select field1, max(field2)
from #junk
group by field1
order by field1

select field1, max(field2), field3
from #junk
group by field1
order by field1

Results:

 field1      max field2
 ----------- -----------
           1          99
           2          15
           3           0

(3 rows affected)

 field1      max field2  field3
 ----------- ----------- -----------
           1          99           5
           1          99          10
           1          99          15
           2          15         200
           2          15         300
           2          15         400
           3           0          -1

(7 rows affected)


Question: Why doesn't the second result yield the following 3 rows?

 field1      max field2  field3
 ----------- ----------- -----------
           1          99          15
           2          15         400
           3           0          -1


Any input would be greatly appreciated...
-- 
================================================================================
Kevin M. Dombroski                  | "One good thing about music,
Cambridge Technology Partners       |  When it hits, you feel no pain...." 
================================================================================
From: jimj@meaddata.com (Jim Johnstone)
Newsgroups: comp.databases.sybase
Subject: Questions sbout time based queries
Date: 8 Jan 1993 21:54:22 GMT
Organization: Mead Data Central, Dayton OH
Distribution: na
Reply-To: jimj@meaddata.com
NNTP-Posting-Host: moose.meaddata.com



We have a need to query out all rows entered by a given user since a specified
time.  My first thought was to use timestamp columns in all tables. So (I am
very new to Sybase, so please be nice) my questions are:

1. Are timestamps the best way to go? 
(nice because they are automatic, bad because they can't be CONVERTed)

2. Should I just use datetime in each table?
... insert TABLE values(..., getdate(), ...) 
then 
... select * from TABLE where date > @threshold and user = @user

3. Is there some Sybase table/feature that will allow me to meet the 
requirement directly?

4. How would you handle this requirement?


[We use Sybase 4.8 on SunOS, if it makes any difference]

-- 
Jim Johnstone              jimj@meaddata.com                           
Mead Data Central          
P.O. Box 933               I do not speak for Mead Data Central
Dayton, Ohio  45401       
Newsgroups: comp.databases.sybase
From: afh@ornl.gov (HUNTLEY JR A F)
Subject: Re: Max IN clause
Summary: T-SQL IN clause maximum params is 250
Organization: Oak Ridge National Laboratory
Distribution: comp.database.sybase
Date: Wed, 6 Jan 1993 13:09:57 GMT

In article <ROB.93Jan5115202@fosters.med.utah.edu> rob@fosters.med.utah.edu (Rob Sargent) writes:
>
>Has anyone seen any doc on How large the IN () clause can be if stack with constants.
>

The maximum number of items that can be put into an IN list is 250.
If you go beyond this you get the message:

Msg 404, Level 19, State 1:
Too many ANDs or ORs in expression (limit 250 per expression level).
Try splitting query or limiting ANDs or ORs.

You may also get an unexpected EOF from the server.

				Al Huntley
				afh@ornl.gov
Newsgroups: comp.databases.sybase