Please help writing SQL in JScript.

I need to delete rows from the database when the user cancels out of a form. While in the form, the user may insert rows into a grid, and this is done by a database row insert which doesn't automatically roll back when the user cancels the form.

Can someone please tell me how to put simple sql into JScript and/or just share an example?

Many thanks!!!!

Rick

Find more posts tagged with

BPM

Comments

Karen Frazier

Try this:

function deleteRows()

{

ework.SelectSQL("DELETE FROM [tablename] WHERE [columnname] = '" + ework.[variablename] + "')",[DSN]);

}

Just replace everything inside the [ ] with your custom info.

Regards,

Karen Frazier

Rick Kushner

Great, thanks!!!

DSmith

This is correct except for you have to use EXECSQL,for update, delete and insert statements

and DSN has to be in quotes " "

, but if your deleting tables in the metastorm database, not DSN is needed.

Karen Frazier

I was not aware that a DSN wasn't required for a DELETE statement. Thanks!

Rick Kushner

Yes, thanks. I am using the default metastorm database.

Joshua Kessler

kanangela77 wrote:

Try this:

function deleteRows()

{

ework.SelectSQL("DELETE FROM [tablename] WHERE [columnname] = '" + ework.[variablename] + "')",[DSN]);

}

Just replace everything inside the [ ] with your custom info.

Regards,

Karen Frazier

I am trying to do something similar but this isn't working for me, I get "ework is undefined".

Here is the code I am using:

var countDependents = ework.SelectSQL("select count(distinct(depid)) from ew_mrpbs.isdependentprofile where pin = '"+pin+"' and ACTIVE_FLAG = '"+activeFlag+"'");

I am using a client side validation script that runs on submit on a form.

Brian Mellert

The ework.SelectSQL approach only works in server side scripts.

I am unsure how to do that client side directly. When we have similar needs as I think you're trying to accomplish, we have a client script do client side stuff (are you sure? kind of thing). Then we do buttonClick(serverbutton) which is a hidden server side containing the other code (delete in your case).

Another possibility, again depending on exactly what you're trying to accomplish, may be to have your client validation do and then on the when user saves form handle the delete. If the client stuff fails (e.g. they click cancel on a validation or something) then the server side shouldn't fire off.