|
XPA Creating Invalid MS-SQL
Steven Burrows
XPA 2.5d and MSSQL 2014 – Some sites are getting random but regular issues with weird SQL Error message stating that they don’t have sufficient permissions to do an UPDATE or INSERT. This is rubbish as the Application Role they are running under has sys_admin. Running the SQL Profiler, we find the SQL being processed is something like (snipped for breverty)
EXEC sp_executesql N'UPDATE ….using parameters upto :P12', N'@P1 ….@P12', 1, 97, 260000000000005, 19, 350000000000001, 25, 649999999999999, 100, 1, 97, 260000000000005, 19, 350000000000001, 25, 649999999999999, 95, '1901-01-02 00:00:01', '100000003';
Try and run this in SMS and it reports “Procedure or function has too many arguments specified.” Quite right its an error, there are 6 MORE Parameters passed than can be received ! After scratching my beard for a little, I noticed that some of those “,” should be “.”, they are FLOATS! It should be
EXEC sp_executesql N'UPDATE ….using parameters upto :P12', N'@P1 ….@P12', 1, 97.260000000000005, 19.350000000000001, 25.649999999999999, 100, 1, 97.260000000000005, 19.350000000000001, 25.649999999999999, 95, '1901-01-02 00:00:01', '100000003';
Anyone seen anything so horrid before ? Could this be some regional setting ? Any clues before I wrestle with MSE ? This only happens on a customers site of course.
|
|
|
|
|
|
Re: Direct SQL
Jackson, Adam
took off user name and password from connection settings in application and now works!! Need to check if credentials needed but at least got to bottom of it. Thanks
Adam Jackson|Project Manager - Business Systems|McLaren Racing Limited
From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Jackson, Adam <adam.jackson@...>
Sent: Thursday, August 10, 2017 12:20:01 PM To: main@magicu-l.groups.io Subject: Re: [magicu-l] Direct SQL Have looked at database settings and there are a couple of secret names used in “database information” window for username and password. Have asked my DBA to see if that account has sufficient permissions
Adam Jackson | Project Manager – Business Systems | McLaren Racing Limited McLaren Technology Centre, Chertsey Road, Woking, Surrey GU21 4YH, UK
T +44 (0) 01483 261039
From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io]
On Behalf Of Tim Downie
Did you apg the magic task that has your sql statement - if not try this. From:
main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Jackson, Adam <adam.jackson@...>
Change of tack – moved to trying:
select distinct count(loginame) as 'user_count' from sys.sysprocesses
In MSSQL get 75, in excel get 75 in xpa get 1
As before I just cut and pasted the query from MSSQL into both excel and xpa. In xpa I just ran APG and then program. Little or no interference from me as possible yet the simplest of programs does not work – beyond frustrated.
In log with customer setting I get below and when I copy back into MSSQL it works ok.
<106109614830671264> 10/08/2017 11:57:22.265 [Action ] - ,89021 SET IMPLICIT_TRANSACTIONS ON <106109614830671264> 10/08/2017 11:57:22.265 [Action ] - ,89021 STMT: select distinct count(loginame) as 'user_count' from sys.sysprocesses <106109614830671264> 10/08/2017 11:57:22.265 [Action ] - ,89021 STMT: select distinct count(loginame) as 'user_count' from sys.sysprocesses <106109614830671264> 10/08/2017 11:57:22.265 [Action ] - ,89021 logical cursor: using COMMAND :Default result Set <106109614830671264> 10/08/2017 11:57:22.281 [Action ] - ,89037 FETCH Read0 <106109614830671264> 10/08/2017 11:57:22.281 [Action ] - ,89037 SET IMPLICIT_TRANSACTIONS OFF
From:
main@magicu-l.groups.io [mailto:main@magicu-l.groups.io]
On Behalf Of Jackson, Adam
Tried with full developer trace and the only RESULT line was the one record I am getting which BTW is for my connection so could this be a permissions thing? Our DBA says not and all the time my record was the first record I did not question it but now the first record according to MSSQL studio is a NULL/blank record so if my results set was limited to 1 record then surely I would get that?
From:
main@magicu-l.groups.io [mailto:main@magicu-l.groups.io]
On Behalf Of Jackson, Adam
HI,
Tried that and got below which seems OK. Still only showing one record in xpa but 7 in MSSQL Studio
<158285391664954432> 10/08/2017 08:19:11.271 [Action ] - >>Starts load Batch Task - 'C:Get User Count' in Modify mode (Task Instance: 6631, Resident) <158285391664954432> 10/08/2017 08:19:11.271 [Action ] - Ends Load Task <158285391664954432> 10/08/2017 08:19:12.597 [Action ] - Task Mode Change - Modify <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Load records <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Read Transaction 0 <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Commit Transaction 0 <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Starts Record Suffix <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Flow - Call SubTask :: Get count <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - Write Physical Transaction 6632 <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - 2,99398 SET IMPLICIT_TRANSACTIONS ON <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - ,99398 STMT: SELECT distinct loginame as LoginName FROM sys.sysprocesses WHERE DB_NAME(dbid)='Javelin' GROUP BY loginame <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - ,99398 STMT: SELECT distinct loginame as LoginName FROM sys.sysprocesses WHERE DB_NAME(dbid)='Javelin' GROUP BY loginame <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - ,99398 logical cursor: using COMMAND :Default result Set <158285391664954432> 10/08/2017 08:19:12.643 [Action ] - ,99414 FETCH Read0 <158285391664954432> 10/08/2017 08:19:12.643 [Action ] - ,99414 SET IMPLICIT_TRANSACTIONS OFF <158285391664954432> 10/08/2017 08:19:12.643 [Action ] - Commit Transaction 6632 <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Open DB Table - 'C:\Users\adam.jackson\AppData\Local\Temp\MG1761615828539166495443070.mem (#0) (W,N)' <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - >>Starts load Online Task - 'Get count' in Query mode (Task Instance: 6632) <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Ends Load Task <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Task Mode Change - Query <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Read Transaction 0 <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Load records <158285391664954432> 10/08/2017 08:19:12.721 [Action ] - Commit Transaction 0 <158285391664954432> 10/08/2017 08:19:12.721 [Action ] - Flow - Variable Column 'LoginName' (Step Forward) <158285391664954432> 10/08/2017 08:19:14.967 [Action ] - >> Processing Event [Close] Control Name : [ N/A ] <158285391664954432> 10/08/2017 08:19:14.983 [Action ] - >> Processing Event [Exit] Control Name : [ N/A ] <158285391664954432> 10/08/2017 08:19:14.983 [Action ] - Starts Closing Online Task - 'Get count' (Task Instance: 6632) <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - <<Ends Close Task <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Task Mode Change - Modify <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Flow - Condition: Exp = 78, Result = False <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Flow - Call SubTask :: Update [Not Executed] <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Ends Record Suffix <158285391664954432> 10/08/2017 08:19:16.043 [Action ] - Starts Closing Batch Task - 'C:Get User Count' (Task Instance: 6631) <158285391664954432> 10/08/2017 08:19:16.075 [Action ] - <<Ends Close Task <158285391664954432> 10/08/2017 08:19:16.075 [Action ] - >> Processing Event [Exit System] Control Name : [ N/A ] <158285391664954432> 10/08/2017 08:19:16.075 [Info ] - Context released :
From:
main@magicu-l.groups.io [mailto:main@magicu-l.groups.io]
On Behalf Of Tim Downie
Hi From:
main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Jackson, Adam <adam.jackson@...>
No, it is online query with no/before as end task conditions. I literally just pasted query into direct SQL screen, pressed APG option and chose browse then run program. The direct sql task is a sub task of a yes/after batch task that calls the direct sql task in TP but I would expect the online direct SQL task to show me all records
Adam Jackson|Project Manager - Business Systems|McLaren Racing Limited From:
main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Erwin van den Assem via Groups.Io <erwin.assem@...>
Hi Adam
Erwin
The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited. McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478 The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited. McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478
|
|
|
|
|
|
Re: Direct SQL
Jackson, Adam
Have looked at database settings and there are a couple of secret names used in “database information” window for username and password. Have asked my DBA to see if that account has sufficient permissions
Adam Jackson | Project Manager – Business Systems | McLaren Racing Limited McLaren Technology Centre, Chertsey Road, Woking, Surrey GU21 4YH, UK
T +44 (0) 01483 261039
From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io]
On Behalf Of Tim Downie
Sent: 10 August 2017 12:14 To: main@magicu-l.groups.io Subject: Re: [magicu-l] Direct SQL
Did you apg the magic task that has your sql statement - if not try this. From:
main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Jackson, Adam <adam.jackson@...>
Change of tack – moved to trying:
select distinct count(loginame) as 'user_count' from sys.sysprocesses
In MSSQL get 75, in excel get 75 in xpa get 1
As before I just cut and pasted the query from MSSQL into both excel and xpa. In xpa I just ran APG and then program. Little or no interference from me as possible yet the simplest of programs does not work – beyond frustrated.
In log with customer setting I get below and when I copy back into MSSQL it works ok.
<106109614830671264> 10/08/2017 11:57:22.265 [Action ] - ,89021 SET IMPLICIT_TRANSACTIONS ON <106109614830671264> 10/08/2017 11:57:22.265 [Action ] - ,89021 STMT: select distinct count(loginame) as 'user_count' from sys.sysprocesses <106109614830671264> 10/08/2017 11:57:22.265 [Action ] - ,89021 STMT: select distinct count(loginame) as 'user_count' from sys.sysprocesses <106109614830671264> 10/08/2017 11:57:22.265 [Action ] - ,89021 logical cursor: using COMMAND :Default result Set <106109614830671264> 10/08/2017 11:57:22.281 [Action ] - ,89037 FETCH Read0 <106109614830671264> 10/08/2017 11:57:22.281 [Action ] - ,89037 SET IMPLICIT_TRANSACTIONS OFF
From:
main@magicu-l.groups.io [mailto:main@magicu-l.groups.io]
On Behalf Of Jackson, Adam
Tried with full developer trace and the only RESULT line was the one record I am getting which BTW is for my connection so could this be a permissions thing? Our DBA says not and all the time my record was the first record I did not question it but now the first record according to MSSQL studio is a NULL/blank record so if my results set was limited to 1 record then surely I would get that?
From:
main@magicu-l.groups.io [mailto:main@magicu-l.groups.io]
On Behalf Of Jackson, Adam
HI,
Tried that and got below which seems OK. Still only showing one record in xpa but 7 in MSSQL Studio
<158285391664954432> 10/08/2017 08:19:11.271 [Action ] - >>Starts load Batch Task - 'C:Get User Count' in Modify mode (Task Instance: 6631, Resident) <158285391664954432> 10/08/2017 08:19:11.271 [Action ] - Ends Load Task <158285391664954432> 10/08/2017 08:19:12.597 [Action ] - Task Mode Change - Modify <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Load records <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Read Transaction 0 <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Commit Transaction 0 <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Starts Record Suffix <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Flow - Call SubTask :: Get count <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - Write Physical Transaction 6632 <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - 2,99398 SET IMPLICIT_TRANSACTIONS ON <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - ,99398 STMT: SELECT distinct loginame as LoginName FROM sys.sysprocesses WHERE DB_NAME(dbid)='Javelin' GROUP BY loginame <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - ,99398 STMT: SELECT distinct loginame as LoginName FROM sys.sysprocesses WHERE DB_NAME(dbid)='Javelin' GROUP BY loginame <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - ,99398 logical cursor: using COMMAND :Default result Set <158285391664954432> 10/08/2017 08:19:12.643 [Action ] - ,99414 FETCH Read0 <158285391664954432> 10/08/2017 08:19:12.643 [Action ] - ,99414 SET IMPLICIT_TRANSACTIONS OFF <158285391664954432> 10/08/2017 08:19:12.643 [Action ] - Commit Transaction 6632 <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Open DB Table - 'C:\Users\adam.jackson\AppData\Local\Temp\MG1761615828539166495443070.mem (#0) (W,N)' <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - >>Starts load Online Task - 'Get count' in Query mode (Task Instance: 6632) <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Ends Load Task <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Task Mode Change - Query <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Read Transaction 0 <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Load records <158285391664954432> 10/08/2017 08:19:12.721 [Action ] - Commit Transaction 0 <158285391664954432> 10/08/2017 08:19:12.721 [Action ] - Flow - Variable Column 'LoginName' (Step Forward) <158285391664954432> 10/08/2017 08:19:14.967 [Action ] - >> Processing Event [Close] Control Name : [ N/A ] <158285391664954432> 10/08/2017 08:19:14.983 [Action ] - >> Processing Event [Exit] Control Name : [ N/A ] <158285391664954432> 10/08/2017 08:19:14.983 [Action ] - Starts Closing Online Task - 'Get count' (Task Instance: 6632) <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - <<Ends Close Task <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Task Mode Change - Modify <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Flow - Condition: Exp = 78, Result = False <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Flow - Call SubTask :: Update [Not Executed] <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Ends Record Suffix <158285391664954432> 10/08/2017 08:19:16.043 [Action ] - Starts Closing Batch Task - 'C:Get User Count' (Task Instance: 6631) <158285391664954432> 10/08/2017 08:19:16.075 [Action ] - <<Ends Close Task <158285391664954432> 10/08/2017 08:19:16.075 [Action ] - >> Processing Event [Exit System] Control Name : [ N/A ] <158285391664954432> 10/08/2017 08:19:16.075 [Info ] - Context released :
From:
main@magicu-l.groups.io [mailto:main@magicu-l.groups.io]
On Behalf Of Tim Downie
Hi From:
main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Jackson, Adam <adam.jackson@...>
No, it is online query with no/before as end task conditions. I literally just pasted query into direct SQL screen, pressed APG option and chose browse then run program. The direct sql task is a sub task of a yes/after batch task that calls the direct sql task in TP but I would expect the online direct SQL task to show me all records
Adam Jackson|Project Manager - Business Systems|McLaren Racing Limited From:
main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Erwin van den Assem via Groups.Io <erwin.assem@...>
Hi Adam
Erwin
The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited. McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478
|
|
|
|
|
|
Re: Direct SQL
Tim Downie
Did you apg the magic task that has your sql statement - if not try this.
toggle quoted messageShow quoted text
Are you using trusted sql security...or user name/password in magic.ini? Next thing is run and sql magic task to get sql pid. Sql.task with exec sp_who...from memory Then sql profile this session. Im thinking somehow magic is connnecting with a different user/permission
From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Jackson, Adam <adam.jackson@...>
Sent: Thursday, 10 August 2017 11:00:32 AM To: main@magicu-l.groups.io Subject: Re: [magicu-l] Direct SQL Change of tack – moved to trying:
select distinct count(loginame) as 'user_count' from sys.sysprocesses
In MSSQL get 75, in excel get 75 in xpa get 1
As before I just cut and pasted the query from MSSQL into both excel and xpa. In xpa I just ran APG and then program. Little or no interference from me as possible yet the simplest of programs does not work – beyond frustrated.
In log with customer setting I get below and when I copy back into MSSQL it works ok.
<106109614830671264> 10/08/2017 11:57:22.265 [Action ] - ,89021 SET IMPLICIT_TRANSACTIONS ON <106109614830671264> 10/08/2017 11:57:22.265 [Action ] - ,89021 STMT: select distinct count(loginame) as 'user_count' from sys.sysprocesses <106109614830671264> 10/08/2017 11:57:22.265 [Action ] - ,89021 STMT: select distinct count(loginame) as 'user_count' from sys.sysprocesses <106109614830671264> 10/08/2017 11:57:22.265 [Action ] - ,89021 logical cursor: using COMMAND :Default result Set <106109614830671264> 10/08/2017 11:57:22.281 [Action ] - ,89037 FETCH Read0 <106109614830671264> 10/08/2017 11:57:22.281 [Action ] - ,89037 SET IMPLICIT_TRANSACTIONS OFF
From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io]
On Behalf Of Jackson, Adam
Tried with full developer trace and the only RESULT line was the one record I am getting which BTW is for my connection so could this be a permissions thing? Our DBA says not and all the time my record was the first record I did not question it but now the first record according to MSSQL studio is a NULL/blank record so if my results set was limited to 1 record then surely I would get that?
From:
main@magicu-l.groups.io [mailto:main@magicu-l.groups.io]
On Behalf Of Jackson, Adam
HI,
Tried that and got below which seems OK. Still only showing one record in xpa but 7 in MSSQL Studio
<158285391664954432> 10/08/2017 08:19:11.271 [Action ] - >>Starts load Batch Task - 'C:Get User Count' in Modify mode (Task Instance: 6631, Resident) <158285391664954432> 10/08/2017 08:19:11.271 [Action ] - Ends Load Task <158285391664954432> 10/08/2017 08:19:12.597 [Action ] - Task Mode Change - Modify <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Load records <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Read Transaction 0 <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Commit Transaction 0 <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Starts Record Suffix <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Flow - Call SubTask :: Get count <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - Write Physical Transaction 6632 <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - 2,99398 SET IMPLICIT_TRANSACTIONS ON <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - ,99398 STMT: SELECT distinct loginame as LoginName FROM sys.sysprocesses WHERE DB_NAME(dbid)='Javelin' GROUP BY loginame <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - ,99398 STMT: SELECT distinct loginame as LoginName FROM sys.sysprocesses WHERE DB_NAME(dbid)='Javelin' GROUP BY loginame <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - ,99398 logical cursor: using COMMAND :Default result Set <158285391664954432> 10/08/2017 08:19:12.643 [Action ] - ,99414 FETCH Read0 <158285391664954432> 10/08/2017 08:19:12.643 [Action ] - ,99414 SET IMPLICIT_TRANSACTIONS OFF <158285391664954432> 10/08/2017 08:19:12.643 [Action ] - Commit Transaction 6632 <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Open DB Table - 'C:\Users\adam.jackson\AppData\Local\Temp\MG1761615828539166495443070.mem (#0) (W,N)' <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - >>Starts load Online Task - 'Get count' in Query mode (Task Instance: 6632) <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Ends Load Task <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Task Mode Change - Query <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Read Transaction 0 <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Load records <158285391664954432> 10/08/2017 08:19:12.721 [Action ] - Commit Transaction 0 <158285391664954432> 10/08/2017 08:19:12.721 [Action ] - Flow - Variable Column 'LoginName' (Step Forward) <158285391664954432> 10/08/2017 08:19:14.967 [Action ] - >> Processing Event [Close] Control Name : [ N/A ] <158285391664954432> 10/08/2017 08:19:14.983 [Action ] - >> Processing Event [Exit] Control Name : [ N/A ] <158285391664954432> 10/08/2017 08:19:14.983 [Action ] - Starts Closing Online Task - 'Get count' (Task Instance: 6632) <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - <<Ends Close Task <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Task Mode Change - Modify <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Flow - Condition: Exp = 78, Result = False <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Flow - Call SubTask :: Update [Not Executed] <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Ends Record Suffix <158285391664954432> 10/08/2017 08:19:16.043 [Action ] - Starts Closing Batch Task - 'C:Get User Count' (Task Instance: 6631) <158285391664954432> 10/08/2017 08:19:16.075 [Action ] - <<Ends Close Task <158285391664954432> 10/08/2017 08:19:16.075 [Action ] - >> Processing Event [Exit System] Control Name : [ N/A ] <158285391664954432> 10/08/2017 08:19:16.075 [Info ] - Context released :
From:
main@magicu-l.groups.io [mailto:main@magicu-l.groups.io]
On Behalf Of Tim Downie
Hi From:
main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Jackson, Adam <adam.jackson@...>
No, it is online query with no/before as end task conditions. I literally just pasted query into direct SQL screen, pressed APG option and chose browse then run program. The direct sql task is a sub task of a yes/after batch task that calls the direct sql task in TP but I would expect the online direct SQL task to show me all records
Adam Jackson|Project Manager - Business Systems|McLaren Racing Limited From:
main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Erwin van den Assem via Groups.Io <erwin.assem@...>
Hi Adam
Erwin
The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited. McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478
|
|
|
|
|
|
Re: Direct SQL
Jackson, Adam
Change of tack – moved to trying:
select distinct count(loginame) as 'user_count' from sys.sysprocesses
In MSSQL get 75, in excel get 75 in xpa get 1
As before I just cut and pasted the query from MSSQL into both excel and xpa. In xpa I just ran APG and then program. Little or no interference from me as possible yet the simplest of programs does not work – beyond frustrated.
In log with customer setting I get below and when I copy back into MSSQL it works ok.
<106109614830671264> 10/08/2017 11:57:22.265 [Action ] - ,89021 SET IMPLICIT_TRANSACTIONS ON <106109614830671264> 10/08/2017 11:57:22.265 [Action ] - ,89021 STMT: select distinct count(loginame) as 'user_count' from sys.sysprocesses <106109614830671264> 10/08/2017 11:57:22.265 [Action ] - ,89021 STMT: select distinct count(loginame) as 'user_count' from sys.sysprocesses <106109614830671264> 10/08/2017 11:57:22.265 [Action ] - ,89021 logical cursor: using COMMAND :Default result Set <106109614830671264> 10/08/2017 11:57:22.281 [Action ] - ,89037 FETCH Read0 <106109614830671264> 10/08/2017 11:57:22.281 [Action ] - ,89037 SET IMPLICIT_TRANSACTIONS OFF
From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io]
On Behalf Of Jackson, Adam
Sent: 10 August 2017 08:52 To: main@magicu-l.groups.io Subject: Re: [magicu-l] Direct SQL
Tried with full developer trace and the only RESULT line was the one record I am getting which BTW is for my connection so could this be a permissions thing? Our DBA says not and all the time my record was the first record I did not question it but now the first record according to MSSQL studio is a NULL/blank record so if my results set was limited to 1 record then surely I would get that?
From:
main@magicu-l.groups.io [mailto:main@magicu-l.groups.io]
On Behalf Of Jackson, Adam
HI,
Tried that and got below which seems OK. Still only showing one record in xpa but 7 in MSSQL Studio
<158285391664954432> 10/08/2017 08:19:11.271 [Action ] - >>Starts load Batch Task - 'C:Get User Count' in Modify mode (Task Instance: 6631, Resident) <158285391664954432> 10/08/2017 08:19:11.271 [Action ] - Ends Load Task <158285391664954432> 10/08/2017 08:19:12.597 [Action ] - Task Mode Change - Modify <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Load records <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Read Transaction 0 <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Commit Transaction 0 <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Starts Record Suffix <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Flow - Call SubTask :: Get count <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - Write Physical Transaction 6632 <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - 2,99398 SET IMPLICIT_TRANSACTIONS ON <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - ,99398 STMT: SELECT distinct loginame as LoginName FROM sys.sysprocesses WHERE DB_NAME(dbid)='Javelin' GROUP BY loginame <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - ,99398 STMT: SELECT distinct loginame as LoginName FROM sys.sysprocesses WHERE DB_NAME(dbid)='Javelin' GROUP BY loginame <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - ,99398 logical cursor: using COMMAND :Default result Set <158285391664954432> 10/08/2017 08:19:12.643 [Action ] - ,99414 FETCH Read0 <158285391664954432> 10/08/2017 08:19:12.643 [Action ] - ,99414 SET IMPLICIT_TRANSACTIONS OFF <158285391664954432> 10/08/2017 08:19:12.643 [Action ] - Commit Transaction 6632 <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Open DB Table - 'C:\Users\adam.jackson\AppData\Local\Temp\MG1761615828539166495443070.mem (#0) (W,N)' <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - >>Starts load Online Task - 'Get count' in Query mode (Task Instance: 6632) <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Ends Load Task <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Task Mode Change - Query <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Read Transaction 0 <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Load records <158285391664954432> 10/08/2017 08:19:12.721 [Action ] - Commit Transaction 0 <158285391664954432> 10/08/2017 08:19:12.721 [Action ] - Flow - Variable Column 'LoginName' (Step Forward) <158285391664954432> 10/08/2017 08:19:14.967 [Action ] - >> Processing Event [Close] Control Name : [ N/A ] <158285391664954432> 10/08/2017 08:19:14.983 [Action ] - >> Processing Event [Exit] Control Name : [ N/A ] <158285391664954432> 10/08/2017 08:19:14.983 [Action ] - Starts Closing Online Task - 'Get count' (Task Instance: 6632) <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - <<Ends Close Task <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Task Mode Change - Modify <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Flow - Condition: Exp = 78, Result = False <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Flow - Call SubTask :: Update [Not Executed] <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Ends Record Suffix <158285391664954432> 10/08/2017 08:19:16.043 [Action ] - Starts Closing Batch Task - 'C:Get User Count' (Task Instance: 6631) <158285391664954432> 10/08/2017 08:19:16.075 [Action ] - <<Ends Close Task <158285391664954432> 10/08/2017 08:19:16.075 [Action ] - >> Processing Event [Exit System] Control Name : [ N/A ] <158285391664954432> 10/08/2017 08:19:16.075 [Info ] - Context released :
From:
main@magicu-l.groups.io [mailto:main@magicu-l.groups.io]
On Behalf Of Tim Downie
Hi From:
main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Jackson, Adam <adam.jackson@...>
No, it is online query with no/before as end task conditions. I literally just pasted query into direct SQL screen, pressed APG option and chose browse then run program. The direct sql task is a sub task of a yes/after batch task that calls the direct sql task in TP but I would expect the online direct SQL task to show me all records
Adam Jackson|Project Manager - Business Systems|McLaren Racing Limited From:
main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Erwin van den Assem via Groups.Io <erwin.assem@...>
Hi Adam
Erwin
The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited. McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478
|
|
|
|
|
|
Re: Direct SQL
Tim Downie
You need to get to a point you can find the concise sql its running in the magic logs...paste this into sql studio
I only check gateway logging, put a log filename the selected the sql dbms log level to customer. With this you can cut and paste sql.directly from the log to run it The other option use sql profiler to profile the connection From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Stanko Karlovčec <stane@...>
Sent: Thursday, 10 August 2017 7:55:37 AM To: main@magicu-l.groups.io Subject: Re: [magicu-l] Direct SQL HI Adam,
It would be good to look in your DB log file and also check the index settings!?
BR
Stane Stanko Karlovčec Direktor - EPOS Krčkova 15, 2204 Miklavž na D.p. Telephone: +38626290110 / Fax: +386 26290104 / Mobile: +386 41770095 Izjava o omejitvi odgovornosti
|
|
|
|
|
|
Re: Using Font Awesome
Peter Ashworth
Hi Jim
I can't see how you could use Font Awesome natively in magic, because in the font editor you can only zoom and pick fonts installed on windows. (as long as they are true type fonts as they dropped support for some others). Although if anyone else knows differently I would be interested to know. Depending on how many of the icons you want to use, and how many you want to be able to resize/recolour on the fly. If you only have 5 icons of static size and 1 or maybe 2 colours, you could always render them on a web page, screen shot it, edit the photo to give it transparancy (can't remember if transparency is supported 1.9 onwards as we still use 9.4 and it isn't.), and then just render them as local images as and when you want to use them. Although if its wanted in the middle of dynamic length text that's not really workable. Otherwise if you need the resizing and colour, or you want to use lots of them, you could try and find a control (probably a third party dll as I don't think magic has a native control to display web content in the client/server apps, just an rtf control. Although in xpa3.2 you could possibly leverage .net to render some html) to render a small amount of html, and in the header of the html include the links to load font awesome. Neither of these are nice or neat and come across a bit hacky (and I'm not 100% sure how viable the second option is), but depending on your use case might be of some relevance. Hope this helps Peter
|
|
|
|
|
|
Re: Direct SQL
HI Adam,
It would be good to look in your DB log file and also check the index settings!?
BR
Stane Stanko Karlovčec Direktor - EPOS Krčkova 15, 2204 Miklavž na D.p. Telephone: +38626290110 / Fax: +386 26290104 / Mobile: +386 41770095 Izjava o omejitvi odgovornosti
|
|
|
|
|
|
Re: Direct SQL
Jackson, Adam
Tried with full developer trace and the only RESULT line was the one record I am getting which BTW is for my connection so could this be a permissions thing? Our DBA says not and all the time my record was the first record I did not question it but now the first record according to MSSQL studio is a NULL/blank record so if my results set was limited to 1 record then surely I would get that?
From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io]
On Behalf Of Jackson, Adam
Sent: 10 August 2017 08:26 To: main@magicu-l.groups.io Subject: Re: [magicu-l] Direct SQL
HI,
Tried that and got below which seems OK. Still only showing one record in xpa but 7 in MSSQL Studio
<158285391664954432> 10/08/2017 08:19:11.271 [Action ] - >>Starts load Batch Task - 'C:Get User Count' in Modify mode (Task Instance: 6631, Resident) <158285391664954432> 10/08/2017 08:19:11.271 [Action ] - Ends Load Task <158285391664954432> 10/08/2017 08:19:12.597 [Action ] - Task Mode Change - Modify <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Load records <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Read Transaction 0 <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Commit Transaction 0 <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Starts Record Suffix <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Flow - Call SubTask :: Get count <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - Write Physical Transaction 6632 <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - 2,99398 SET IMPLICIT_TRANSACTIONS ON <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - ,99398 STMT: SELECT distinct loginame as LoginName FROM sys.sysprocesses WHERE DB_NAME(dbid)='Javelin' GROUP BY loginame <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - ,99398 STMT: SELECT distinct loginame as LoginName FROM sys.sysprocesses WHERE DB_NAME(dbid)='Javelin' GROUP BY loginame <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - ,99398 logical cursor: using COMMAND :Default result Set <158285391664954432> 10/08/2017 08:19:12.643 [Action ] - ,99414 FETCH Read0 <158285391664954432> 10/08/2017 08:19:12.643 [Action ] - ,99414 SET IMPLICIT_TRANSACTIONS OFF <158285391664954432> 10/08/2017 08:19:12.643 [Action ] - Commit Transaction 6632 <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Open DB Table - 'C:\Users\adam.jackson\AppData\Local\Temp\MG1761615828539166495443070.mem (#0) (W,N)' <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - >>Starts load Online Task - 'Get count' in Query mode (Task Instance: 6632) <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Ends Load Task <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Task Mode Change - Query <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Read Transaction 0 <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Load records <158285391664954432> 10/08/2017 08:19:12.721 [Action ] - Commit Transaction 0 <158285391664954432> 10/08/2017 08:19:12.721 [Action ] - Flow - Variable Column 'LoginName' (Step Forward) <158285391664954432> 10/08/2017 08:19:14.967 [Action ] - >> Processing Event [Close] Control Name : [ N/A ] <158285391664954432> 10/08/2017 08:19:14.983 [Action ] - >> Processing Event [Exit] Control Name : [ N/A ] <158285391664954432> 10/08/2017 08:19:14.983 [Action ] - Starts Closing Online Task - 'Get count' (Task Instance: 6632) <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - <<Ends Close Task <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Task Mode Change - Modify <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Flow - Condition: Exp = 78, Result = False <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Flow - Call SubTask :: Update [Not Executed] <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Ends Record Suffix <158285391664954432> 10/08/2017 08:19:16.043 [Action ] - Starts Closing Batch Task - 'C:Get User Count' (Task Instance: 6631) <158285391664954432> 10/08/2017 08:19:16.075 [Action ] - <<Ends Close Task <158285391664954432> 10/08/2017 08:19:16.075 [Action ] - >> Processing Event [Exit System] Control Name : [ N/A ] <158285391664954432> 10/08/2017 08:19:16.075 [Info ] - Context released :
From:
main@magicu-l.groups.io [mailto:main@magicu-l.groups.io]
On Behalf Of Tim Downie
Hi From:
main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Jackson, Adam <adam.jackson@...>
No, it is online query with no/before as end task conditions. I literally just pasted query into direct SQL screen, pressed APG option and chose browse then run program. The direct sql task is a sub task of a yes/after batch task that calls the direct sql task in TP but I would expect the online direct SQL task to show me all records
Adam Jackson|Project Manager - Business Systems|McLaren Racing Limited From:
main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Erwin van den Assem via Groups.Io <erwin.assem@...>
Hi Adam
Erwin
The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited. McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478
|
|
|
|
|
|
GigaSpace license mechanish
Gábor Bor
Dear Magic Developers!
I would like to ask you, please explain me, how the GigaSpace license management works contrary to Broker's mechanism. (I mean the network broadcast packages) Best regards, Gábor
|
|
|
|
|
|
Re: Direct SQL
Jackson, Adam
HI,
Tried that and got below which seems OK. Still only showing one record in xpa but 7 in MSSQL Studio
<158285391664954432> 10/08/2017 08:19:11.271 [Action ] - >>Starts load Batch Task - 'C:Get User Count' in Modify mode (Task Instance: 6631, Resident) <158285391664954432> 10/08/2017 08:19:11.271 [Action ] - Ends Load Task <158285391664954432> 10/08/2017 08:19:12.597 [Action ] - Task Mode Change - Modify <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Load records <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Read Transaction 0 <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Commit Transaction 0 <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Starts Record Suffix <158285391664954432> 10/08/2017 08:19:12.612 [Action ] - Flow - Call SubTask :: Get count <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - Write Physical Transaction 6632 <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - 2,99398 SET IMPLICIT_TRANSACTIONS ON <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - ,99398 STMT: SELECT distinct loginame as LoginName FROM sys.sysprocesses WHERE DB_NAME(dbid)='Javelin' GROUP BY loginame <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - ,99398 STMT: SELECT distinct loginame as LoginName FROM sys.sysprocesses WHERE DB_NAME(dbid)='Javelin' GROUP BY loginame <158285391664954432> 10/08/2017 08:19:12.628 [Action ] - ,99398 logical cursor: using COMMAND :Default result Set <158285391664954432> 10/08/2017 08:19:12.643 [Action ] - ,99414 FETCH Read0 <158285391664954432> 10/08/2017 08:19:12.643 [Action ] - ,99414 SET IMPLICIT_TRANSACTIONS OFF <158285391664954432> 10/08/2017 08:19:12.643 [Action ] - Commit Transaction 6632 <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Open DB Table - 'C:\Users\adam.jackson\AppData\Local\Temp\MG1761615828539166495443070.mem (#0) (W,N)' <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - >>Starts load Online Task - 'Get count' in Query mode (Task Instance: 6632) <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Ends Load Task <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Task Mode Change - Query <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Read Transaction 0 <158285391664954432> 10/08/2017 08:19:12.706 [Action ] - Load records <158285391664954432> 10/08/2017 08:19:12.721 [Action ] - Commit Transaction 0 <158285391664954432> 10/08/2017 08:19:12.721 [Action ] - Flow - Variable Column 'LoginName' (Step Forward) <158285391664954432> 10/08/2017 08:19:14.967 [Action ] - >> Processing Event [Close] Control Name : [ N/A ] <158285391664954432> 10/08/2017 08:19:14.983 [Action ] - >> Processing Event [Exit] Control Name : [ N/A ] <158285391664954432> 10/08/2017 08:19:14.983 [Action ] - Starts Closing Online Task - 'Get count' (Task Instance: 6632) <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - <<Ends Close Task <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Task Mode Change - Modify <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Flow - Condition: Exp = 78, Result = False <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Flow - Call SubTask :: Update [Not Executed] <158285391664954432> 10/08/2017 08:19:14.998 [Action ] - Ends Record Suffix <158285391664954432> 10/08/2017 08:19:16.043 [Action ] - Starts Closing Batch Task - 'C:Get User Count' (Task Instance: 6631) <158285391664954432> 10/08/2017 08:19:16.075 [Action ] - <<Ends Close Task <158285391664954432> 10/08/2017 08:19:16.075 [Action ] - >> Processing Event [Exit System] Control Name : [ N/A ] <158285391664954432> 10/08/2017 08:19:16.075 [Info ] - Context released :
From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io]
On Behalf Of Tim Downie
Sent: 09 August 2017 22:09 To: main@magicu-l.groups.io Subject: Re: [magicu-l] Direct SQL
Hi From:
main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Jackson, Adam <adam.jackson@...>
No, it is online query with no/before as end task conditions. I literally just pasted query into direct SQL screen, pressed APG option and chose browse then run program. The direct sql task is a sub task of a yes/after batch task that calls the direct sql task in TP but I would expect the online direct SQL task to show me all records
Adam Jackson|Project Manager - Business Systems|McLaren Racing Limited From:
main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Erwin van den Assem via Groups.Io <erwin.assem@...>
Hi Adam
Erwin
The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited. McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478
|
|
|
|
|
|
Re: Direct SQL
Tim Downie
Hi
toggle quoted messageShow quoted text
Turn on the sql gateway logging - the answer to your problem will be in there From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Jackson, Adam <adam.jackson@...>
Sent: Wednesday, 9 August 2017 2:57:33 PM To: main@magicu-l.groups.io Subject: Re: [magicu-l] Direct SQL No, it is online query with no/before as end task conditions. I literally just pasted query into direct SQL screen, pressed APG option and chose browse then run program. The direct sql task is a sub task of a yes/after batch task
that calls the direct sql task in TP but I would expect the online direct SQL task to show me all records
Adam Jackson|Project Manager - Business Systems|McLaren Racing Limited
From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Erwin van den Assem via Groups.Io <erwin.assem@...>
Sent: Wednesday, August 9, 2017 9:08:45 AM To: main@magicu-l.groups.io Subject: Re: [magicu-l] Direct SQL Hi Adam
Erwin The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited. McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478
|
|
|
|
|
|
Re: Direct SQL
Jackson, Adam
No, it is online query with no/before as end task conditions. I literally just pasted query into direct SQL screen, pressed APG option and chose browse then run program. The direct sql task is a sub task of a yes/after batch task
that calls the direct sql task in TP but I would expect the online direct SQL task to show me all records
Adam Jackson|Project Manager - Business Systems|McLaren Racing Limited
From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Erwin van den Assem via Groups.Io <erwin.assem@...>
Sent: Wednesday, August 9, 2017 9:08:45 AM To: main@magicu-l.groups.io Subject: Re: [magicu-l] Direct SQL Hi Adam
Erwin The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited. McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478
|
|
|
|
|
|
Re: Direct SQL
Hi Adam
Erwin
|
|
|
|
|
|
Direct SQL
Jackson, Adam
Hi,
I have a query that returns me 4 records in SQL server but only one when I use it as direct sql. I just coped and pasted query into direct sql screen and used APG option then ran it. I have a return database as Memory. What am I doing wrong?
Xpa 2.5
Adam
The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited. McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478
|
|
|
|
|
|
Re: Android context menu
Todd Baremore
Thanks Newton
On 8/8/2017 6:23 AM, Lawrence Fisher
via Groups.Io wrote:
|
|
|
|
|
|
Re: Android context menu
Lawrence Fisher
Law of conservation of bugs Regards Lawrence Author of the award winning book, "Kill Me Now!", amusing stories from the world of dating
From: Todd Baremore <tbaremor@...> To: main@magicu-l.groups.io Sent: Monday, August 7, 2017 4:12 PM Subject: Re: [magicu-l] Android context menu Thanks Lawrence. Unfortunately it does not work for any controls
placed on a Tab control. :-(
Todd
On 8/7/2017 5:01 AM, Lawrence Fisher
via Groups.Io wrote:
|
|
|
|
|
|
Re: Displaying image from website in a 9.4 application
sherman levine
Steve,
toggle quoted messageShow quoted text
First time's the charm. Many thanks. Didn't even need the header. Sherm
On 08/07/2017 07:34 PM, Steven Blank wrote:
Sherm,
|
|
|
|
|
|
Re: Displaying image from website in a 9.4 application
Sherm,
toggle quoted messageShow quoted text
Try this at home: Update a BLOB variable with the following expression: HTTPGet('https://www.myclient.com/etc/image.jpg', '','') You might have to include a header like 'Content-Type: image/jpg'. But that function should return the file in a blob, which you could then display in a regular image control. I think. Steve Blank
At 04:23 PM 8/7/2017, you wrote:
I'd like to display an image from a website on a form and/or in a table.
|
|
|
|
|
|
Displaying image from website in a 9.4 application
sherman levine
I'd like to display an image from a website on a form and/or in a table.
https://www.myclient.com/etc/image.jpg Is there a straightforward way to accomplish this? Everything else is traditional client-server Thanks Sherm
|
|
|
|
