|
"Included Columns" in index definition? (MSSQL)
Hi Andy & Sherman I prefer to define all tables (fields, indices and related attributes) with the Magic Data Dictionary. Having all the app design and logic defined and primarily stored in one place (
Hi Andy & Sherman I prefer to define all tables (fields, indices and related attributes) with the Magic Data Dictionary. Having all the app design and logic defined and primarily stored in one place (
|
By
Avgerinos
· #193689
·
|
|
"Included Columns" in index definition? (MSSQL)
Hi magicians :-) When defining an Index In the Data-Repository of XPA (v.3 or 4) and besides the "Index Key Columns", is there any way to specify the "Included Columns" when defining an index for an M
Hi magicians :-) When defining an Index In the Data-Repository of XPA (v.3 or 4) and besides the "Index Key Columns", is there any way to specify the "Included Columns" when defining an index for an M
|
By
Avgerinos
· #193685
·
|
|
DirectSQL removing the ORDER BY clause
Hi again and thanks for all your suggestions Tried all of the proposed solutions, but none of them worked. I also tried a older suggestion that used to work in older versions (by wrapping the SQL stat
Hi again and thanks for all your suggestions Tried all of the proposed solutions, but none of them worked. I also tried a older suggestion that used to work in older versions (by wrapping the SQL stat
|
By
Avgerinos
· #193673
·
|
|
DirectSQL removing the ORDER BY clause
Hi magicians In XPA 3.3c, I have a simple online task that uses a Direct SQL command to select the TOP-10 records from a table: SELECT TOP 10 [product], [price], [volume], [value] FROM [dbo].[orders]
Hi magicians In XPA 3.3c, I have a simple online task that uses a Direct SQL command to select the TOP-10 records from a table: SELECT TOP 10 [product], [price], [volume], [value] FROM [dbo].[orders]
|
By
Avgerinos
· #193665
·
|
|
XPA cannot access network folders (VPN)
Thanks Frederik, you were close ;-) Tried to run the EXE as admin, with no change Then I tried running as Administrator the NET USE command that connects to the network folder (as a different user) An
Thanks Frederik, you were close ;-) Tried to run the EXE as admin, with no change Then I tried running as Administrator the NET USE command that connects to the network folder (as a different user) An
|
By
Avgerinos
· #193421
·
|
|
XPA cannot access network folders (VPN)
Hi magicians Trying to install an XPA3 desktop application, to a brand-new windows-10 laptop. Everything OK except that it cannot access any shared folders (VPN) I can see these folders through the Wi
Hi magicians Trying to install an XPA3 desktop application, to a brand-new windows-10 laptop. Everything OK except that it cannot access any shared folders (VPN) I can see these folders through the Wi
|
By
Avgerinos
· #193419
·
|
|
XPA 4.7 combo box border in tables
Thanks Todd Already uninstalled 4.7. I 'll keep it in mind for next release :-) Best regards Avgerinos
Thanks Todd Already uninstalled 4.7. I 'll keep it in mind for next release :-) Best regards Avgerinos
|
By
Avgerinos
· #193367
·
|
|
XPA 4.7 combo box border in tables
Checked and confirmed. Signs of "brief" beta-testing. BTW, it also seems that the ini-setting for MDIClientImageFile is not recognized (was OK until version 4.6) Finally when I tried to uninstall, it
Checked and confirmed. Signs of "brief" beta-testing. BTW, it also seems that the ini-setting for MDIClientImageFile is not recognized (was OK until version 4.6) Finally when I tried to uninstall, it
|
By
Avgerinos
· #193360
·
|
|
Auto Close application
One more suggestion to add : Since Magic clears the event-queue and disables event-handling when a "Stop" instruction of "Box" type is executed, you need to replace all these alert-boxes with calls to
One more suggestion to add : Since Magic clears the event-queue and disables event-handling when a "Stop" instruction of "Box" type is executed, you need to replace all these alert-boxes with calls to
|
By
Avgerinos
· #193315
·
|
|
HTTPCALL /GET stopped working in XPA versions above 3.2
Hi Todd I tested with version 3.3.h, and the problem is still there. Retested with version 3.2.c (last version that was behaving correctly), and it works fine. Best Regards Avgerinos
Hi Todd I tested with version 3.3.h, and the problem is still there. Retested with version 3.2.c (last version that was behaving correctly), and it works fine. Best Regards Avgerinos
|
By
Avgerinos
· #192782
·
|
|
HTTPCALL /GET stopped working in XPA versions above 3.2
Thanks Todd! I 'm downloading now. I will test during asap, even if I already replaced with some external tool. BTW, I was not getting any "400-BadRequest" error. As far as i can remember, it was fail
Thanks Todd! I 'm downloading now. I will test during asap, even if I already replaced with some external tool. BTW, I was not getting any "400-BadRequest" error. As far as i can remember, it was fail
|
By
Avgerinos
· #192773
·
|
|
OS Command display in a magic window
Hi Andreas, Yes I have the source-code, so I will try your suggestion :-) Many thanks! Avgerinos
Hi Andreas, Yes I have the source-code, so I will try your suggestion :-) Many thanks! Avgerinos
|
By
Avgerinos
· #192731
·
|
|
OS Command display in a magic window
Hi Frederik and thank you for your reply I 'm interested in magic showing the OS window itself inside it own MDI than catching the output of the OS command. I was hooping there would be something alre
Hi Frederik and thank you for your reply I 'm interested in magic showing the OS window itself inside it own MDI than catching the output of the OS command. I was hooping there would be something alre
|
By
Avgerinos
· #192723
·
|
|
OS Command display in a magic window
Hi magicians Is there any way to Invoke an OS command (in my case execute a python script) with the output displayed inside a magic window instead of the classic DOS-window? (XPA versions 3-4) Best re
Hi magicians Is there any way to Invoke an OS command (in my case execute a python script) with the output displayed inside a magic window instead of the classic DOS-window? (XPA versions 3-4) Best re
|
By
Avgerinos
· #192693
·
|
|
HTTPCALL /GET stopped working in XPA versions above 3.2
Hi Todd and thanks for your answer I have all the Magic licenses under maintenance, but I'm afraid that for opening a ticket I need a support contract with MSE Regards Avgerinos
Hi Todd and thanks for your answer I have all the Magic licenses under maintenance, but I'm afraid that for opening a ticket I need a support contract with MSE Regards Avgerinos
|
By
Avgerinos
· #192608
·
|
|
HTTPCALL /GET stopped working in XPA versions above 3.2
Hi magicians This is to report one more case related the the HTTPcall issue already reported to the group for XPA versions. In our case all HTTPcalls (/GET to Coinbase API) that used to work fine in v
Hi magicians This is to report one more case related the the HTTPcall issue already reported to the group for XPA versions. In our case all HTTPcalls (/GET to Coinbase API) that used to work fine in v
|
By
Avgerinos
· #192592
·
|
|
Corrupted LICENSE>DAT file after activation
Hi magicians Documenting the answer to my prior question, in case that someone else faces something similar in the future: What caused the corrupted license file was a mistype of the Host-ID. The acti
Hi magicians Documenting the answer to my prior question, in case that someone else faces something similar in the future: What caused the corrupted license file was a mistype of the Host-ID. The acti
|
By
Avgerinos
· #192193
·
|
|
License for running a batch in Background mode has changed in XPA3.3?
Hi Andreas It's a simple nightly batch task (no events) that runs for a couple of hours and then exits. Magic needs to run in background mode is because it's called via the Windows TaskScheduler. In o
Hi Andreas It's a simple nightly batch task (no events) that runs for a couple of hours and then exits. Magic needs to run in background mode is because it's called via the Windows TaskScheduler. In o
|
By
Avgerinos
· #192192
·
|
|
Corrupted LICENSE>DAT file after activation
Hi magicians Yesterday we tried to register MGENT1 license (XPA3 Enterprise Server) via MSE's activation site. We followed all the steps required for registering based on the Host-ID of the server. Th
Hi magicians Yesterday we tried to register MGENT1 license (XPA3 Enterprise Server) via MSE's activation site. We followed all the steps required for registering based on the Host-ID of the server. Th
|
By
Avgerinos
· #192175
·
|
|
License for running a batch in Background mode has changed in XPA3.3?
Hi Steven and thank you for your answer I cannot recall any or documentation, release notes or kb-article from MSE regarding special licensing required for running in background mode. I am talking abo
Hi Steven and thank you for your answer I cannot recall any or documentation, release notes or kb-article from MSE regarding special licensing required for running in background mode. I am talking abo
|
By
Avgerinos
· #192174
·
|