HDTenEightyP/NetNews huggingface dataset:
From: reb@punch.EBay.Sun.COM (Bob Brown)
Newsgroups: comp.databases.sybase
Subject: Multiple Connections for temporary tables
Date: 8 Oct 92 02:29:55
Organization: Systar Technologies, Inc.
Distribution: comp
NNTP-Posting-Host: punch.ebay.sun.com



I'm using DBLIB and have come across a challenge. Maybe you SYBASE gurus can
solve it.


In my program I am reading each row in the table with dbnextrow(). The
table is a temporary table. WHILE STILL in the while loop of dbnextrow(),
I want to make another connection to the temporary table so I can get
some data from another row to help with the processing on the current
row. On a regular table, no problem. With the temporary table, the
second connection doesn't recognize the existience of the newly
created temporary table.

The table needs to be a temporary table. I cannot do a self-join.

I tried getting the object id and finding the table name in the tempdb
database, but selecting on THAT resulting name gives an invalid selection.

Any ideas?!

                                
--
--Bob
Systar Technologies, Inc.		   Sun: robert.brown@EBay.Sun.COM
1712 Picasso Avenue, #B & #C            Office: reb@systar.com
Davis, California  95616		 Phone: (916) 753 - 2611
Newsgroups: comp.databases.sybase
From: nevin@dtint.dtint.com
Subject: Re: Sybase and APT
Reply-To: nevin@dtint.dtint.com
Organization: Digital Technology, International
Date: Fri, 16 Oct 92 14:30:07 GMT

In article <1bjq48INNide@coral.bucknell.edu> gspencer@bucknell.edu (Gene  
Spencer) writes:
> We are seriously looking at Sybase and APT as the platform for all of our
> administrative systems.  We were surprised when the three references supplied 
> by the vendor either did not use APT or was very unhappy with it.  What is
> the general concensus of the APT toolset?  
> 
> Is APT a reasonal basis for development of a complete suite of administrative
> applications or is it too structured and limiting?
> 
> (we must develop applications for a wide variety of desktop devices,  
including
> dumb terminals, DOS devices, Macintoshs and Unix workstations).
> 
> Please resond to me directly <gspencer@bucknell.edu> and I'll summarize to 
> the net.
>  
> Thanks!  

If a developer uses APT for his first project-- it's Sybase's fault.
If a developer uses APT for his second project-- it's the developer's fault.

I used it once.  I won't use it again.

--
NeXTmail preferred, but ONLY at my REAL email address: nevin@dtint.dtint.com

-- 
---
root	                               root@dtint.dtint.com
Digital Technology Int.                (801)226-2984	
500 W. 1200 South, Orem UT, 84057      FAX (801) 226-8438
Xref: sparky comp.databases.sybase:144 comp.databases:7266
Newsgroups: comp.databases.sybase,comp.databases
Date: Fri, 16 Oct 92 11:18:57 EDT
From: Zhe Li <li@cs.columbia.edu>
Subject: Caching mechanism


Hi there:

Could anyone give me some information about the caching mechanisms of the
follwoing DBMSs?

---- SYBASE
---- ORACLE
---- POSTGRES
---- INGRES

e.g. Do they use write-through caching or not? If so, what's the granularity
of the "write-through"(one-tuple at a time?)

Thanks in advance!
--lee

li@cs.columbia.edu
Newsgroups: comp.databases.sybase
From: shobhana@shakti.ncst.ernet.in (Shobhana)
Subject: Trigger to do cascading updates?
Organization: National Centre for Software Technology, Bombay
Date: Wed, 14 Oct 1992 11:13:14 GMT

Hello all--

I want to write a trigger on a table to do a cascading update:

Suppose, I have two tables A and B defined so that k1 and k2
are the primary keys for A and k1, k2 and k3 for B. In other words
A is the master table and B is the detail.

How can I write a trigger for A to update k1 and k2 in B whenever
it is changed in A? This was my attempt:

