Hi Everyone,
I am facing an issue where I am using excel as database and while running it in the Cloud A360, its giving me a syntactical error but the same query is running fine in the On-Prem A360.
Can anyone please help me out with this issue ?
Userlevel 7
+13
Hi
Kindly share the Update query and the output you are getting from it.
It is always advised to use message box while testing with the SQL query to check the output with respect to the query in use.
+5
Hi
Kindly share the Update query and the output you are getting from it.
It is always advised to use message box while testing with the SQL query to check the output with respect to the query in use.
Hi Padmakumar,
The query looks something like below :
Update [Sheet1$$] set Status="Success", Remarks="" where SSN4 like "%$Last4SSN$%" and FirstName="$FirstName$" and LastName="$LastName$" and DateOfBirth='$DtOfBirth$'
As I said, the query is running fine in the on prem VM but its giving me the error - There is a syntactical error in the SQL statement. - SQL statement got timed out. when I am executing it in the cloud VM.
Is it due to package version issue or some other backend issue ?
Userlevel 7
+13
Hi
Kindly share the Update query and the output you are getting from it.
It is always advised to use message box while testing with the SQL query to check the output with respect to the query in use.
Hi Padmakumar,
The query looks something like below :
Update [Sheet1$$] set Status="Success", Remarks="" where SSN4 like "%$Last4SSN$%" and FirstName="$FirstName$" and LastName="$LastName$" and DateOfBirth='$DtOfBirth$'
As I said, the query is running fine in the on prem VM but its giving me the error - There is a syntactical error in the SQL statement. - SQL statement got timed out. when I am executing it in the cloud VM.
Is it due to package version issue or some other backend issue ?
Are you testing this code first time on this environment?
If so, you can try changing the package version. Else, put a Message box just before this Update query and see the output and compare it with the Update query.
Userlevel 5
+9
Are you able to perform the query?
Select Status, Remarks from [Sheet1$$] where SSN4 like "%$Last4SSN$%" and FirstName="$FirstName$" and LastName="$LastName$" and DateOfBirth='$DtOfBirth$'
Regards
+5
Are you able to perform the query?
Select Status, Remarks from [Sheet1$$] where SSN4 like "%$Last4SSN$%" and FirstName="$FirstName$" and LastName="$LastName$" and DateOfBirth='$DtOfBirth$'
Regards
yes Rahul, the select query is working fine
+5
Hi
Kindly share the Update query and the output you are getting from it.
It is always advised to use message box while testing with the SQL query to check the output with respect to the query in use.
Hi Padmakumar,
The query looks something like below :
Update [Sheet1$$] set Status="Success", Remarks="" where SSN4 like "%$Last4SSN$%" and FirstName="$FirstName$" and LastName="$LastName$" and DateOfBirth='$DtOfBirth$'
As I said, the query is running fine in the on prem VM but its giving me the error - There is a syntactical error in the SQL statement. - SQL statement got timed out. when I am executing it in the cloud VM.
Is it due to package version issue or some other backend issue ?
Are you testing this code first time on this environment?
If so, you can try changing the package version. Else, put a Message box just before this Update query and see the output and compare it with the Update query.
Yes I am testing the code for the first time in this environment. I tried updating the database package version but still the same issue.
Userlevel 7
+13
Hi
Kindly share the Update query and the output you are getting from it.
It is always advised to use message box while testing with the SQL query to check the output with respect to the query in use.
Hi Padmakumar,
The query looks something like below :
Update [Sheet1$$] set Status="Success", Remarks="" where SSN4 like "%$Last4SSN$%" and FirstName="$FirstName$" and LastName="$LastName$" and DateOfBirth='$DtOfBirth$'
As I said, the query is running fine in the on prem VM but its giving me the error - There is a syntactical error in the SQL statement. - SQL statement got timed out. when I am executing it in the cloud VM.
Is it due to package version issue or some other backend issue ?
Are you testing this code first time on this environment?
If so, you can try changing the package version. Else, put a Message box just before this Update query and see the output and compare it with the Update query.
Yes I am testing the code for the first time in this environment. I tried updating the database package version but still the same issue.
Ok. Please refer the below articles and see whether either of them is helping or not.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.