HDTenEightyP/NetNews huggingface dataset:
From: tleylan@pegasus.com (Tom Leylan)
Newsgroups: comp.databases
Subject: Re: How About COMP.DATABASES.PARADOX ?
Date: 21 Nov 92 08:05:04 GMT
Organization: Pegasus,  Honolulu

mr@ogre.cica.indiana.edu (Michael Regoli) writes:

>I'll vote yes; I'm a new Paradox person who is finding an absolute
>dearth of Paradox-related stuff on the Internet.

>However, in the Grand Scheme of Things, it should probably look
>something like "comp.databases.ibmpc" from which, if traffic allows:
>
>  comp.databases.ibmpc.dbase    comp.databases.ibmpc.pdox
>  comp.databases.ibmpc.foxpro   comp.databases.ibmpc.pcfile

Michael, et.al.,

The dearth of Paradox-related "stuff" isn't related the presence or absence
of a newsgroup, if you and others post Paradox code to simtel-20 I'm sure
it will get filed there.

As for branches beyond .ibmpc where do you propose the users of the unix
foxpro (and dBASE I believe) products go ?

I'm beginning to reconsider my anti-split stance however because I'm
getting to the point of not wanting to read anything that a "specialist"
has to say.  I still think it would be worse for the Paradox users and
worse for the network as a whole (needless increased traffic) but I think
I'd benefit if the Paradox-only folks left <g>

Hey in time nobody will post threads anymore they will invent new newsgroups
every time they have a question to ask;

 comp.databases.paradox.version2.clear-screen.question
 comp.databases.paradox.version2.clear-screen.question.answer

tom
From: 00sflucas@leo.bsuvc.bsu.edu
Newsgroups: comp.databases
Subject: Paradox under Windows 3.1
Date: 24 Nov 92 04:22:00 GMT
Organization: Ball State University, Muncie, In - Univ. Computing Svc's

Has anyone had success in running Paradox 3.5 in protected mode while under
Windows 3.1?  I have been told it is possible but have yet to find someone
who knows how this can be done.  I would appreciate any suggestions you would
have!

Thanks!
Newsgroups: comp.databases
From: viking@iastate.edu (Dan Sorenson)
Subject: Re: Character supression/FoxPro 2.0
Organization: Iowa State University, Ames IA
Date: Sat, 21 Nov 1992 19:32:59 GMT

In <By11z4.Fou@news.cso.uiuc.edu> jcole@osiris.cso.uiuc.edu (Joan Cole) writes:

>The way I always do the get on passwords is @ X,Y GET passwdvar COLOR N/N
>Black on black is invisible (although not secure from print-screen)

	This is probably fine for 99% of the needs one would have.  A
more secure method would be to clear the keyboard buffer, ask for a
password, use a getkey() to read keypresses and append them to a memvar.
If the getkey() shows CHR(13), validate the password or start the routine
over.  CHR(13) as the first keypress returns to calling procedure.

< Dan Sorenson, DoD #1066 z1dan@exnet.iastate.edu viking@iastate.edu >
<  ISU only censors what I read, not what I say.  Don't blame them.  >
<  "This isn't an answer, it's a pagan dance around a midnight fire  >
<   written in intellectual runes." -- Rich Young                    >
From: M22367@mwvm.mitre.org
Newsgroups: comp.databases
Subject: Re: DB Comparison - DISAPPOINTING RESULTS
Date: 17 Nov 92 18:37:25 GMT
Organization: The MITRE Corporation, McLean VA 22102


 
The August 1, 1992 issue of Datamation has an article listing over 100 dbms,
what platforms they run on, what type of user interfaces are available, whether
they support SQL, what add-ons are available, etc.
 
The article makes no attempt to rate these products.  As another poster pointed
out, it is difficult to rate the products in any truly objective way.
 
My personal experiences (as if they will have any weight :-o )
--------------------------------------------------------------
IDEAL - bought up by the giant CA PacMan, is a superb development environment
        and 4gl for mainframe applications.  Dynamite product 4 years ago.
        I don't know what CA has done with the product, but it was excellent.
 
XDB - Good product for PC systems but notorious problems with memory management
      Terrific front-end for development, increasingly sophisticated programmin
      language.  The vendor pulled a NLM version of the product from the market
      due to 'lack of demand'.  Reportedly a great product for developing DB2
      applications on the desktop.  This product could be great, but the
      development staff need to institute some formal programming disciplines.
 
