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:

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

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; -
Clean up the stack.
CleanupClosePushL(myStream);

Write -data into the table

Obtain access to the -data as a stream of characters.
User::LeaveIfErrormyStream.BindTextL(myStatement,myParameterIndex));
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

+ + + + + +Writing +from a Data StreamThis tutorial describes how to write data from a data stream to +a database. +

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:

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

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; +
Clean up the stack.
CleanupClosePushL(myStream);

Write +data into the table

Obtain access to the +data as a stream of characters.
User::LeaveIfErrormyStream.BindTextL(myStatement,myParameterIndex));
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();