-
Miguel Leeuwe
- PowerBuilder
- Tuesday, 22 February 2022 05:33 PM UTC
Today if been trying to get the Sales Demo application to work with Postgresql 13.6.
The on the Github suggested database didn't restore (reported as a bug and will be fixed).
After being pointed to another working version of the database by Mark Lee (
https://github.com/Appeon/PowerBuilder-Project-Example-Database ), when running the app and clicking on the Order button I'm getting errors.
- When opening some datawindows, for none of them it seems to be possible to convert the datasource to 'graphics mode' the simplest select fails to convert.
And then there is this Select that fails in any mode, giving me an error
"
---------------------------
DataWindow
---------------------------
Database error:
SQLSTATE = 42883
ERROR: operator does not exist: boolean = integer;
No query has been executed with that handle
---------------------------
OK
---------------------------
":
The problem seems to be the "FinishedGoodsFlag = 1", if I change the = 1 to be = true, it works:
SELECT
Production.Product.Name ,
Production.Product.ProductNumber ,
Production.Product.Color ,
Production.Product.ListPrice ,
Production.Product.Size ,
Production.Product.ProductSubcategoryID ,
Production.Product.ProductModelID ,
Production.ProductCategory.Name ,
Production.ProductSubcategory.ProductCategoryID ,
Production.ProductSubcategory.Name ,
Production.ProductModel.Name ,
Production.Product.ProductID
FROM
Production.Product ,
Production.ProductCategory ,
Production.ProductModel ,
Production.ProductSubcategory
WHERE
(
Production.ProductModel.ProductModelID = Production.Product.ProductModelID )
and (
Production.ProductSubcategory.ProductCategoryID = Production.ProductCategory.ProductCategoryID )
and (
Production.ProductSubcategory.ProductSubcategoryID = Production.Product.ProductSubcategoryID )
and (
( Production.Product.FinishedGoodsFlag = 1 )
and (
Production.Product.ProductID in
(
SELECT
Sales.SpecialOfferProduct.ProductID
FROM
Sales.SpecialOfferProduct ) ) )
ORDER BY
Production.Product.ProductID ASC
I've seen in the ODBC configuration that there's an option called "bools as char". I've tried to un-check it, but it doesn't make any difference.
Is there some kind of a DB parm I can set to avoid having to change all flags to boolean TRUE or FALSE?
TIA
MiguelL
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.