Revelation - I worked with Rev/G for about 2 years.  It drove me right up a
      wall.  I managed to hack it into something reasonable, but I denounce
      what IMHO is an insurmountable design flaw - every field is variable
      length.  Rev fans no doubt are about to flame me, but consider: in most
      database applications, 90% of your data is of known *fixed* length or at
      least a reasonable maximum can be determined. The 'all variable' paradigm
      ignores this little fact of life with no profit.  I tried ARev v1 and
      found it overwhelmingly cumbersome.  Given the wide variety of reasonably
      good products on the market, I can't see investing the time in Revelation
      (zip up my Nomex suit for the flames-to-come).
-----------------------------
 
So there's a detailed response.  These opinions do not neccessarily reflect the
opinions of my employer or anybody else. Hokay?
 
- Mike
Newsgroups: comp.databases.sybase
From: larry@st-andy.uucp (Larry Martell)
Subject: APT rules question
Organization: RMJ Securities Corp.
Date: Wed, 18 Nov 1992 17:51:49 GMT

In APT you can attach rules to fields on your form. When you compile your
rules, APT pulls the rule down from the server, creates a file with the
rule source in it (with a name of the form RLnnnnform_name.fpl, where nnnn 
is the number of the field with the rule attached to it), and compiles that
.fpl into a .fpo. 

Now, while this may be fine for a developer working on one form in their own 
directory, it is a major problem in an environment where only project managers 
have access to production directories. The manager must bring up every form in 
APT, compile the rules, and write the form (because compiling the rules creates
a timestamp in the .frm, and it you don't write the form with the new timestamp
the compiled rule will not be executed). This must be done manually. (It is also
a problem if you use SCCS to maintain your forms. After the form has been
checked in, its modes are 444, and your can't save the form.)

Has anyone come up with a method for automating this process? I was thinking
along two potential avenues. The first is to programmatically tell APT to do 
its thing (I don't know it this is possible). The second would be a program that
looked into the frm to find out the fields that have rules attached to them, 
and then use dblib calls to get the rules from the server, compile them into
the appropriate named fpo, and updates the timestamp in the frm.

Any help in this area will be greatly appreciated.

TIA
-- 
Larry Martell                  "Opinions are like assholes; everybody has one, 
212-668-9478		        but nobody wants to look at the other guys"
uunet!st-andy!larry
Newsgroups: comp.databases.sybase
From: lally@pmdb.sep.bnl.gov (Keith Lally)
Subject: Re: APT and TEXT Fields
Organization: Brookhaven National Laboratory
Distribution: usa
Date: Tue, 17 Nov 1992 18:58:30 GMT

In article <1e8fvqINN250@gazette.bcm.tmc.edu> mparsons@fleming.csc.bcm.tmc.edu (Mark Parsons) writes:
>
>In article <1992Nov13.162033.4728@bnlux1.bnl.gov>, lally@pmdb.sep.bnl.gov (Keith Lally) writes:
>|> 
>|> I would like to display help screens throughout my APT 
>|> application that are retrieved from a helptext table.
>|> When a function key is pressed the help form execs a
>|> stored procedure on the server that returns the help
>|> text for the particular form.  Does anyone know how
>|> to return a text field from the server into an APT 
>|> form?  Is it possible?  
>
>Our on-line help function just retrieves the appropriate
>help message from a table via a submit-sqlbegin-sqlend
>statement.  Very easy . . .  
>
>When you say 'text', do you mean datatype TEXT, or just
>a character string(char or varchar)?
>
>I can think of two ways to return text from a stored
>procedure call.
>
>One is to send back a string as the error message for an
>error that you generate via the raise-error command.  Of
>course, you then have to 1) test for the occurrence of
>the 'error' and then 2) parse the resulting error text to
>pull out the 'overhead'.  Kinda messy for this situation.
>
>The other is to just pass it back as a return parameter.
>
>
>Hmmmmm, that's 3 ways . . . . . or did I miss something in
>the question? ;-)
>
>Mark

Mark,

I am referring to fields of the TEXT data type.  Some of my help messages
will exceed 255 bytes so char and varchar are no help.  An entry field on
the form can have a maximum length of 2048 chars or more but how do I 
retrieve the TEXT data and stuff it into the entry field?  One way is to
have the stored procedure read the first 255 bytes of the text, put it into
parameter1 of type char, then read the next 255 bytes and stuff it into 
another parameter.  On the APT side I could then concatenate the params
together and put the result in the entry field.  This seems like a real
kludgy way to do what should be an easy operation.  

I also remember reading in one of the manuals that parameters passed between
the server and an apt application can only be 255 chars in length.  Has 
anyone else had experience with this kind of problem?

