i am executing this query to get UserNamePasswordHash and i am setting value of variable UserID
err = stmt.Prepare(db, _L("SELECT UserNamePasswordHash FROM User WHERE UserID=:UserID")); //TInt err = stmt.Prepare(database, _L("SELECT BinaryField FROM Tbl1")); TInt columnIndex = stmt.ColumnIndex(_L("UserNamePasswordHash")); while((err = stmt.Next()) == KSqlAtRow) { TInt size = stmt. ColumnSize(columnIndex); HBufC8* buf = HBufC8::NewL(size); TPtr8 bufferPtr1 (buf->Des()); err = stmt.ColumnBinary(columnIndex,bufferPtr1); iChitDemoAppUi->BinaryToString(bufferPtr1,usernamePasswordHash); iChitDemoAppUi->Log(bufferPtr1); delete buf; } query is executing properly but i am not getting data in buf if i used hardcoded then it is executed properly in symbian _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users