406 { |
406 { |
407 BindTextL( iStatement.ParameterIndex( |
407 BindTextL( iStatement.ParameterIndex( |
408 KSQLDbValue ), aPropertyValue ); |
408 KSQLDbValue ), aPropertyValue ); |
409 } |
409 } |
410 } |
410 } |
|
411 |
|
412 // --------------------------------------------------------------------------- |
|
413 // |
|
414 // --------------------------------------------------------------------------- |
|
415 // |
|
416 void CCaSqlQuery::BindValuesForGetLocalizationEntryL( |
|
417 const CCaLocalizationEntry& aLocalization) |
|
418 { |
|
419 BindIntL( iStatement.ParameterIndex( KSQLLocRowId ), |
|
420 aLocalization.GetRowId() ); |
|
421 BindTextL( iStatement.ParameterIndex( KSQLLocTable ), |
|
422 aLocalization.GetTableName() ); |
|
423 BindTextL( iStatement.ParameterIndex( KSQLLocAttribute ), |
|
424 aLocalization.GetAttributeName() ); |
|
425 } |
|
426 |
|
427 // --------------------------------------------------------------------------- |
|
428 // |
|
429 // --------------------------------------------------------------------------- |
|
430 // |
|
431 void CCaSqlQuery::BindValuesForLocalizationEntryL( |
|
432 const CCaLocalizationEntry& aLocalization) |
|
433 { |
|
434 BindIntL( iStatement.ParameterIndex( KSQLLocRowId ), |
|
435 aLocalization.GetRowId() ); |
|
436 BindTextL( iStatement.ParameterIndex( KSQLLocTable ), |
|
437 aLocalization.GetTableName() ); |
|
438 BindTextL( iStatement.ParameterIndex( KSQLLocAttribute ), |
|
439 aLocalization.GetAttributeName() ); |
|
440 BindTextL( iStatement.ParameterIndex( KSQLLocQmFilename ), |
|
441 aLocalization.GetQmFilename() ); |
|
442 BindTextL( iStatement.ParameterIndex( KSQLLocString ), |
|
443 aLocalization.GetStringId() ); |
|
444 } |
|
445 |
411 |
446 |
412 // --------------------------------------------------------------------------- |
447 // --------------------------------------------------------------------------- |
413 // |
448 // |
414 // --------------------------------------------------------------------------- |
449 // --------------------------------------------------------------------------- |
415 // |
450 // |
607 |
642 |
608 // --------------------------------------------------------------------------- |
643 // --------------------------------------------------------------------------- |
609 // |
644 // |
610 // --------------------------------------------------------------------------- |
645 // --------------------------------------------------------------------------- |
611 // |
646 // |
|
647 TBool CCaSqlQuery::ExecuteEntryPresentL( ) |
|
648 { |
|
649 if( iStatement.Next() == KSqlAtRow ) |
|
650 { |
|
651 return ETrue; |
|
652 } |
|
653 return EFalse; |
|
654 } |
|
655 |
|
656 // --------------------------------------------------------------------------- |
|
657 // |
|
658 // --------------------------------------------------------------------------- |
|
659 // |
612 TInt CCaSqlQuery::ExecuteL( TInt& aId ) |
660 TInt CCaSqlQuery::ExecuteL( TInt& aId ) |
613 { |
661 { |
614 if( iStatement.Next() == KSqlAtRow ) |
662 if( iStatement.Next() == KSqlAtRow ) |
615 { |
663 { |
616 aId = iStatement.ColumnInt( ColumnIndexL( iStatement, |
664 aId = iStatement.ColumnInt( ColumnIndexL( iStatement, |
741 iStatement.ColumnText( |
789 iStatement.ColumnText( |
742 ColumnIndexL( iStatement, KColumnLocTableName ), |
790 ColumnIndexL( iStatement, KColumnLocTableName ), |
743 tableName ) |
791 tableName ) |
744 ); |
792 ); |
745 |
793 |
|
794 TPtrC qmFilename; |
|
795 User::LeaveIfError( |
|
796 iStatement.ColumnText( |
|
797 ColumnIndexL( iStatement, KColumnQmFile ), |
|
798 qmFilename ) |
|
799 ); |
|
800 |
746 TPtrC attribute; |
801 TPtrC attribute; |
747 User::LeaveIfError( |
802 User::LeaveIfError( |
748 iStatement.ColumnText( |
803 iStatement.ColumnText( |
749 ColumnIndexL( iStatement, KColumnLocAttrName ), |
804 ColumnIndexL( iStatement, KColumnLocAttrName ), |
750 attribute ) |
805 attribute ) |
761 result->SetTextId( locTextId ); |
816 result->SetTextId( locTextId ); |
762 result->SetAttributeNameL( attribute ); |
817 result->SetAttributeNameL( attribute ); |
763 result->SetStringIdL( stringId ); |
818 result->SetStringIdL( stringId ); |
764 result->SetRowId( rowId ); |
819 result->SetRowId( rowId ); |
765 result->SetTableNameL( tableName ); |
820 result->SetTableNameL( tableName ); |
|
821 result->SetQmFilenameL( qmFilename ); |
766 |
822 |
767 aResultInput.AppendL( result ); |
823 aResultInput.AppendL( result ); |
768 CleanupStack::Pop( result ); |
824 CleanupStack::Pop( result ); |
769 rowCount++; |
825 rowCount++; |
770 }//while |
826 }//while |