Android Question B4A send multi rows/columns to jRDC2,How To ?

[pmt]

Hello everyone,

I tried to search the forum but didn't found the solutions or I missed something.

For master /detail such as invoice and invoice items ( multi records).
For example:
invoice:
bill no , amount
0001,100.00$

invoice items:
product id, quantity, unit price
01, 5 , 15.00$
02,2, 20.00$
03,9,35.00$
...


How to wrap both master /detail data together and send to jRDC2 server.

Best Regards

 

[Erel]

You should use ExecuteBatch to send multiple commands.

 

[pmt]

Thank you Erel for your reply.

For invoice items as example , there are multiple rows.
If I understand I need to create one row per one command ,right ?

Or

Are there any way to include all rows as parameters for only one command?

Dim cmd As DBCommand
cmd.Initialize
cmd.Name = "InsertMultipleRows"
cmd.Parameters = [Is it possiple to include all rows here ?]

Regards

 

[Erel]

Yes, you need to create one command per row.

 

[pmt]

Thank you Erel for your reply.