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

Resolved UPDATEBLOB only updates 1 row ?

  1. Issue
0
Votes
Undo
  1. Miguel Leeuwe
    Miguel Leeuwe
  2. PowerBuilder
  3. Thursday, 15 June 2023 18:19 PM UTC

Hi,

[EDIT]: it doesn't update even one row. It sets them all to null/empty, while having data in the blob.

I guess I'm going to have to create a test case for this. First I'll check if it has anything to do with build 2797 :s

 

I've used UPDATEBLOB many many times, but I think that today is the first time I want it to update more than one row.

My select returns 51 rows, but only one seem to be updated.

Is this a bug?

 

32 bit application

Windows 10

PB 2019 R3 build 2797

Oracle 19c

 

regards.

Runtime path not found using pbautobild220 in a bu...
Powerclient with ini files example
Accepted Answer
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Friday, 16 June 2023 07:20 AM UTC
  2. PowerBuilder
  3. # Permalink

I didn't realize Ken Guo just confirmed that it doesn't work: https://www.appeon.com/standardsupport/search/view?id=10425

Well "dynamic sql" it is then.

marking this as resolved.

Comment
Load more comments
Andreas Mykonios
  1. Andreas Mykonios
  2. Friday, 16 June 2023 13:24 PM UTC
You are right John. This should be reviewed.

Andreas.
  1. Helpful
Roland Smith
  1. Roland Smith
  2. Friday, 16 June 2023 13:57 PM UTC
Why would you want the same blob on more than one row?
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Friday, 16 June 2023 14:03 PM UTC
@Roland: We store email templates in a field. Now our manager wants to be able to copy one to any others with same description. After the copy you should still be able to make any ajustments to each and every one of them.

@John and @Andreas: I already mentioned in the ticket that I made, that at least the help should mention that only one row can be updated. https://www.appeon.com/standardsupport/search/view?id=10425
  1. Helpful
There are no comments made yet.
Responses (4)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 15 June 2023 18:55 PM UTC
  2. PowerBuilder
  3. # 1

Hi Miguel;

  Yes, a PB Test case App would be the next great step to debug this one!

Regards ... Chris

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 15 June 2023 20:04 PM UTC
  2. PowerBuilder
  3. # 2

Meanwhile, I've made a video to explain my problem a little bit better.

(sorry for the unclear English).

https://drive.google.com/file/d/12q3oZtkYIcvzUyB78JNKjyIJCQekJ1CL/view?usp=sharing

It's not a problem of the new build. I've tried with 2703 and it also fails.

regards.

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Friday, 16 June 2023 07:15 AM UTC
  2. PowerBuilder
  3. # 3

Okay,

I've made a small app in PB 2019 R3, built 2797. (see attached ZIP file).

Database Oracle 19c

Please adapt the open event of the application to connect to your own Oracle database.

DB scripts:

  CREATE TABLE BLOBTEST
   (	REGION VARCHAR2(6 CHAR) NOT NULL ENABLE, 
	STREAM VARCHAR2(3 CHAR) NOT NULL ENABLE, 
	STAGE_NO NUMBER(*,0) NOT NULL ENABLE, 
	REPORT_NAME VARCHAR2(200 CHAR), 
	AUTOEMAIL VARCHAR2(1 CHAR), 
	EMAIL_SUBJECT VARCHAR2(255 CHAR), 
	INCL_CONTACT VARCHAR2(1 CHAR) DEFAULT 'N', 
	EMAIL_BODY NCLOB, 
	SENT_FROM VARCHAR2(255 CHAR), 
	INCL_COPYINVOICE VARCHAR2(1 CHAR) DEFAULT 'N', 
	STAGE_TYPE VARCHAR2(1 CHAR), 
	FALLBACK_EMAILADDRESS VARCHAR2(255 CHAR), 
	USE_TRANSCONTACTS VARCHAR2(1 CHAR) DEFAULT 'N'
   ); 
   
ALTER TABLE BLOBTEST ADD CONSTRAINT PK_BLOBTEST PRIMARY KEY (REGION, STREAM, STAGE_NO);

grant all on BLOBTEST TO PUBLIC;
CREATE PUBLIC SYNONYM BLOBTEST FOR BLOBTEST;

inserts to get some data (don't forget to include the COMMIT: at the end):

REM INSERTING into BLOBTEST
SET DEFINE OFF;
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H01','H01',3,'MIH_Letter2.rpt','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H02','H01',3,'MIH_Letter2.rpt','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H03','H01',3,'MIH_Letter2.rpt','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H04','H01',3,'MIH_Letter2.rpt','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H05','H01',3,'MIH_Letter2.rpt','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H06','H01',3,'MIH_Letter2.rpt','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H21','H01',3,'MIH_Letter2.rpt','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H25','H01',3,'MIH_Letter2.rpt','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H26','H01',3,'MIH_Letter2.rpt','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H27','H01',3,'MIH_Letter2.rpt','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H28','H01',3,'MIH_Letter2.rpt','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('ERROR','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H07','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H08','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H09','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H10','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H11','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H14','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H15','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H16','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H17','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('ERR1','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('ERR2','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('ERR3','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('ERR4','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('ERR5','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('R02','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('R03','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('R04','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('R05','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('R06','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('R07','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('R08','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('R09','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('R10','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('R11','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('R12','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('R13','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('R14','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('R15','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('R16','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('R17','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('TESTML','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('TSTML2','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H18','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H22','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H23','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('H24','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('HW22','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
Insert into BLOBTEST (REGION,STREAM,STAGE_NO,REPORT_NAME,AUTOEMAIL,EMAIL_SUBJECT,INCL_CONTACT,EMAIL_BODY,SENT_FROM,INCL_COPYINVOICE,STAGE_TYPE,FALLBACK_EMAILADDRESS,USE_TRANSCONTACTS) values ('R01','H01',3,'NO','N',null,'N',null,null,'N',null,null,'N');
COMMIT;

 

On the main window there's one button that has an UPDATEBLOB without any WHERE, pretending to update ALL rows.

Doesn't work. Only ONE row is being updated.

Regards.

 

 

Attachments (1)
app_updateblob.zip
Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 16 June 2023 14:07 PM UTC
Perfect .. thanks!

Please open a Support Ticket for this issue & then attach this Test Case to the ticket.

Many thanks in advance!
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Friday, 16 June 2023 14:17 PM UTC
yw, already did yesterday: https://www.appeon.com/standardsupport/search/view?id=10425

regards
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Friday, 16 June 2023 14:17 PM UTC
Ken already confirmed it even before I made the test case :)
  1. Helpful 1
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.