on 06-20-2016 12:51 PM
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)
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.