@Ninett_Panfir, Does the connection we open here closes automatically or Should we need to use Disconnect activity after execute non-query ?
Regards,
Dom
@Ninett_Panfir, Does the connection we open here closes automatically or Should we need to use Disconnect activity after execute non-query ?
Regards,
Dom
You have to use the disconnect activity at the end.
I don’t have any demo, but please let me know if something is not working properly. What I have is related with the tables that I have in my database so is not related with what you want.
Thanks bro i will go home and try it and come back to u
Thanks & regards
Arjun
Hi,
Can you send me the syntax that you are sending to update the table please?
Thanks,
Ninett
hi @Ninett_Panfir
i am sending u the screen ss of my flow pls
this are the screen shots
pls help
thanks & regards
Arjun Parashar
Hi @arjun27 ,
I have tested your situation to my side . I identified that have to change the command type is to “storedprocedure”. If i set it as “Text”, Yes I am getting error what you have specified in the above.
Below i have attached the screen and my sample files also.
In the sample file , It has Execute query and Execute Non Query (Both)
File : Update Database.zip (2.6 KB)
Regards
Balamurugan.S
Hi,
You have to change the property to CommadType to “StoreProcedure” and I am sure that it will work. And please use the activity Execute Non Query, because what your store procedure returns is just the number of the rows that has been affected (number of rows updated).
Thanks,
Ninett
hi,
If it works, what doubt do you have?
Thanks,
Ninett
Hi @arjun27
Before using the execute non query have you given the Connect Activity and use Execute Non Query Activity
Thanks
Ashwin S
Hi @Ninett_Panfir i am back with few doubt
I am using if else activity for finding a leap year
Logic i put is year mod 4 = 0
And after when i run it i put wrong input but then also it is showing me true message box
What i can do in this
Pls help
Thanks & Regards
arjun
Thanks buddy
Hey @sreekanth and @Ninett_Panfir am making a work flow in which i have to select a option from the drop down list i thought of using select item activity but its says control does not select item
pls find the attachment and n help me friends how can i solve it
thanks guys
arjun
@arjun Try to use click and then Type into and check whether you are able to select the value
I am using it but its not clicking just selecting do u have any example for it pls if u have then give me
Thanks
Arjun