cancel
Showing results for 
Search instead for 
Did you mean: 

Error

Former Member
0 Kudos

Good afternoon:


I've migrated an application from pb 9 to pb 12.6.


The reports that I print, are located in the database, that is, I save the datawindows in a field of the database.


When I extract the datawindow from the database, and I upload it in a datastore to print it later, I have this error:


"DataWindow syntax has incorrect relaase number"


The code is the following one:

blob lblb_doc

n_ds ids_print

ls_Syntax = String(lblb_Doc)

//lblb_Doc includes the datawindow saved in the database

// I attach it in another document.

li_RC = ids_print.Create(ls_Syntax)



Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi   Jose;

  Remember that all the DW's that you stored in a blob column of your DB must be migrated to v12.6 as well.

Regards ... Chris

Former Member
0 Kudos

Hi Chris,

All the DW's are migrated to V12.6.

I attach you one of them to give you an example.

If in the DW's stored in the database, before I introduce it in the Datastore, I replace

in the heading as follows :

ls_Syntax = fx_replace(ls_Syntax,'release 12.6;', 'release 9;')

li_RC = ids_print.Create(ls_Syntax)


// It works this way.


The problem is that I don't want to do the replacement every time I use it.

Former Member
0 Kudos

Hi. Jose;

   That's the quick way to make it work but no guarantee that you won't get caught on other syntax changes that should be there besides just the header.

  What I would recommend is to write a utility PB application that performs the following...

A) read the DW syntax from the Blob column using a SelectBlob command & save it as file.

B) use the LibraryImport() method to import the DW source into a work PBL. (This will migrate the DW source to v12.6).

C) use the LibraryExport() method to extract the DW source from the work PBL to a file.

D) Read the DW source file and then use UpdateBlob command to place the DW source back into the DB.

Repeat steps A through D for all DW's in your DB.

Don't forget to save this DW update utility for your next PB upgrade.  

HTH

Regards ... Chris