FiveTech Support Forums

Dear All ,

I'm currently using the DataRow class to save single records in MariaDB, and it's working well.

Now, I want to integrate XBrowse with DataRow to save multiple records into MariaDB in batch mode. However, I'm unsure whether DataRow supports batch operations.

I'd appreciate any guidance or suggestions on how to achieve this.

Thanks

Shridhar

Dear Antonio ,

Changing the Subject Line as It should be with Only DataRow.

Thanks

Shridhar

I would still strongly recommend placing this logic in the TXBrowse class for a few key reasons:

Direct Access to the Recordset: The TXBrowse class holds the direct reference to the ADO recordset object (oRs). The UpdateBatch() and CancelBatch() functions are native methods of this ADO recordset. My proposed implementation in TXBrowse is simply a clean, direct wrapper that exposes this existing ADO capability.

Class Responsibility: The TXBrowse class is responsible for managing the entire collection of rows displayed in the grid. A batch operation, which acts on this entire collection of modified rows, fits naturally within the scope of TXBrowse. Conversely, the TDataRow class is designed to represent and handle a single row of data, and its Save() method is built for single-record transactions.

Implementation Complexity: To implement this in TDataRow, we would need to create a new mechanism to gather all the modified TDataRow rows, which would be complex and less efficient. The current approach leverages the fact that XBrowse (when used with a client-side cursor) already tracks all the changes in its local ADO cache. My proposed UpdateBatch() method simply tells ADO to send all those cached changes to the database at once.

Given these points, the most robust, efficient, and maintainable solution is to add the UpdateBatch() and CancelBatch() methods to TXBrowse.

Dear Antonio ,

Sorry for the delay in the response.

I am using MariaDB RowSet (not ADO).

TXBrowse to edit invoice detail records, while the master invoice record is handled using a TDataRow. However, using both in combination might cause issues.

My goal is to use a TDataRow array to manage multiple invoice detail records and save them directly to MariaDB, just like a single TDataRow is saved.

I believe this would be a powerful feature—similar to how Hibernate ORM handles object-relational mapping in Java.

Thanks

Shridhar

Hi Shridhar,

I think you can easily do this using TARRAYDATA.

</s>graph TB

%% Clusters
subgraph subGraph4["Array Data Source"]
  TArrayData["TArrayData"]
  ArrayMethods["SetData()&lt;br&gt;Sort()&lt;br&gt;Filter()&lt;br&gt;Append()"]
end

subgraph subGraph3["ADO Data Source"]
  TRecSet["TRecSet"]
  ADOMethods["Open()&lt;br&gt;Find()&lt;br&gt;Filter()&lt;br&gt;Sort()"]
end

subgraph subGraph2["MySQL Data Source"]
  FWMariaConnection["FWMariaConnection"]
  FRecSet["FRecSet"]
  MySQLMethods["Execute()&lt;br&gt;RowSet()&lt;br&gt;CreateTable()"]
end

subgraph subGraph1["DBF Data Source"]
  TDatabase["TDatabase"]
  DBFMethods["Use()&lt;br&gt;SetFilter()&lt;br&gt;SetOrder()&lt;br&gt;Lock()/UnLock()"]
end

subgraph subGraph0["Common Interface Methods"]
  Common["RecCount()&lt;br&gt;RecNo()&lt;br&gt;FieldGet()&lt;br&gt;FieldPut()&lt;br&gt;GoTo()&lt;br&gt;Skip()&lt;br&gt;Bof()/Eof()"]
end

%% Edges reflecting the SVG connections
TArrayData --&gt; ArrayMethods
TArrayData --&gt; Common
TRecSet --&gt; ADOMethods
TRecSet --&gt; Common
FRecSet --&gt; Common
FWMariaConnection --&gt; FRecSet
FWMariaConnection --&gt; MySQLMethods
FWMariaConnection --&gt; Common
TDatabase --&gt; DBFMethods
TDatabase --&gt; Common
<e>