Insert different datas to different table from a single insert query in sqlite in android

Question

I wanted to insert different values to, two different sqlite tables from a single insert query.Can any one help me out...........

Jaya Mayu · Accepted Answer · 2013-03-11 10:46:22Z

1

Why can't you do it in two lines?? Programme will execute one after another.

You can do something as below

dbHelper = new RdmsDbAdapter(SDCardVideoActivity.this);
dbHelper.open();
dbHelper.executeSQL("CREATE TABLE IF NOT EXISTS videos(urls text)");
dbHelper.executeSQL("insert into videos values ('"+outputfilepathVideo+"', '"+IncidentFormActivity.incident_id+"')");
dbHelper.executeSQL("CREATE TABLE IF NOT EXISTS audios(urls text)");
dbHelper.executeSQL("insert into audios values ('"+outputfilepathAudio+"', '"+IncidentFormActivity.incident_id+"')");
dbHelper.close();

Learn on how to handle sqlite with Android here.

answered Mar 11, 2013 at 10:46

Jaya Mayu

17.3k35 gold badges116 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Selvin Over a year ago

from docs: execSQL(String sql, Object[] bindArgs) Execute a single SQL statement that is NOT a SELECT/INSERT/UPDATE/DELETE.

Jaya Mayu Over a year ago

@Selvin I know. Its a custom function I wrote for the ease of use. That's why I've given link to Vogella's tutorial which uses the standard methods.

Collectives™ on Stack Overflow

Insert different datas to different table from a single insert query in sqlite in android

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related