Keith Lally
are limited to 255 bytes and many of our help messagesAs I understand it
Newsgroups: comp.databases.sybase
Subject: Re: Calling C programs from triggers
From: Dimitri Vulis <DLVGC@CUNYVM.BITNET>
Date: Tuesday, 17 Nov 1992 01:00:05 EST
Organization: City University of New York/ University Computer Center
Path:
cunyvm!caen!zaphod.mps.ohio-state.edu!news.acns.nwu.edu!uicvm.uic.edu!u31742
Organization: University of Illinois at Chicago
Date: Tuesday, 10 Nov 1992 13:12:44 CST
From: <U31742@uicvm.uic.edu>
Newsgroups: comp.databases.sybase
Subject: Calling C programs from triggers

>We have sybase version 4 installed on sparc stations. Could someone tell us
>how to call a C program, when a trigger is fired.
While this won't work 'in general', if you're doing it from a single C
program with DBLIB, you can have the trigger send back a message and
have the message handler catch it and take action. (But this won't
work if the trigger is triggered from elsewhere, of course)

Dimitri
Disclaimer: CUNY doesn't know anything about this.
Newsgroups: comp.databases.sybase
From: lhall@csfb1.fir.fbc.com (Lawrence Hall)
Subject: RE: "Select" from one server to ther other server 
Reply-To: uunet!csfb1!lhall
Organization: First Boston Corporation
Date: Wed, 18 Nov 1992 15:21:34 GMT

Etsuko Shimabukuro writes :

