×

Discussion Board

Results 1 to 3 of 3
  1. #1
    Registered User
    Join Date
    Nov 2007
    Posts
    384

    Question select inside select statment in s60 DBMS example

    Hi all,

    I want to know if s60 DBMS example supports select inside select queries like this

    SELECT *
    FROM p
    WHERE (SELECT COUNT(*) FROM sp WHERE sp.pno=p.pno) > 0

    thanks

  2. #2
    Nokia Developer Moderator
    Join Date
    Feb 2006
    Location
    Oslo, Norway
    Posts
    28,734

    Re: select inside select statment in s60 DBMS example

    The old RDBMS (RDbDatabase and its friends) does not support multi-table operations. You can implement the functionality in your code, with nested loops and two RDbRowSet-s.

  3. #3
    Registered User
    Join Date
    Nov 2007
    Posts
    384

    Re: select inside select statment in s60 DBMS example

    thnxs wizard i will try this

Similar Threads

  1. select.select() with server sockets
    By y.a.k in forum Symbian
    Replies: 2
    Last Post: 2007-12-10, 14:20
  2. How to select multiple files in S60 file browser?
    By mike_smith in forum Mobile Java Tools & SDKs
    Replies: 1
    Last Post: 2007-05-25, 10:12
  3. dbms select statement
    By calikus in forum Symbian
    Replies: 2
    Last Post: 2005-10-17, 05:59

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
×