create trigger upd_trig
on A for update as
begin
	if update(k1) or update(k2)
	begin
		update B
			set k1 = inserted.k1,
			    k2 = inserted.k2
		from inserted, deleted
		where
			B.k1 = deleted.k1 and
			B.k2 = deleted.k2
	end
end

However, this does not work when a *SET* of rows in A are updated in a
single statement. Any suggestions?

Shobhana Vyas.
--
Internet	shobhana@shakti.ncst.ernet.in
Telephone	voice: +91-22-430-0531,	fax: +91-22-437-0558
From: usenet@transfer.stratus.com (Mr. Network News)
Newsgroups: comp.databases.sybase
Subject: Re: Does Update Table Reach View?
Date: 16 Oct 92 15:19:10 GMT
Reply-To: Dave_Wetzel@vos.stratus.com
Organization: Dave_Wetzel

First place I'd look is the view syntax.  Try doing a select on the two 
tables directly with the where clause like the view's.

We've used views in 4.8 and so far have seen no problems.

--------------
Dave_Wetzel@vos.stratus.com
From: mparsons@fleming.csc.bcm.tmc.edu (Mark Parsons)
Newsgroups: comp.databases.sybase
Subject: APT 5.0 questions
Date: 8 Oct 1992 22:28:26 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
Originator: mparsons@fleming.csc.bcm.tmc.edu



I've got a request in to Sybase Technical Support about the
following issues but was wondering if any of y'all might have
some info, too?

Anyone find some exhaustive explanations on appearance definitions?
I can figure out what most of the predefined 17 do, but there are
a few that slip my grasp.  Also, anyone know the precedence levels
on using appearance definitions?

