shakreeelmi Posted November 2, 2020 Report Share Posted November 2, 2020 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: Success - 7 Parameters: Link to comment Share on other sites More sharing options...
AlexUT Posted November 2, 2020 Report Share Posted November 2, 2020 Use 2 or more requests and combine results. Link to comment Share on other sites More sharing options...
shakreeelmi Posted November 3, 2020 Author Report Share Posted November 3, 2020 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 More sharing options...
Ness Posted November 3, 2020 Report Share Posted November 3, 2020 One easy work around is to use a stored procedure, from what I've seem that seems to allow an unlimited number of input parameters. Link to comment Share on other sites More sharing options...
AlexUT Posted November 4, 2020 Report Share Posted November 4, 2020 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now