Go Back  
Reply
 
Thread Tools
Old 06-10-2012   #1
H3avyRa1n
Senior Member
 
H3avyRa1n's Avatar
 
Join Date: Aug 2011
Posts: 1,270
Likes: 179
Liked 840 Times in 392 Posts
Mentioned: 61 Post(s)
Tagged: 0 Thread(s)
Anyone with android development skills?

How do you make a join of 2 tables?

Simple example:

table A
column1
column2

table B
columnx
columny

how do I join column1 and columny?
tia.
H3avyRa1n is offline   Reply With Quote
Old 06-10-2012   #2
TDMaster
Member
 
TDMaster's Avatar
 
Join Date: Oct 2010
Location: In LVL1
Posts: 325
Likes: 13
Liked 65 Times in 35 Posts
Mentioned: 4 Post(s)
Tagged: 0 Thread(s)
public Cursor rawQuery (String sql, String[] selectionArgs)

rawQuery("select t1.column1 , t2.columnY from table A t1 join table B ON (.....)",null);
__________________
Playstation 3 SLIM 120GB JB
Rogero 4.30 CFW
MultiMan [Latest Version]
TDMaster is offline   Reply With Quote
Likes: (1)
Old 06-11-2012   #3
H3avyRa1n
Senior Member
 
H3avyRa1n's Avatar
 
Join Date: Aug 2011
Posts: 1,270
Likes: 179
Liked 840 Times in 392 Posts
Mentioned: 61 Post(s)
Tagged: 0 Thread(s)
Originally Posted by TDMaster View Post
public Cursor rawQuery (String sql, String[] selectionArgs)

rawQuery("select t1.column1 , t2.columnY from table A t1 join table B ON (.....)",null);
thanks but why a cursor?
H3avyRa1n is offline   Reply With Quote
Old 06-11-2012   #4
superfurry
Senior Member
 
superfurry's Avatar
 
Join Date: Dec 2010
Location: Wales
Posts: 1,297
Likes: 40
Liked 388 Times in 253 Posts
Mentioned: 54 Post(s)
Tagged: 0 Thread(s)
What are to using to build the apps? Eclipse with java?
__________________
superfurry is offline   Reply With Quote
Old 06-11-2012   #5
H3avyRa1n
Senior Member
 
H3avyRa1n's Avatar
 
Join Date: Aug 2011
Posts: 1,270
Likes: 179
Liked 840 Times in 392 Posts
Mentioned: 61 Post(s)
Tagged: 0 Thread(s)
Originally Posted by superfurry View Post
What are to using to build the apps? Eclipse with java?
yes, why?
H3avyRa1n is offline   Reply With Quote
Old 06-11-2012   #6
superfurry
Senior Member
 
superfurry's Avatar
 
Join Date: Dec 2010
Location: Wales
Posts: 1,297
Likes: 40
Liked 388 Times in 253 Posts
Mentioned: 54 Post(s)
Tagged: 0 Thread(s)
Just wondering what you mean by joining 2 tables ?
__________________
superfurry is offline   Reply With Quote
Old 06-11-2012   #7
H3avyRa1n
Senior Member
 
H3avyRa1n's Avatar
 
Join Date: Aug 2011
Posts: 1,270
Likes: 179
Liked 840 Times in 392 Posts
Mentioned: 61 Post(s)
Tagged: 0 Thread(s)
is there other way to do it?
H3avyRa1n is offline   Reply With Quote
Old 06-11-2012   #8
superfurry
Senior Member
 
superfurry's Avatar
 
Join Date: Dec 2010
Location: Wales
Posts: 1,297
Likes: 40
Liked 388 Times in 253 Posts
Mentioned: 54 Post(s)
Tagged: 0 Thread(s)
Do you mean on the layout screen , can't you use place holders for them? Can you explain what your trying to do?
__________________
superfurry is offline   Reply With Quote
Old 06-11-2012   #9
H3avyRa1n
Senior Member
 
H3avyRa1n's Avatar
 
Join Date: Aug 2011
Posts: 1,270
Likes: 179
Liked 840 Times in 392 Posts
Mentioned: 61 Post(s)
Tagged: 0 Thread(s)
I’m trying to make an app with several functionalities and I need to store data. Right now I’m focused in the data model, that’s why I’m trying to understand how to make the queries.
H3avyRa1n is offline   Reply With Quote
Old 06-11-2012   #10
superfurry
Senior Member
 
superfurry's Avatar
 
Join Date: Dec 2010
Location: Wales
Posts: 1,297
Likes: 40
Liked 388 Times in 253 Posts
Mentioned: 54 Post(s)
Tagged: 0 Thread(s)
Well you need to use a database I would of thought ?
__________________
superfurry is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



PS3Hax.net is Copyright © 2010-2013.
Use of this site is governed by our Terms of Use and Privacy Policy. All Trademarks and images are owned by their respected owners.
Posts and links are subject to each author on this forum and are no way affiliated with the operations and/or opinions of ps3hax.net
All times are GMT -5. The time now is 01:21 PM.