Writing from a Data Stream

Introduction

This is useful when populating your database with the results of some other operation.

Basic procedure

The high level steps to write from a data stream to a database table are shown here:

1. Instantiate the necessary objects.

2. Write data into the table.

3. Commit the stream.

Writing from a data stream into a table

The process of writing data from a data stream into a table can be explained as follows:

Instantiate the necessary objects

1. Instantiate an object of the RSqlStatement and RSqlParamWriteStream class. Also declare the variables as shown.

   RSqlStatement myStatement;
   TInt err;
   TInt myParameterIndex;
   RSqlParamWriteStream myStream;
   RBuf buf;
   

2. Clean up the stack.

   CleanupClosePushL(myStream);

Write data into the table

1. Obtain access to the data as a stream of characters.

   User::LeaveIfErrormyStream.BindTextL(myStatement,myParameterIndex));

2. Write the buffer.

   myStream.WriteL(buf);

Commit the stream

Commit the stream. This ensures that the streamed data is written into the table and cannot be rolled back.

myStream.CommitL();

See also

Querying a Database

Inserting a Row into a Table

Deleting Rows from a Table

Reading to a Buffer

Reading to Memory

Reading to a Data Stream

Writing from a Data Stream - This document

Performing Scalar Queries