HarmonyOS 鸿蒙Next rdb 插入数据报错问题求解：Insert is failed, code is 14800000, message is Inner error. Inner code is -1

你给出的错误信息意味着你的sql语句有语法错误，经测试，将表字段order进行替换，避免与sql关键字冲突。

//demo如下
import RdbStoreUtil from '../comm/utils/RdbStoreUtil';
import { TestModel } from '../model/TestModel';
import { relationalStore } from '[@kit](/user/kit).ArkData';

[@Entry](/user/Entry)
[@Component](/user/Component)
struct TestRdbPage {
 [@State](/user/State) message: string = 'Hello World';
 rdbStore: relationalStore.RdbStore | null = null
 list: TestModel[] = [
   new TestModel(1, '111', '111', 1, 1),
   new TestModel(2, '222', '222', 2, 1),
   new TestModel(3, '333', '333', 1, 1),
   new TestModel(4, '444', '444', 1, 1),
   new TestModel(5, '555', '555', 1, 1),
   new TestModel(6, '666', '666', 1, 1),
   new TestModel(7, '777', '777', 1, 0),
 ]

 insert() {
   const SQL_CREATE_TABLE =
     'CREATE TABLE IF NOT EXISTS TABS (ID INTEGER , NAME TEXT NOT NULL, TEXT TEXT,ORDERNUM INTEGER, selected BOOLEAN)';
   // 'CREATE TABLE IF NOT EXISTS TABS (ID INTEGER , NAME TEXT NOT NULL, TEXT TEXT,ORDER INTEGER, selected BOOLEAN)';//执行出错
   this.rdbStore = RdbStoreUtil.getRdbStore()
   this.rdbStore?.executeSql(SQL_CREATE_TABLE)

   for (let index = 0; index < this.list.length; index++) {
     const valueBucket: relationalStore.ValuesBucket = {
       'id': this.list[index].id,
       'name': this.list[index].name,
       'text': this.list[index].text,
       'ordernum': this.list[index].ordernum,
       // 'order': this.list[index].ordernum,//执行出错
       'selected': this.list[index].selected,
     };
     if (this.rdbStore) {
       (this.rdbStore as relationalStore.RdbStore).insert("TABS", valueBucket, (err, rowId) => {
         if (err) {
           console.error(`Insert is failed, code is ${err.code},message is ${err.message}`);
           return;
         }
         console.info(`Insert is successful, rowId = ${rowId}`);
       })
     }
   }
 }

 build() {
   Column({ space: 10 }) {
     Button('插入数据')
       .onClick(() => {
         this.insert()
       })
   }.justifyContent(FlexAlign.Center)
   .height('100%')
   .width('100%')
 }
}