Hi, Bibek
But when I write a command for foreign key then it doesn't give me
any error. And I didn't find any doc which say that foreign key is not
supported in android database.
But when i add autoincrement for foreign key then it gives me error.
My query is
sampleDB.execSQL("CREATE TABLE IF NOT EXISTS " +
SWITCH_TABLE_NAME +
" (SwitchID integer autoincrement ,SwitchName
VARCHAR,FOREIGN KEY (SwitchID)REFERENCES roomtable (RoomID));");
and Logcat generate following error :
11-13 14:08:52.892: ERROR/Database(682): Failure 1 (near
"autoincrement": syntax error) on 0x2f95b8 when preparing 'CREATE
TABLE IF NOT EXISTS switchtable (SwitchID integer
autoincrement ,SwitchName VARCHAR,FOREIGN KEY (SwitchID)REFERENCES
roomtable (RoomID));'.
11-13 14:08:52.902: WARN/System.err(682):
android.database.sqlite.SQLiteException: near "autoincrement": syntax
error: CREATE TABLE IF NOT EXISTS switchtable (SwitchID integer
autoincrement ,SwitchName VARCHAR,FOREIGN KEY (SwitchID)REFERENCES
roomtable (RoomID));
11-13 14:08:52.914: WARN/System.err(682): at
android.database.sqlite.SQLiteDatabase.native_execSQL(Native Method)
11-13 14:08:52.924: WARN/System.err(682): at
android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:
1610)
11-13 14:08:52.933: WARN/System.err(682): at
com.monarch.home.AddSwitch.addSwitchToDatabase(AddSwitch.java:186)
11-13 14:08:52.933: WARN/System.err(682): at
com.monarch.home.AddSwitch.onCreate(AddSwitch.java:66)
11-13 14:08:52.944: WARN/System.err(682): at
android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:
1047)
11-13 14:08:52.953: WARN/System.err(682): at
android.app.ActivityThread.performLaunchActivity(ActivityThread.java:
2459)
11-13 14:08:52.964: WARN/System.err(682): at
android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:
2512)
11-13 14:08:52.964: WARN/System.err(682): at
android.app.ActivityThread.access$2200(ActivityThread.java:119)
11-13 14:08:52.964: WARN/System.err(682): at
android.app.ActivityThread$H.handleMessage(ActivityThread.java:1863)
11-13 14:08:52.983: WARN/System.err(682): at
android.os.Handler.dispatchMessage(Handler.java:99)
11-13 14:08:52.994: WARN/System.err(682): at
android.os.Looper.loop(Looper.java:123)
11-13 14:08:53.004: WARN/System.err(682): at
android.app.ActivityThread.main(ActivityThread.java:4363)
11-13 14:08:53.013: WARN/System.err(682): at
java.lang.reflect.Method.invokeNative(Native Method)
11-13 14:08:53.013: WARN/System.err(682): at
java.lang.reflect.Method.invoke(Method.java:521)
11-13 14:08:53.023: WARN/System.err(682): at
com.android.internal.os.ZygoteInit
$MethodAndArgsCaller.run(ZygoteInit.java:860)
11-13 14:08:53.023: WARN/System.err(682): at
com.android.internal.os.ZygoteInit.main(ZygoteInit.java:618)
11-13 14:08:53.023: WARN/System.err(682): at
dalvik.system.NativeStart.main(Native Method)
11-13 14:08:53.614: INFO/ActivityManager(62): Displayed activity
com.monarch.home/.AddSwitch: 981 ms (total 981 ms)
On Nov 13, 12:18 pm, Kumar Bibek <[email protected]> wrote:
> Foreign keys are not supported on SQlite dbs on Android.
>
> On Sat, Nov 13, 2010 at 12:31 PM, pramod.deore
> <[email protected]>wrote:
>
> > Hi, can we autoincrement the foreign key in sqlite database?
> > Thanks
>
> > --
> > You received this message because you are subscribed to the Google
> > Groups "Android Developers" group.
> > To post to this group, send email to [email protected]
> > To unsubscribe from this group, send email to
> > [email protected]<android-developers%[email protected]>
> > For more options, visit this group at
> >http://groups.google.com/group/android-developers?hl=en
>
> --
> Kumar Bibekhttp://techdroid.kbeanie.comhttp://www.kbeanie.com
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
