Javascript-Update command not working.

Question

0.00/5 (No votes)

See more:

C#

function deallocate()                                                       
{
            db1=openDatabase(databasename, version, displayName,maxSize);
            db1.transaction(function(transaction)
            {
               var query='Select t1.cust_code,t2.cust_code from payments t1,invoice t2 where t1.cust_code=t2.cust_code';
               transaction.executeSql(query, [] , function(transaction, result)
                {
                    transaction.executeSql('UPDATE invoice SET inv_amount_paid=?',[0]);
                    transaction.executeSql('UPDATE payments SET amount_alloc=? where pay_number="p3"',[0]);
                });
                   transaction.executeSql('DELETE * FROM allocation WHERE pay_number="p3"');
             },populate_success, transaction_error);
}

My code to update certain rows in tables.It is executing the select command and entering the executeSql but doesn't update the specified rows..What is wrong in the above code..plzz help

Posted 17-Jun-14 23:22pm

p@y@l

Updated 18-Jun-14 0:30am

v4

Add a Solution

Comments

ArunRajendra 18-Jun-14 6:03am

Not working means?

p@y@l 18-Jun-14 6:23am

Its not getting updated or deleted in the database.

Kornfeld Eliyahu Peter 18-Jun-14 6:26am

Have any errors?

p@y@l 18-Jun-14 6:32am

No errors.I have updated the code with success and error method.But it also doesn't show any message.

Kornfeld Eliyahu Peter 18-Jun-14 6:34am

If there is a JavaScrip error (not a logical error) than browsers will 'break-down' in silence in most cases, that's the reason you have to debug it in the browser...

p@y@l 18-Jun-14 6:40am

U mean by putting the breakpoints in browser?

Kornfeld Eliyahu Peter 18-Jun-14 6:41am

Exactly...

p@y@l 23-Jun-14 2:18am

Worked fine...thank u..

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

NitinDhapte · Answer 1 · 2014-06-18T20:03:00

Dear

Change below code :

your code :

C#

transaction.executeSql('UPDATE payments SET amount_alloc=? where pay_number="p3"',[0]);

replace with :

C#

transaction.executeSql("UPDATE payments SET amount_alloc=? where pay_number='p3'",[0]);
OR 
transaction.executeSql('UPDATE payments SET amount_alloc=? where pay_number=\'p3\'',[0]);

your code :

C#

transaction.executeSql('DELETE * FROM allocation WHERE pay_number="p3"');