1. Sufyan Maghur
  2. PowerBuilder
  3. Friday, 5 January 2024 14:35 PM UTC

Good day...

 

We are trying to ALTER a Table during Execution time in an application... THE SQL Statement is defined as blow (We update the USERS database with structure changes)

 

String ls_SQL_statement

ls_SQL_statement = 'ALTER TABLE "efr_admin"."efr_contribution" ADD "benefit_received" numeric(10,2) DEFAULT NULL'
EXECUTE IMMEDIATE :ls_SQL_statement USING SQLCA;

 

But this error is generated after the EXECUTE

SQLSTATE = S1000
[Sybase][ODBC Driver][SQL Anywhere]Triggers and procedures not supported in runtime server

Any ideas?

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 5 January 2024 15:12 PM UTC
  2. PowerBuilder
  3. # 1

Hi Sufyan;

  Yes, the "Run time" (scaled down) SA DBMS engine does not support that type of DDL interaction. I suspect that this does work in the PB IDE development environment where you have the "full" SA version installed?

  AFAIK you would need to upgrade to the full SA DBMS version for deployment. However, that would now incur a further deployment cost in order to run that SA version in the App User environment.

Regards ... Chris

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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.