NewLC - EDbColDateTime insert sql - Comments

Re: EDbColDateTime insert sql

jp4symbian — Fri, 13 Oct 2006 06:54:53 +0200

Thank you so much sdurso, ur post has been of great help to me....

i was getting crazy with inserting a date in the database. But ur post has make my work so easy!!!!

Re: EDbColDateTime insert sql

sdurso — Tue, 19 Jul 2005 11:33:18 +0200

i'm using this fragment of code:

TDbColNo colData=colSet->ColNo(KRiferimentoDataCol);
HBufC* bufData=HBufC::NewLC(view.ColLength(colData));
TInt lenData=view.ColLength(colData);
TPtr bufDataPtr=bufData->Des();
RDbColReadStream inData;
inData.OpenLC(view,colData);
TRAPD(err,inData.ReadL(bufDataPtr));
if (err==KErrEof) {}
inData.Close();
CleanupStack::PopAndDestroy();
CCknInfoDialog::RunDlgLD(_L("Data"),bufData->Des());
CleanupStack::PopAndDestroy(bufData);

but bufData is empty...

do you have any idea??

stefano

Re: EDbColDateTime insert sql

sdurso — Tue, 19 Jul 2005 11:16:36 +0200

ok, fixed: the correct insert is #dd/mm/yyyy# without '

now i have another problem: how can i retrieve this information from the database? how can i READ this date?

thanks

Stefano

EDbColDateTime insert sql

sdurso — Thu, 14 Jul 2005 17:15:27 +0200