Android Question [Solved]How can I update the records in multiple JRDC2 fields?

Johan Hormaza · Aug 9, 2018

I need to update several fields at the same time with a single query.
This is the code I have in the JRDC server file 'config.properties'.

And this is the code in B4A client.

B4X:

    Dim req As DBRequestManager = CreateRequest
    Dim cmd As DBCommand = CreateCommand("update_base_table", Array (col1,col2,col3,col4,col5,col6,col7,col8,col9,col10))
    Dim j As HttpJob = CreateRequest.ExecuteBatch(Array(cmd), Null)
    Wait For (req.ExecuteCommand(cmd,Null)) JobDone(j As HttpJob)
    If j.Success Then
        Log("Update successfully!")
    Else
        Log("ERROR: " & j.ErrorMessage)
    End If
    j.Release

If there is a way to execute the command in SQL, I would appreciate it, because this way it does not work

Thank you.

OliverA · Aug 9, 2018

1) Why does "this way" not work? Any error messages?
2) I think your missing a parameter (specific to your case) when you are using CreateCommand. You're passing all the columns (col1..col10), but you are not passing a parameter for the id = ? part.

Johan Hormaza · Aug 9, 2018

OliverA said:
1) Why does "this way" not work? Any error messages?
2) I think your missing a parameter (specific to your case) when you are using CreateCommand. You're passing all the columns (col1..col10), but you are not passing a parameter for the id = ? part.

I already did it but it still does not work.
This way it seems to work, but it has a problem when it comes to updating the fields since it makes them in disarray.

Johan Hormaza · Aug 9, 2018

OliverA said:
but you are not passing a parameter for the id = ? part.

If it is the variable 'col1'

Erel · Aug 9, 2018

Where is the id parameter?

Johan Hormaza said:
This way it seems to work, but it has a problem when it comes to updating the fields since it makes them in disarray.

What is a disarray?

Johan Hormaza · Aug 9, 2018

Erel said:
What is a disarray?

That has no order, that is, when I edit a specific record, ends up updating another in that way, the table loses order.

Johan Hormaza · Aug 9, 2018

Erel said:
Where is the id parameter?

The variable 'col1' is the id.
The 'id' in the table is an 'id INTEGER PRIMARY KEY AUTO_INCREMENT'

OliverA · Aug 9, 2018

Johan Hormaza said:
the table loses order.

What are you trying to say here? Are you using an ORDER BY clause to sort your displayed data? If not, why would you think a SELECT statement is obligated to return any order at all?

Johan Hormaza said:
The variable 'col1' is the id.
The 'id' in the table is an 'id INTEGER PRIMARY KEY AUTO_INCREMENT'

Why don't you post the full structure of the table (since I can't seem to make sense of the statements).

Johan Hormaza said:
I already did it but it still does not work

Why don't you show us the "fixed" code that you are using (since the one you supplied in post#1 is incorrect as posted).

Johan Hormaza · Aug 9, 2018

OliverA said:
What are you trying to say here? Are you using an ORDER BY clause to sort your displayed data? If not, why would you think a SELECT statement is obligated to return any order at all?

I want to say that when updating a specific field, another ends up being updated.

OliverA said:
Why don't you show us the "fixed" code that you are using (since the one you supplied in post#1 is incorrect as posted).

that is all the code.

Johan Hormaza · Aug 9, 2018

This is the table

Erel · Aug 9, 2018

Where is the SQL command from the configuration file? The order of parameters is preserved. You did a mistake somewhere.

OliverA · Aug 9, 2018

Johan Hormaza said:
This is the table

Then both your config.properties and your client code is wrong (since the config.properties is wrong). BTW, next time post text instead of images (easier to copy/paste/quote).

Config.properties

B4X:

sql.update_base_table=UPDATE Table1 SET col2 = ?,\
   col3 = ?,\
   col4 = ?,\
   col5 = ?,\
   col6 = ?,\
   col7 = ?,\
   col8 = ?,\
   col9 = ?,\
   col10 = ? WHERE id = ?

Client code correction

B4X:

Dim cmd As DBCommand = CreateCommand("update_base_table", Array (col2,col3,col4,col5,col6,col7,col8,col9,col10,col1))

Johan Hormaza · Aug 9, 2018

OliverA said:
Then both your config.properties and your client code is wrong (since the config.properties is wrong). BTW, next time post text instead of images (easier to copy/paste/quote).

Config.properties

B4X:

sql.update_base_table=UPDATE Table1 SET col2 = ?,\ col3 = ?,\ col4 = ?,\ col5 = ?,\ col6 = ?,\ col7 = ?,\ col8 = ?,\ col9 = ?,\ col10 = ? WHERE id = ?

Client code correction

B4X:

Dim cmd As DBCommand = CreateCommand("update_base_table", Array (col2,col3,col4,col5,col6,col7,col8,col9,col10,col1))

Okay. I try it and I warn you. Okay thanks

Johan Hormaza · Aug 9, 2018

Gentlemen thank you very much, @OliverA

OliverA said:
Dim cmd As DBCommand = CreateCommand("update_base_table", Array (col2,col3,col4,col5,col6,col7,col8,col9,col10,'id'))

my brother already works perfectly as you said.

Android Question [Solved]How can I update the records in multiple JRDC2 fields?

Johan Hormaza

Well-Known Member

OliverA

Expert

Johan Hormaza

Well-Known Member

Johan Hormaza

Well-Known Member

Erel

B4X founder

Johan Hormaza

Well-Known Member

Johan Hormaza

Well-Known Member

OliverA

Expert

Johan Hormaza

Well-Known Member

Johan Hormaza

Well-Known Member

Erel

B4X founder

OliverA

Expert

Johan Hormaza

Well-Known Member

Johan Hormaza

Well-Known Member

Similar Threads

Android Question [Solved]How can I update the records in multiple JRDC2 fields?

Well-Known Member

Expert

Well-Known Member

Well-Known Member

B4X founder

Well-Known Member

Well-Known Member

Expert

Well-Known Member

Well-Known Member

B4X founder

Expert

Well-Known Member

Well-Known Member

Similar Threads

Privacy & Transparency

Privacy & Transparency