• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • embbeded SQL in powerbuilder connecting to postgresql

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved embbeded SQL in powerbuilder connecting to postgresql

  1. How-to
0
Votes
Undo
  1. Nguyen Xuan Huy
    Nguyen Xuan Huy
  2. PowerBuilder
  3. Tuesday, 23 May 2023 07:19 AM UTC

Hi all

I have an question about PostgreSQL in powerbuilder script:

select (password = crypt(:vs_password, password)) into :lb_valid from role_user where id = :ll_userid using sqlca;

(ODBC connection)

the ERROR is below

 

database C0038: SQLSTATE = 42883ERROR function crypt( unknown, charecter varying) does not exist

Please help if any solution, thank in advance.

 

PB21 - Manifest file works for me but not other us...
PB 2022 R2 crash on Additional Properties
Responses (3)
Arthur Hefti
Arthur Hefti Accepted Answer Pending Moderation
  1. Thursday, 25 May 2023 03:54 AM UTC
  2. PowerBuilder
  3. # 1

Hi

For PostgreSQL you must use as instead of xx =. In addition it's not necessary to use XXX = .

Try: select crypt(:vs_password, password) into :lb_valid from role_user where id = :ll_userid using sqlca;

Regards
Arthur

Comment
There are no comments made yet.
Peter Pang @Appeon
Peter Pang @Appeon Accepted Answer Pending Moderation
  1. Thursday, 25 May 2023 02:52 AM UTC
  2. PowerBuilder
  3. # 2

Hi Nguyen，

Please open a support ticket in the support portal and please provide a simple PB case & the detailed steps to reproduce the issue, Many thanks in advance.
https://www.appeon.com/standardsupport/

Best Regards,
Peter

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Tuesday, 23 May 2023 10:49 AM UTC
  2. PowerBuilder
  3. # 3

Looks like ODBC for Postgresql is not very complete. Maybe you can solve this by using a stored procedure instead of embedded sql.

regards

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.