Retrieving a Particular Row items from Database

[nital_shah]

hi...

i want to show the details of a particular selected Clip...
Clip details like.. File Name, Date Time, Size, Duration, etc..

for this i need to manage a database wid all the required info stored..
i have already created the database..

but now while retrieving, i m passing the Clip FileName which wud b unique, & then i want to retrieve the remaining stored items frm dat particular Row..

is there any fire query type in Symbian like JDBC, SQL Server..
or any other optimum way..???

Thanks in advance...

[sriky27]

Hi,

You could follow the link for the usage of DBMS and the way in which you could retrieve the row from the dbms http://discussion.forum.nokia.com/fo...d.php?t=146914

[skumar_rao]

hi...

i want to show the details of a particular selected Clip...
Clip details like.. File Name, Date Time, Size, Duration, etc..

for this i need to manage a database wid all the required info stored..
i have already created the database..

but now while retrieving, i m passing the Clip FileName which wud b unique, & then i want to retrieve the remaining stored items frm dat particular Row..

is there any fire query type in Symbian like JDBC, SQL Server..
or any other optimum way..???

Thanks in advance...

symbian database is based on some older version of sqlite so it does support some restricted set of sql statements.