NetNews Usenet Archive 1993 #1/NN_1993_1.iso/spool/comp/database/sybase/650

Text File | 1993-01-11 | 1.7 KB | 50 lines

Newsgroups: comp.databases.sybase
Path: sparky!uunet!caen!spencer
From: [e-mail] (Spencer W. Thomas)
Subject: APTEXEC bug (5.0)
Message-ID: <[e-mail]>
Date: Mon, 11 Jan 93 15:58:47 EST
Organization: University of Michigan
Distribution: comp
Nntp-Posting-Host: guraldi.itn.med.umich.edu
Lines: 38

 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
[e-mail]    |  313-747-2778, FAX [phone]