HP3000-L Archives

November 1995, Week 4

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Reply To:
Date:
Sat, 25 Nov 1995 13:30:43 +0000
Content-Type:
text/plain
Parts/Attachments:
text/plain (35 lines)
OK ... Let me throw this one in:
 
I created a TurboIMAGE/XL database (MPEix 5.0), registered its information into a system
catalog of an ALLBASE/SQL DBEnvironment (using the ImageSQL utility),
etc., and am now attempting to access it from a PowerBuilder 4.0 app via ODBC.
 
My current problem is that I can't use retrieval arguments in the
select statement of a DataWindow.  For instance:
 
          SELECT Customer.name
          FROM    Customer
          WHERE  Customer.state = :stateVal
 
where stateVal is the string value of a state such as "CA".  When I
try to do a "Retrieve( stateArgument )" I get an error message such as:
 
          Select Error:  M100??: Driver doesn't support this function
 
or something very similar to this.  And when I check the actual ODBC
calls in the sql.log file I see a question mark where the state code
should be.  So it seems the problem is on the PC side.  Now, if I hard code
the stateVal into the datawindow SQL such as,
 
          ...WHERE Customer.state = "OR"
 
it works just fine.  When I connect to a FoxPro 2.5 database on my PC via
ODBC I'm able to use retrieval arguments.  Therefore, it seems to be in
the ODBC driver DLL.
 
Has anyone experienced similar phenomena?  Has anyone had any success
using PowerBuilder to HP 3000?  I would be interested in hearing
other people's trials/tribulations/successes.
 
Mark Bergan.  (spinning wheels)

ATOM RSS1 RSS2