Jump to content

SQL Connector/SQL Query Function limited to 7 parameters only


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 post
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 post
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 post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...