Jump to content

SQL Connector/SQL Query Function limited to 7 parameters only


shakreeelmi

Recommended Posts

Hello, refering to the title. I'm trying to insert my data into my sql server. But i'm having problem sending more than 7 parameters using the SQL Connector/SQL Query Function.

I'm using the SQL project sample to test this, but it doesn't work. The following is the screenshots when the program only works with 7 parameters at maximum. It seems that the status is stuck at "In progress..".

Fail - 8 Parameters:

Fail_8_Param.thumb.PNG.896aa28cd7c33843ab69771fb97ff201.PNG

Fail_8_Param_Script.thumb.PNG.cffb6509aca61dbbcd99a75debc2de53.PNG

 

Success - 7 Parameters:

Success_7_Param.thumb.PNG.19d52401f801d875a95ad1102cf38239.PNG

Success_7_Param_Script.thumb.PNG.1c7d268f26e5c37dbe59eafbbe8b6e92.PNG

 

Link to comment
Share on other sites

17 hours ago, AlexUT said:

Use 2 or more requests and combine results.

 

Yeah that's my solution at the moment. Had to split the query to several number - which means i had to split the sql table columns too.

Nevertheless, is this really the limitation of the sql function, or I'm just doing it wrong?

 

Thanks.

Link to comment
Share on other sites

Great suggestion, Ness,

And follopwing is a link to article about how to use stored procedure:

SQL Dynamic Table Name

https://support.unitronics.com/index.php?/selfhelp/view-article/sql-dynamic-table-name

Tell us if this solve your problem.

The only thing - you have to write stored procedure and take care it is always accessible at SQL server.

B.R.

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

This site uses cookies. By clicking I accept, you agree to their use.