Subject: | |
From: | |
Reply To: | |
Date: | Sat, 25 Nov 1995 13:30:43 +0000 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
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)
|
|
|