|
License options
Are there any legitimate alternatives to purchasing xpa 4.6 licenses other than the folks in California? I have heard about the "reseller" channel but I don't know how to contact it.
Thanks
|
|
|
|
Re: Direct SQL Output Variable For SUM Aggregrate Function Not Returned
Mike Moore
Andreas,
Thank you for suggesting CAST: using that produced the exact results intended. I am using the fully qualifying the Schema.Table, so I can quickly replace the schema name, in case the query is needed to access tables in production or test libraries in the DB/2 database server. (I presume there is a way to use an alias defined at the beginning of a series of SQL statements). I failed to completely obscure the data - resulting in the adult ant confusion. ;-) Thanks again for your quick and spot-on response! From: "Andreas Sedlmeier" <sedlmeier@...> To: main@magicu-l.groups.io Date: 07/13/2020 01:39 AM Subject: Re: [magicu-l] Direct SQL Output Variable For SUM Aggregrate Function Not Returned Sent by: main@magicu-l.groups.io I see Ants, where's the adults ? ^^ You should leave away that column aliases and CAST the numeric value to DECIMAL. That I think you have to do always with DB2/400 gateway. Also that SCHEMA.TABLE prefix is not needed. Besides I can not see any reason why that would not work with direct SQL in Magic Best regards, Andreas
|
|
|
|
Re: Blb2File Error
Roman Goldenberg
Hi Wolfgang,
you can do it via sql server without magic. this script work perfectly with sql server 2012 you need permision to run procedures in this script https://stackoverflow.com/questions/29305600/grant-role-to-exec-stored-procedures declare @PdfDataNewFile varbinary(max) --file from sql table
,@FullPathNewFile NVARCHAR(2048)
DECLARE CURSOR_File CURSOR FOR
(
--select binary field
--,output path location
--from table
)
OPEN CURSOR_File
FETCH NEXT FROM CURSOR_file INTO @PdfDataNewFile
,@FullPathNewFile
WHILE @@FETCH_STATUS=0
begin
declare @ObjectToken INT
EXEC sp_OACreate
'ADODB.Stream',
@ObjectToken OUTPUT;
EXEC sp_OASetProperty
@ObjectToken,
'Type',
1;
EXEC sp_OAMethod
@ObjectToken,
'Open';
EXEC sp_OAMethod
@ObjectToken,
'Write',
NULL,
@PdfDataNewFile;
EXEC sp_OAMethod
@ObjectToken,
'SaveToFile',
NULL,
@FullPathNewFile,
2;
EXEC sp_OAMethod
@ObjectToken,
'Close';
EXEC sp_OADestroy
@ObjectToken;
FETCH NEXT FROM CURSOR_File INTO @PdfDataNewFile
,@FullPathNewFile
end
CLOSE CURSOR_File
DEALLOCATE CURSOR_File
|
|
|
|
Re: Blb2File Error
Andreas Sedlmeier
On Mon, Jul 13, 2020 at 07:45 AM, Wolfgang Mayer wrote:
is there one possible to open the documents in Magix XPA 4.6?I dont think so. I do have however no experience with XPA and OLE. I think its completely gone. Manuall converting 360 object does not sound like so much work. You should ask MSE for a migration path (utility). Its them who droppen OLDE support and you are certainly not the only one who suffers from this issue. Remember: There's millions of Magic programmers and myriads of Magic applications ^^ Sorry for no help, Andreas
|
|
|
|
Re: Direct SQL Output Variable For SUM Aggregrate Function Not Returned
Andreas Sedlmeier
I see Ants, where's the adults ? ^^
You should leave away that column aliases and CAST the numeric value to DECIMAL. That I think you have to do always with DB2/400 gateway. Also that SCHEMA.TABLE prefix is not needed. Besides I can not see any reason why that would not work with direct SQL in Magic Best regards, Andreas
|
|
|
|
Direct SQL Output Variable For SUM Aggregrate Function Not Returned
Mike Moore
Using XPA 3.3H and
DB2/400 I am trying Direct SQL for first time.
This statement works perfectly using an interactive SQL studio client: SELECT SCHEMA.TABLE1.FLD21 AS "TourID", SUM(SCHEMA.TABLE2.FLD41) AS "Ants" FROM SCHEMA.TABLE2 INNER JOIN SCHEMA.TABLE1 ON SCHEMA.TABLE2.FLD2 = SCHEMA.TABLE1.FLD2 GROUP BY SCHEMA.TABLE1.FLD21 Returns: TourID Ants CHAR (10) DECIMAL (31, 0) `````````` ``````````````` FSDC 4 3SD 24 SDC 71 PSD 46 F3SD 7 WSD 3 5SD 5 But when I run as Direct SQL (in place of Main Source), on the TourID value is returned. I presume the SQL processor has created the Adults column (with the aggregate SUM) with an length of 31 and the virtual I've defined in the task's data view cannot receive a value that long. Any suggestions? Thanks!
|
|
|
|
Re: Blb2File Error
Wolfgang Mayer
Hello Roman!
It is a Microsoft 2012 SQL Database. greetings from tyrol wolfgang
|
|
|
|
Re: Blb2File Error
Wolfgang Mayer
Hi Andreas.
hm that doesn't sound good. Saving the documents manually is not really an option. there are about 350 records. is there one possible to open the documents in Magix XPA 4.6? Then I could leave the old data records like this and all new data records are only saved to the paths to the documents. greetings from tyrol wolfgang
|
|
|
|
Re: Blb2File Error
Roman Goldenberg
Hi Wolfgang,
What database are you using?
|
|
|
|
Re: Blb2File Error
Andreas Sedlmeier
Hi Wolfgang,
It's not the raw application document format what you have in DB when you use OLE to write to a Blob Variable (OLE object) to there but compound (OLE) storage files. When you want the raw application format you have to revert this and Magic has no functionality to do so automatically / programmatically. If its not a lot what you have in DB, convert your objects manually - otherwise let somebody write you a conversion tool. I am not aware of such a tool. Should be easy to implement. Best regards, Andreas
|
|
|
|
Blb2File Error
Wolfgang Mayer
Hello everybody!
I have a problem with Blb2File. If I export documents (JPG, PDF) from a Blob variable, the files are faulty. The files can be opened in the database. What am I doing wrong? I use UniPaaS 1.9 for this. Exporting the files is necessary as this no longer works in Magic XPA 4.6 with the OLE object. Who has an idea? thx for help Document opened in the database works: 
|
|
|
|
Re: UserFunctionality - View by key doesnt default to the currently in use key
Peter Ashworth
Hi Don
Sorry never got around to replying to this. This is specifically with regards to XPA. In XPA 2.5 it was deprecated even, and was eventually brought back in 3.2. Due to the new .net framework some of these functions like the range/locate/sort/key driven by the keyboard short cuts where no longer natively supported, and Magic have written there own component application that you can reference if you want to bring them back. Due to this they don't work like they used to and are some new flavour of it. Range for instance is more like how sort used to be in magic 9.4 in that its a popup window were you can see all the virtual names rather than being inside the table view itself. And they have managed to recreate the key view but it no longer parks on the current key. And I haven't found a function or ability to by expression figure out progromatically what the current key is. Regards Peter
|
|
|
|
Re: Has anyone an eDeveolper 9.4 runtime license (MGCSRT94) for sale?
Michael
No one?
Please contact me if you have one runtime license V9.4 or more.
|
|
|
|
Re: Installing Pervasive Client via Group Policy
Todd Baremore
toggle quoted messageShow quoted text
|
|
|
|
Installing Pervasive Client via Group Policy
Graham White
Hi,
Does anyone know if there is a way to install the pervasive client via group policy?
Group policy needs a msi installer which I have found inside the exe package but it won’t run as per the message below.
Regards
Graham White
IMPORTANT NOTICE: This e-mail message and any attachments are confidential to EC Credit Control and subject to legal privilege (which is not waived or lost by mistaken delivery). If you have received this e-mail in error, please advise the sender immediately and destroy the message and any attachments. If you are not the intended recipient you are notified that any use, distribution, amendment, copying or any action taken or omitted to be taken in reliance of this message or attachments is prohibited. EC Credit Control collects personal information to provide and market our services (see our privacy policy at: www.eccreditcontrol.co.nz – www.eccreditcontrol.com - www.eccreditcontrol.com.au for more information about use, disclosure and access). EC Credit Control’s liability in connection with transmitting, unauthorised access to, or viruses in this message and its attachments is limited to resupply of any affected message or attachments.
|
|
|
|
Marvin VIDAL
Thanks for your advice, I didn't know docker has that feature. There's a lot that I still have to learn. I'll give it a try and I hope to give my feedback. Regards, Marvin VIDAL
On Sat, Jul 4, 2020 at 8:42 AM Andreas Sedlmeier <sedlmeier@...> wrote: If you run your Magic server in a docker container you can set the MAC address dynamically as a command line parameter for docker run https://docs.docker.com/engine/reference/run/
|
|
|
|
Andreas Sedlmeier
If you run your Magic server in a docker container you can set the MAC address dynamically as a command line parameter for docker run https://docs.docker.com/engine/reference/run/
Maybe helps and works, I dont have Magic Linux (and dont need it when its hardwarebound shit)
|
|
|
|
Marvin VIDAL
If anyone has my same issue, it is because Azure changed my Mac Address. I asked for a new license file to solve it. I hope that I can help someone else. Best regards, Marvin VIDAL
On Thu, Dec 26, 2019 at 6:02 PM vidal.marvin via Groups.Io <vidal.marvin=gmail.com@groups.io> wrote: After setting up the license file in my brand new installation, i have tried to start the broker directly from the command line using "mgxparuntime" and with "startb". In both cases i got the same message in the mgerror.log file:
|
|
|
|
Re: PDF editor
gac@...
|
|
|
|
Re: Invoke WS Lite and https
Andreas Sedlmeier
Hi Adam,
Of course its possible, only there's a TLS version issue since a while. Your Magic version only supports SSL and early TLS and if the TLS version that server you try to connect only has TLS 1.2 or above you are doomed. You can check the SSL/TLS support provided by that server here: https://www.ssllabs.com/ssltest/ If it says its secure because its only has TLS 1.2 and above you need Xpa 4.6, or do your http stuff without Magic. Which is the better plan anyways ^^ Andreas
|
|
|
