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

Resolved SQL AnyWhere 11 Error

  1. Issue
0
Votes
Undo
  1. Sufyan Maghur
    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?

Passing message to PowerBuilder application
Display the report header in the first page only
Responses (1)
Chris Pollach @Appeon
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.