Hi Sahil,

See if this example helps. Here I'm taking data from forms, determining they wish to delete a row from SQL, and forming the custom query.

Cheers,

Carl

Hi Sahil,

To delete a row from a table you should just be able to use:

DELETE from [YourDatabase].[dbo].[YourTable] WHERE [YourColumn] = @shortNameToken

And to insert the new row...

INSERT INTO [YourDatabase].[dbo].[YourTable] (YourColumn1, YourColumn2) VALUES (@FormData1, @FormData2)

And just add more columns/values depending on the amount of data you need to insert.

Hope this helps! Dan

Thanks Guys,

I am little scared to touch, so I would put the stuff here, maybe you can give me the correct values:

Database Name: ExternalTables

Table Name: dbo.EmployeeImport

For Existing User:

Column Name : Short (same the value is being queried)

For New User: The complete value is to be created as a Row

Again, the requirement is that all records should be deleted & created.

Thanks so much!

So,

I wrote the query as:

INSERT 
INTO [ExternalTables]
WHERE [Team] = @Team AND [Short] = @Short AND [Name] = @Name AND [LastName] = @LN AND [FirstName] = @FN AND [Position] = @Position AND [Telephone] = @Telephone AND [eMail] = @eMail 

it gave me error:    Custom Query 2    ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'WHERE'.

Hi Sahil,

Basically you have to declare the columns all in one go, then declare the values when using INSERT INTO rather than using the WHERE statement. So I think this is what you're looking for:

INSERT INTO [ExternalTables].[dbo].[EmployeeImport]
(Team, Short, Name, LastName, FirstName, Position, Telephone, eMail)
VALUES
(@Team, @Short, @Name, @LN, @FN, @Position, @Telephone, @eMail)

However this will only work for creating a new row, and not for updating an existing row.

Thanks Dan,

Now I get: 

    25.01.2016 17:23:23    Custom Query 2    ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Team".

I corrected in the Parameters by giving @ sign, but still same error.... :(

Thanks Miruna, Thanks Dan!!!

Anyway the script can be written in a way that if the record exists, to update values?

Or deleting the record & recreating is the only way?

S

To update existing rows you can use:

UPDATE [ExternalTables].[dbo].[EmployeeImport]

SET [Position] = ?

WHERE [Short] = ?

But you'd have to know if the value already existed in the database to know which statement to use, I'm sure there's probably a way to do this but I personally don't know how, sorry! 

Hi,

I think I have run into a serious issue, when I create or delete the WF only takes the first record???

As per the image above I have two tables, how can I make sure that all rows inserted take effect?

S