Second, anyone have some antecdotes on setting up the function
and control key mappings?  In particular, the ins-outs of Sybase
mappings and terminal mappings(xterms and vt100's)?

Thanks,
Mark
Newsgroups: comp.databases.sybase
From: lally@pmdb.sep.bnl.gov (Keith Lally)
Subject: Sybase Environmental Apps wanted
Organization: Brookhaven National Laboratory
Distribution: usa
Date: Thu, 8 Oct 1992 13:31:03 GMT


Are there any third parties/consultants out there writing applications 
in sybase that do any of the following:

	manage water quality samples
	manage physical data recorded at sampling site (PH, temp, etc)
	store and analyze QA/QC data
	store sample analytical information
	store regulatory health-related info on chemical constituents
	store project mgt info incorporating DOE and EPA mgt data
	perform classical and spatial statistics
	develop graphic plots of data

The group is considering Oracle because many apps exist to do the above but
they could be swayed to sybase if apps can be found.  

thanks
keith lally
	

Newsgroups: comp.databases
From: joe@archsci.arch.su.oz.au (Joe Nappa)
Subject: Public Domain OODMS ??
Organization: Design Computing Unit, The University of Sydney
Date: Wed, 7 Oct 1992 08:19:50 GMT

Yes...yet another request for the addresses of ftp sites holding
OODMS (yawn!). Can anyone out there help? Preferably it should be
SQL based, but not necessarily. Does anyone know where I can get
my eager hands on "Gemstone", Orion, or ODEODE? What's OBST like?

Gratefully yours,

-- 
Joe Nappa                  *Lisa: "These talking dinosaurs are more real than * 
joe@archsci.arch.su.edu.au *       most real families on TV"                  *
Dept. of Architec. Science *Bart: "It's like they saw our lives & put it right*
Uni. of Sydney, AUSTRALIA  *       up on screen"  (from Fox's "The Simpsons") *
Newsgroups: comp.databases
From: lars@ramsey.cs.laurentian.ca (Larry Singleton)
Subject: Looking for 'Softc200' shareware
Summary: Looking for a copy of Softc200 shareware library of C functions
Keywords: Shareware, Dbase, Clipper, Foxbase, Windows
Organization: Dept. of Computer Science, Laurentian University, Sudbury, ON
Date: Fri, 16 Oct 1992 14:50:01 GMT




Does anyone have a copy of Softc200 shareware library of 'C' functions to
access Dbase, Clipper, Foxbase etc files from Windows 3.1.  I am interested 
in the Small or Medium memory models for Microsoft 'C' 6.0 preferrably the 
Medium model.  I think this would be found as a DLL library for Windows 3.1. 

If you have any information for me, 
please send Email to: lars@ramsey.cs.laurentian.ca

Thank you,

                    LARS
From: maurit@nrtc.nrtc.northrop.com (Mark Aurit <maurit>)
Newsgroups: comp.databases
Subject: Oracle for Banyan VINES (6.0?)
Date: 13 Oct 92 21:44:51 GMT
Reply-To: maurit@nrtc.nrtc.northrop.com (Mark Aurit <maurit>)
Organization: Northrop Research & Technology Center, Palos Verdes, CA

We are thinking very seriously of using Oracle for Banyan VINES
as the back end for a client-server app we are creating. At this
point it appears that the client will be the Wingz spreadsheet/
development environment. At this point in time Im assuming that
Oracle for Vines is version 6.0 of Oracle.
Question: can we store binary objects (such as graphics) in a
6.0 table?
Any comments *greatly* appreciated.
Mark Aurit
maurit@nrtc.northrop.com
(310) 331-4069
From: lf@uk.ac.uea.sys (Luke Fitzgerald)
Newsgroups: comp.databases
Subject: Re: dbase IV format file
Date: 15 Oct 92 08:57:39 GMT
Organization: School of Information Systems

In article <1992Oct14.004317.18527@iti.gov.sg> thongt@iti.gov.sg (Thong Tiong (SE)) writes:

>hi all

>I am new to dbase IV and I am using V1.5 now.

>I am a format file to do multi record editing on a
>file called customer, as shown below

>USE customer
>SET FORMAT TO cust_fmt
>EDIT
>SET FORMAT TO

>However, I need to perform some commands after each record is
>edited. Where should I insert the commands? Adding them in the
>format file don't seem to work.

>Any help is much appreciated.


>Choo Thong Tiong
>(thongt@iti.gov.sg)

The cludge I generally use is to write a validation function for fields and 
tie them in to the format file.  Then you can but whole-record editing as a 
validation function on the last field.

But I'm sure someone on the net has a more elegant way.

Luke
From: eomiya@genghis.borland.com (Elliot Omiya)
Newsgroups: comp.databases
Subject: Re: Paradox 4.0 is SLOWER !! (Why)
Date: 8 Oct 92 16:15:44 GMT
Distribution: comp
Organization: Borland International, Inc.

dang@njmsa.umdnj.edu (Anju Dang) writes:

>Hi folks,

>I have recently been involved in upgrading an application onto the
>new version of Paradox (4.0).  To avoid recoding I am using the
>compatible interface for the time being.  All intial tests are showing
>that my application run appx 15% faster when running under Paradox 3.5.

>The only changes that I have made are: 
>     1. restructure all the tables.  &
>     2. Add Setuidmode Compatible to my startup script.

>If anybody has shared my experience or knows what I am doing wrong  - PLEASE 
>let me know.  I was so eager to get the 10 times improvement in performance
>as my upgrade notice had said.   FOLKS FROM BORLAND SHOULD NOTICE THIS.... 


1.  If you have a Compuserve account, type GO BORDB and log into the 
    Compuserve forum.  This is regularly monitored by Borland tech support
    and "Team Borland" a very dedicated group of Paradox developers.
2.  4.0 runs slower than 3.5 unless tuned properly.  If you have a 286 (or
    even 386) with less than 4MB of memory, you need to pump your codepool
    to at least -500 (C:\PDOX40\PARADOX -codepool 500).  For very small
    operations, 3.5 may be faster but for medium and large operations, 4.0
    is WAY faster, especially on queries.
3.  Call Borland Tech Support (don't have number handy).  They're very helpful
    on these issues and can give more detailed answers on how to tune 4.0 to
    run faster than 3.5.

Good luck.

-=<EHO>=-
Newsgroups: comp.databases
From: michaelh@g2syd.genasys.com.au (Michael Haldey)
Subject: Re: Clipper Windows Version
Organization: Genasys II, Sydney, Australia
Date: Wed, 14 Oct 1992 01:51:50 GMT

In article <1992Oct12.035020.56168@datamark.co.nz> david@datamark.co.nz (David Rowland) writes:
>I Read a review about a future product from nantucket which is the
>windows version of clipper.  Does anyone know about it (i.e. release
>dates etc)???

Nuntacket worked on two versions of Clipper - for OS/2 and for Windows. 
(Information from issue of Database Advisor, devoted to Clipper).
I've heard that the release should be this year, but I'm not so sure.

Neither I think that the first release would be stable (I remember 
first Clipper 5.0).        

>
>Thanks in advanced.
>-- 
>| David Rowland       | The British are using New Zealanders.  They must |
>| Datamark Intl Ltd   | really mean business !                           |
>| Wellington          |      -  General Rommel During Northern African   |
>| NEW ZEALAND         |         Campaign WWII.                           |

my 0.01

michael
-- 
Michael Haldey  |  Genasys II Pty Ltd
                |  13th Level, 33 Berry St, North Sydney, NSW, Australia
                |  Phone:    +61-2-954-2878 (-9930 FAX)
                |  Internet: michaelh@g2syd.genasys.com.au
Newsgroups: comp.databases
From: ifenton@crc.ac.uk (I. Fenton)
Subject: Re: Clipper file creation problem
Organization: MRC Human Genome Resource Centre
Date: Thu, 15 Oct 1992 12:31:35 GMT

In article <1992Oct14.004256.16706@kum.kaist.ac.kr> shkang@dari.gsc.co.kr (Sungho Kang) writes:
>

[ lots of code deleted ]

>-------------------------------------------------------------
>( I use Clipper5.01 and MSC 6.0 )
>
>I have two problems in above code.
>
>	1. error message : " cannot create VM swap file "
>
>	    I think that this error is because of Function ( _db_sv_tmm() ) .
>	    The function creates .dbf and .ntx ( named by current date ).
>		( ex : t1992010.dbf t199210.ntx )
>
>	    Is the syntax of the function right ?
>

this 'cannot create' message is often a case of not having enough open file 
handles.  make sure that your CONFIG.SYS has files=50 (say), and that you
have the CLIPPER environment variable set to, say, CLIPPER=F35; this should
do the trick.  i reckon the code is ok.  post your autoexec.bat & config.sys
files if it doesn't work.

>	2. I know that can open files to 255 in Clipper 5.01.
>	   Now I open 12 files, but I got error message "fopen() error message"
>	   When link Clipper obj and C obj, this rule ( 255 files open ),
>	   Is this rule invalid ?
>
>	   Please help me!!!.

see above discussion.  i don't think the rule is invalid.

>
>	   PS: I am sorry in my ugly english.
>	   

no apology needed.  by the way, it should be 'I am sorry FOR my ugly English'
(*grin*, could resist that..., i'm sorry...)

good luck !

=============================================================================
IAIN FENTON                             | All errors of spelling, grammar &
Institute of Medical Genetics           | fact are due to a missing <Del> key
University of Wales College of Medicine |====================================
Heath Park                              | "No man should marry until he has
Cardiff  CF4 4XN                        |  studied anatomy and dissected at
U.K.                                    |  least one woman" - de Balzac
=============================================================================
Voice = +44 - 222 - 744049   | In 1912, Jack Johnson, the first black world
Fax   = +44 - 222 - 747603   | heavyweight boxing champion, was refused
Email = fenton@uk.ac.cardiff | permission to board the Titanic because of
   (or) wmgif@uk.ac.cardiff  | his colour.
   (or) ifenton@uk.ac.crc    |
=============================================================================


Newsgroups: comp.databases,comp.databases.oracle,comp.databases.sybase,comp.sys.novell
From: tymann@ops1.bwi.wec.com (John Tymann)
Subject: Need help selecting DB for PC/Novell/Vax/Unix/HP3k/HP1k
Organization: Westinghouse Electronic Systems Group, Baltimore, MD.
Date: Wed, 7 Oct 1992 22:45:05 GMT

I need some help as the last time I developed a serious database system
was over five years ago and have not kept up with the awesome developments 
that have happened since then.

I'm in the midst of specifying a client-server Database for a bunch of 
different platforms.  Our main client is a PC with Novell client s/w with 
telnet capability.  However we must also support HP 1000 & 3000 terminals,
and be able to share files with Apollos and Vaxes.  We are developing a 
documentation vault for source code, internal procedures, etc.  The existing 
vault is HP1000/HP3000 based.  But it's 15 years old and we want to start 
from scratch.

My Platform block diagram looks like:

PC/Novell      Vax      Vax Terminal     HP1k/3k terminal     Apollo
    |           |           |                   |                |
    --------------------------------------------------------------
	Ethernet            |
                         Black Box
          (database with query & file transfer support)

My requirements are:
	Selections be based on industry standards
	To minimize system/code development effort
	Modularity and non-proprietary protocols, etc.
	Only move query results across ethernet backbone

What I'm thinking of for the Black Box is:
	An SQL engine of some sort (Oracle/Novell SQL/?)
	Have the client software maximized for use on PC (SQL based)
	Use ftp to transfer files to/from db server, vax, u*x, hp
	Thinking of C or C++ for non-db related code so the db lang. should
	   have an engine or hooks for c or c++
	Using a PC with a Telnet daemon to take care of non-PC clients
           or potentially have portable code for non-PC hosts
	Leaning towards Paradox for client software due to in-house exp.

I'm hoping that I can get some input from developers/vendors/anyone 
knowledgable as to what people are developing in now, pitfalls to watch out 
for, lessons learned, things you wish you hadn't done, things you wish you 
had done.  Any comments on what I've said.
 
Please reply directly to tymann@ops1.bwi.wec.com   - I've posted this to 
several news groups.  I will compile all info I receive and make a post if 
it looks like it will be helpful.

Thanks,
John Tymann


 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
 John Tymann                  || INTERNET   : tymann@ops1.bwi.wec.com
 Westinghouse Electric Corp.  || (W) Vaxes  : tron::"tymann@ops1"
 (410) 765-3915               || Compuserve :  72230,3327
  Bones Heal. Pain is Temporary. Chicks Dig Scars. Glory is Forever!
From: on@uta.fi (Ossi Numminen)
Newsgroups: comp.databases
Subject: Empress
Date: 7 Oct 92 07:03:46 GMT
Distribution: world
Organization: University of Tampere, Finland

Can somebody point me a book, or some other reading material, on
Empress RDBMS. Especially valuable would also be some sort of
comparisons to other RDBMSs, like Ingres or Oracle.

Thanks,
       Ossi

Xref: sparky comp.databases:7188 comp.misc:3966 comp.sys.ibm.pc.misc:13615
From: durai@ORTTA (Appadurai V.)
Newsgroups: comp.databases,comp.misc,comp.sys.ibm.pc.misc
Subject: Re: FOXPRO: Is there any E-mail servers or support?
Keywords: Foxpro Database ibm pc relational
Date: 13 Oct 92 13:06:42 GMT
Organization: U of Mn

In article <s7aksB11w165w@slic.cts.com> mikey@slic.cts.com (Mike Shirley) writes:

>I've looked around and haven't found an E-mail list for support
>of FoxPro or Foxbase.  Do any exist?  If not, is anyone using
>Foxpro and would like to join or start an E-Mail group on this
>subject?


>--
>     Mike, WB6WUI   //   INET:  mikey@slic.cts.com   //   GEnie: SLIC


I have not come across any e-mail list for support  (of course, compuserve 
is different..)

I tried to start a foxpro user discussion list some time ago, but gave it up 
coz' of lukewarm response.

I agree.  That should not deter us.  If you intend setting up some kind of 
list, I am in.
From: John_Borchert@mindlink.bc.ca (John Borchert)
Newsgroups: comp.databases
Subject: Re: Clipper Windows Version
Date: 13 Oct 92 19:57:35 GMT
Organization: MIND LINK! - British Columbia, Canada
Distribution: world

> I. Fenton writes:
>
> nantucket, the people who brought you clipper, were bouhgt outright by big,
> bad computer associates.  aspen is the secret (*grin*) research project by
> nantucket to succedd  clipper with a platform-independetn, windows-based
> database with run-time speed approaching that of pure c-code.  there is no
> released product as yet, but one is expected next year, prably first on the
> pc-windows platform, then on os/2 and maybe some form of unix.  ca sent out
> a 'staement of direction' to all clipper users, which included, for the
> first time, screen-shot of the aspen project,.  it looked a little bit like
> microsoft's visual-basic !  but with more serious development tools.


Aspgen is expected to come out sometime in 1993.  However there is a product
out today that allows clipper 5 apps to run as true Windows 3.1 apps in
enhanced mode.  Its called Dolce Vita.  I haven't received a demo on the
product yet however their ad points out these features:
- full compatibility with Clipper 5.x code
- redirects all current screens functions to windows ( even the get system
and   TBrowse
- access to all Windows screen objects like menus, scrollbars, dialogs, etx.
- can launch other Window apps through DDE ( dynamic data exchange )
- clipper debugger is still supported
- can use DLLs ( dynamic link libraries )

Sounds a little too good to be true.  Does anyone know how it behaves with
clipper third party libraries?  Particularly the Class(y) library that gives
you full object-oriented capabilities under Clipper 5.  If it works with
Classy then this product would do today what Aspen might do in a year or so.
Here some other info getting Dolce Vita:

Cost $295 till Oct 31/92
Fiesta Publications, Inc.
175 Fiesta Way
Fort Lauderdale, FL 33301-1416    FAX: 305-523-2921  Tel: 305-728-8183

--
------------------------------------------------------------------------------

John Borchert        | From Internet  : John_Borchert@mindlink.bc.ca
Borchert Consulting  | From CompuServe:
>INTERNET:John_Borchert@mindlink.bc.ca
605-1010 Burnaby St. | Voice          : 604-688-9069
Vancouver, BC CANADA | FAX            : 604-688-8986
V6E 4L8              |
--------------------------------------
From: rhaven@cruzio.santa-cruz.ca.us
Newsgroups: comp.databases
Subject: Re: PDOX4.0 USER SLECTION FROM TABLE HELP PLEASE
Summary: Paradox 4.0 addative search criteria
Date: 11 Oct 92 18:20:58 GMT
Article-I.D.: cruzio.4430
Reply-To: rhaven@cruzio.santa-cruz.ca.us



One way would be to create a seconday index for that field and use OrderTable
([Alt-S] I think) to display the table in that seqence.  This already does 
most of your job for you.  You can use a GETEVENT within a WHILE loop to
trap for letters and in each iteration, use LOCATE INDEXORDER userval BESTMATCH
This will put you at the matching record or just after where it would be
if it was in the table.  You can also match the backspace key so the use
r can edit their dynamic search criteria.

To highlight the current record, you can either use the 3.5 style and the 
global canvas or the new 4.0 window interface with a canvas for each window.
When you want to highlight the new record, do something like this:

WINDOW ECHO GetWindow() FALSE
SYNCCURSOR
WINDOW GETATTRIBUTES GetWindow() TO bag
PAINTCANVAS ATTRIBUTE ### ROW(),0,ROW(),(bag["CANVASWIDT"] - 1)

There are lots of optimizations possible, but that's a start.

The other alternative is to load the data into a dynamic array and use a
Dialog box PICKDYNARRAY to have the user pick a value.  It automatically
does the highlighting and letter-search just the way you want it.

Cheers
Newsgroups: comp.databases,comp.os.msdos.apps,comp.sys.ibm.pc.misc
Subject: If I have "Pocket Dot," what DBMS do I have?
Keywords: pocket,dot,dbms,ms-dos
From: chap@art-sy.detroit.mi.us (j chapman flack)
Date: Fri, 09 Oct 92 01:46:12 GMT
Reply-To: chap@art-sy.detroit.mi.us (j chapman flack)