[ 	I am looking for the the way to do 
[ 
[	"select * from table where some condition" in a database in A-server,
[ 	 ^^^^^               ^^^^^
[ 	then transfer the data into a different database in B-server.
[
[	Is there any way to do this kind of things without using 
[
[ 	Open-client Library???



The easiest way to accomplish this inter-server move of data is as follows :


Server A

	Select * into table-x from table where some condition


bcp database..table-x out x.data -S AServer (appropriate bcp args here)

bcp target_database..table-y in x.data -S BServer ( appropriate bcp args)




As for selecting-into one server from another, Sybase does not support this 
and will not support this except through the use of the Omni Server.


" " " Lawrence


----------------------------------------------------------------------------
Lawrence E. Hall
First Boston Corp.
5 World Trade Center 9th Floor                    uunet!csfb1!phantom!lhall
NYC, NY  10048                                    lhall@csfb1.fir.fbc.com
----------------------------------------------------------------------------
The Secretary will disavow all knowledge.
From: mparsons@fleming.csc.bcm.tmc.edu (Mark Parsons)
Newsgroups: comp.databases.sybase
Subject: Re: APT and TEXT Fields
Date: 18 Nov 1992 16:37:42 GMT
Organization: Baylor College of Medicine, Houston, Tx
Distribution: usa
Reply-To: mparsons@fleming.csc.bcm.tmc.edu (Mark Parsons)
NNTP-Posting-Host: fleming.csc.bcm.tmc.edu
Originator: mparsons@fleming.csc.bcm.tmc.edu


Keith,

	If you do go with TEXT fields, and you get it working the
way you want, I'd like to talk with you about it.

	Right now our on-line help consists of little messages
(less than 255 in length) that are based on the field the cursor 
is in.  We(me, actually) are in the process of designing a method
of putting not only help messages, but the entire system documen-
tation on line, kinda like the APT-Edit help system.

	I want to do all this in APT, as opposed to C calls like
APT-Edit does.  

	One of the things I'm looking at is reading in large 
quantities of text . . . first thought is to break it up in 
255 chunks with sequence numbers . . like I just posted . . 

	Sooooooo, give me a call . . er . . drop me a line . . 
when you decide what you're doing . . maybe we can swap ideas?

Mark
mparsons@bcm.tmc.edu
Newsgroups: comp.databases.sybase
From: gpmenos@firestone.Princeton.EDU (Gerard Philippe Menos)
Subject: bug in limited server?  what to do?
Originator: news@nimaster
Reply-To: gpmenos@firestone.Princeton.EDU (Gerard Philippe Menos)
Organization: Princeton University
Date: Thu, 19 Nov 1992 14:56:12 GMT

I am a Sybase novice.  I'm not supposed to spend much time (out of my  
overall responsibilities) in maintaining a smallish sybase database.  
:-)  So, I would really appreciate any suggestions.

I'm using Parabase (for NeXT) as a front-end to Sybase 4.0.1;   
Parabase creates the tables and includes very rudimentary SysAdmin  
features.  But I'm becoming familiar with isql, due to some problems  
we've had.

The current problem:  A few records are not behaving.    You can  
retrieve the problem rows, but one cannot update or delete these  
records.  Also, when we try to create a row in another table that  
relates to the records/rows in question, Parabase loses its connection  
to the Sybase server.

According to Parabase technical support, we have stumbled upon a bug  
in the Sybase limited server that "sometimes corupts its internal  
record pointers."  Parabase made a suggestion on how to fix this, by a  
kludge to create a new copy of the table, using Parabase to create and  
then delete a bogus field (this apparently forces the copy), but I  
could not execute this kludge to its completion, due to some space  
problems that *should* not exist!  

My questions to you experienced Sybase people:

1.  Has anyone else heard of or encountered this bug in the limited  
server?  Or, would you suggest some other diagnosis?

2.  Any suggestions on how to fix this problem?  [My users are getting  
a bit impatient;  they are otherwise extremely happy with the  
application.]

I don't know if it's relevant, but running dbcc on the problem  
table/database, reports the following:

> Msg 624, Level 16, State 1:
> Line 1:
> Attempt to retrieve row from page via RID failed because the  
requested
> RID has a higher number than the last RID on the page. Rid pageid is
> 0x164 and row num is 0x9    .Page pointer = 0x777800, pageno = 356,
> status = 0x101, objectid = 256003943, indexid = 0     .
> DBCC execution completed. If DBCC printed error messages, see your
> System Administrator.

I have tried to run dbcc checkalloc, but this did not help.

I can provide more information, if necessary.

With appreciation for any help I can get,
Phil Menos

--
-------------------------------------------
G. Philippe Menos    
Systems Administrator
Princeton University Libraries
gpmenos@firestone.princeton.edu
voice:  609-258-5183
  fax:  609-258-5571
-------------------------------------------
-- 
-------------------------------------------
G. Philippe Menos    
Systems Administrator
Princeton University Libraries
Newsgroups: comp.databases.sybase
From: spencer@med.umich.edu (Spencer W. Thomas)
Subject: Re: systypes?
Date: Mon, 23 Nov 92 10:54:38 EST
Organization: University of Michigan
Distribution: comp

Jeff Kyser suggested looking at the code for sp_help.  Thanks.  For
the record, at least under version 4.2, the way to get the system type
for a given usertype <ut> is
	select system_type=st.name from systypes s, systypes st where
		s.usertype=<ut> and s.type = st.type and 
		st.usertype!=18 and st.usertype < 100

The st.usertype!=18 ignores sysname.  The key test seems to be
st.usertype<100.

--
=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
From: sommar@enea.se (Erland Sommarskog)
Newsgroups: comp.databases.sybase
Subject: Re: multiple EXISTS subqueries under Sybase 4.8
Date: 18 Nov 92 22:39:40 GMT
Organization: Enea Data AB

Hm, this discsussion reminds me of a bug that we've stumbled on.
But our case was a bit simpler. Basically we had:

     SELECT ...
     WHERE  a AND b AND (c1 OR c2) AND d AND E

where a, b etc were various conditions. The query failed in some cases
when c2 returned false, despite c1 being true. And, as you might have
guessed c2 was an EXISTS or NOT EXISTS. Things went wrong when there
were no records at all in the table searched by c2. I did also
try IN with a subquery, that did also fail.

Now what is interesting here is not the bug we had, but that the
fact it is so similar to the bug originally reported here which
was under 4.8, and we are still on 4.0.2 (AIX 3.1). I mean we
didn't spend a time reporting something so obvious, when we
have such an old version.

-- 
Erland Sommarskog - ENEA Data, Stockholm - sommar@enea.se
From: mparsons@fleming.csc.bcm.tmc.edu (Mark Parsons)
Newsgroups: comp.databases.sybase
Subject: Re: multiple EXISTS subqueries under Sybase 4.8
Date: 16 Nov 1992 15:43:35 GMT
Organization: Baylor College of Medicine, Houston, Tx
Distribution: world
Reply-To: mparsons@fleming.csc.bcm.tmc.edu (Mark Parsons)
NNTP-Posting-Host: fleming.csc.bcm.tmc.edu
Keywords: EXISTS, 4.8, sun4, sunos 4.1.1
Originator: mparsons@fleming.csc.bcm.tmc.edu


In article <1992Nov15.225853.2269@lamont.ldgo.columbia.edu>, msolda@lamont.ldgo.columbia.edu (M Solda) writes:
|> 
|> just to follow up, after posting my original article, i solved the problem by
|> using a UNION operator to join the results into to identical queries, except 
|> of course, for the EXISTS clauses.
|> 
|> i did try "transforming the OR into an AND", but as Dave points out, this would
|> not work in all cases and this was such a case.
|> 
|> anybody know if this is a reported bug?
|> 
|> msolda

Ummmmmmm, if you're still working on it, could you post the example
code?  I'm not quite following this.

I know that in APT . . and in the Sybase server? . . . that the
OR's and AND's logic is not implemented as with most *REAL* languages.

In APT, testing does not stop with the first true statement in an
OR clause(or first false statement in an AND clause); all statements
are tested.  EXAMPLE:

	if group_1:used > 1 and
	   group_1[group_1:used - 2].field_1 is NULL
	begin
		. . . . 
	end 

In the case where group_1 has only 1 row, the test should fail
after the test for "group_1:used > 1" but it DOESN'T, it tries to
do the second part of the test, which causes an error since there
is no such index as -1 for a group (in APT).  Most languages will
allow this type of programming . . .APT requires that this be broken
up into nested IF's . . . 

I said that to say this . . . . 

	Maybe there's some sort of limitation on the nesting of
EXISTS and NOT EXISTS within Sybase products . . even though it may
sound plausible for it to work the way we want it . . . . 

Mark 
Newsgroups: comp.databases.sybase
From: dbenua@panix.com (David Benua)
Subject: Re: multiple EXISTS subqueries under Sybase 4.8
Date: Sun, 15 Nov 1992 14:42:58 GMT
Organization: PANIX Public Access Unix, NYC
Keywords: EXISTS, 4.8, sun4, sunos 4.1.1

In <1992Nov14.174847.29576@lamont.ldgo.columbia.edu> msolda@lamont.ldgo.columbia.edu (M Solda) writes:

>does anyone know if there is a limitation in the number of EXIST subqueries
>that can be in a single query?  i have a query with an EXISTS and a NOT EXISTS
>joined by an OR, but only the rows that meet the EXISTS criteria are reported.

>a separate query for each EXISTS provided the correct answer in each case.

>am i breaking syntax somewhere?

I've had the same problem with 2 EXISTS in the same subquery, I got around it
by transforming the OR into an AND (DeMorganizing) and reversing the logic.
But, of course, this will not work in all cases (or even most cases). We are
using 4.2 on Sun OS, but this should be the same in any environment.

I don't know if it's a known bug, but someone ought to report it somewhere

Dave
 
-- 
David Benua                  Internet: dbenua@panix.com 
	                   Compu$erve: 72630,1416
Newsgroups: comp.databases.sybase
From: bob@bobsled.glv.com  (Bob Lunney)
Subject: Re: Table Design Hint needed
Organization: Encompass
Distribution: usa
Date: Thu, 19 Nov 1992 13:53:13 GMT

In article <BxxqJ4.Cs0@ccu.umanitoba.ca> ummalik@ccu.umanitoba.ca (Ijaz Rashid  
Malik) writes:
> 
> Hello,
> I have to design two tables and I need some help to minimize the duplication
> etc.
> 
> One table is "businesses" and key fields is business ID.
> Other is "directors" and key is dir. ID.
> A business can have more than one directors and a director can control more
> than one business.
> Both table have to be linked so that all directors for a given business or
> all businesses under given director could be listed.
> My thinking either calls for mulitple Dir. ID. columns in business table
> (dir1. ID, dir2. ID...) but its not practicle as # of directors varies. OR
> same director could be listed in directors table under different ID's and 
> there is a column (field) called Business ID which points to the business
> controlled by this person but problem with this is that same record is listed
> multiple times ==> redundancy!!!
> Could someone please help me out here with some hints...
> 
> Thanks very much!
> Malik
> ummalik@ccu.umanitoba.ca

Ah, the not-so-dreaded many-to-many relationship.  Try inserting a two column  
table between "businesses" and "directors" (call it "business_directors" for  
sake of argument").  The "business_directors" table then has two columns,  
business_ID and director_ID.  No mix and match businesses to directors in the  
"business_directors" table however you would like.  The foreign key  
relationship between "businesses" and "business_directors" is via business_ID,  
of course, and the foreign key relationship between "directors" and  
"business_directors" is via director_ID.  Note that the primary key for  
"business_directors" is both business_ID and director_ID (you need to know both  
values to select one business and match it to one director).  Good Luck!

Bob Lunney	bob@bobsled.glv.com	NeXTmail preferred!
Encompass	919-460-3274

Disclaimer:  My company doesn't allow me to have opinions - I might 	 
	     inadvertantly speak for myself or someone else.
Newsgroups: comp.databases.sybase