vfp操作sqlite数据库？

数据库目录如下，可以想办法添加信息的。
Database: [jxc]
    File name: C:\jxc\jxc.db
    File size: 355328 bytes
    Page size: 1024
    Encoding: UTF-8
    Auto vacuum: 0
    Tables: 30
    Views: 0
    Virtual Tables: 0
------------------------------------------------------------
Table [account_management]
    Fields: 21
        [id]: VARCHAR(100)
            NOT NULL
        [accountNumber]: VARCHAR(100)
        [accountName]: VARCHAR(100)
        [creditCode]: VARCHAR(100)
        [address]: VARCHAR(300)
        [provinceCode]: VARCHAR(300)
        [cityCode]: VARCHAR(300)
        [countyCode]: VARCHAR(300)
        [addressDetails]: VARCHAR(1000)
        [taxpayeCode]: VARCHAR(255)
        [remark]: VARCHAR(1000)
        [contactName]: VARCHAR(100)
        [contactWay]: VARCHAR(200)
        [depositBankName]: VARCHAR(100)
        [depositBankNumber]: VARCHAR(100)
        [depositBankAddress]: VARCHAR(500)
        [accountType]: VARCHAR(10)
        [isImp]: VARCHAR(10)
        [isConvert]: VARCHAR(10)
        [productLicenseCode]: VARCHAR(100)
        [businessLicenseCode]: VARCHAR(100)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [account_management] end
------------------------------------------------------------
Table [common_user]
    Fields: 9
        [id]: VARCHAR(100)
            NOT NULL
        [sex]: VARCHAR(20)
        [identityCode]: VARCHAR(100)
        [telphone]: VARCHAR(300)
        [wechat]: VARCHAR(100)
        [qq]: VARCHAR(255)
        [remark]: VARCHAR(1000)
        [username]: VARCHAR(100)
        [usernamesearch]: VARCHAR(100)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [common_user] end
------------------------------------------------------------
Table [customsetting]
    Fields: 3
        [customkey]: varchar(200)
        [customkeyvalue]: varchar(500)
        [btype]: VARCHAR(100)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [customkey]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [customsetting] end
------------------------------------------------------------
Table [profitloss_management]
    Fields: 13
        [id]: VARCHAR(100)
            NOT NULL
        [formId]: VARCHAR(50)
        [warehouseNum]: VARCHAR(20)
        [productsNumber]: VARCHAR(100)
        [productsName]: VARCHAR(255)
        [specification]: VARCHAR(100)
        [productUnit]: VARCHAR(300)
        [stockAmount]: VARCHAR(20)
        [profitLossNum]: VARCHAR(20)
        [productRemark]: VARCHAR(1000)
        [createDate]: VARCHAR(20)
        [updateDate]: VARCHAR(20)
        [createUserId]: VARCHAR(100)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [profitloss_management] end
------------------------------------------------------------
Table [profitloss_orders]
    Fields: 10
        [id]: VARCHAR(100)
            NOT NULL
        [handlers]: VARCHAR(100)
        [handlersUserId]: VARCHAR(100)
        [formCode]: VARCHAR(50)
        [warehouseNum]: VARCHAR(20)
        [reckonDate]: VARCHAR(20)
        [reckonNo]: VARCHAR(100)
        [createDate]: VARCHAR(20)
        [updateDate]: VARCHAR(20)
        [createUserId]: VARCHAR(100)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [profitloss_orders] end
------------------------------------------------------------
Table [purchase_management]
    Fields: 39
        [id]: VARCHAR(100)
            NOT NULL
        [handlers]: VARCHAR(30)
        [handlersUserId]: VARCHAR(100)
        [formCode]: VARCHAR(50)
        [formId]: VARCHAR(50)
        [twodimensionCode]: VARCHAR(32)
        [buyDate]: VARCHAR(20)
        [supplier]: VARCHAR(300)
        [productsNumber]: VARCHAR(50)
        [productsName]: VARCHAR(255)
        [productionBatch]: VARCHAR(100)
        [productionDate]: VARCHAR(20)
        [validUntil]: VARCHAR(20)
        [productUnit]: VARCHAR(300)
        [saleunit]: VARCHAR(300)
        [productUnivalence]: VARCHAR(20)
        [saleUnivalence]: VARCHAR(20)
        [warningDay]: VARCHAR(300)
        [goodsType]: VARCHAR(300)
        [relationNum]: decimal(15, 3)
        [productAmounts]: VARCHAR(20)
        [identifyCode]: VARCHAR(100)
        [warehouseNum]: VARCHAR(20)
        [specification]: VARCHAR(100)
        [purchaseAmount]: VARCHAR(20)
        [productStatus]: VARCHAR(10)
        [createDate]: VARCHAR(20)
        [updateDate]: VARCHAR(20)
        [createUserId]: VARCHAR(100)
        [salesReturnDate]: VARCHAR(20)
        [dataType]: VARCHAR(20)
        [correlationCode]: varchar(50)
        [salesAmounts]: varchar(20)
        [surplusAmounts]: varchar(20)
        [haveStockRecord]: VARCHAR(20)
        [agricultureNo]: VARCHAR(100)
        [restricpesticides]: VARCHAR(100)
        [productionLicenseCode]: VARCHAR(100)
        [companyName]: VARCHAR(100)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [purchase_management] end
------------------------------------------------------------
Table [purchase_orders]
    Fields: 20
        [id]: VARCHAR(100)
            NOT NULL
        [handlers]: VARCHAR(30)
        [handlersUserId]: VARCHAR(100)
        [formCode]: VARCHAR(50)
        [buyDate]: VARCHAR(20)
        [supplier]: VARCHAR(300)
        [warehouseNum]: VARCHAR(20)
        [productStatus]: VARCHAR(10)
        [totalMoney]: VARCHAR(20)
        [correlationCode]: varchar(50)
        [createDate]: VARCHAR(20)
        [updateDate]: VARCHAR(20)
        [createUserId]: VARCHAR(100)
        [salesReturnDate]: VARCHAR(20)
        [dataType]: VARCHAR(20)
        [haveStockRecord]: VARCHAR(20)
        [readyPay]: VARCHAR(20)
        [surplusPay]: VARCHAR(20)
        [returnMoney]: VARCHAR(20)
        [dataStatus]: VARCHAR(20)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [purchase_orders] end
------------------------------------------------------------
Table [purchase_standing_book]
    Fields: 23
        [id]: VARCHAR(100)
            NOT NULL
        [dataStatus]: VARCHAR(20)
        [restricpesticides]: VARCHAR(100)
        [productionLicenseCode]: VARCHAR(100)
        [SKUCode]: VARCHAR(900)
        [companyName]: VARCHAR(100)
        [supplierName]: VARCHAR(100)
        [licenseCode]: VARCHAR(100)
        [contactWay]: VARCHAR(200)
        [purchaseDate]: varchar(100)
        [twodimensionCode]: VARCHAR(32)
        [purchaseAmounts]: VARCHAR(20)
        [purchaseUnit]: VARCHAR(20)
        [agricultureNo]: VARCHAR(300)
        [productsName]: VARCHAR(255)
        [specification]: VARCHAR(100)
        [productionDate]: VARCHAR(20)
        [productionBatch]: VARCHAR(100)
        [dataType]: VARCHAR(100)
        [formId]: VARCHAR(100)
        [formCode]: VARCHAR(100)
        [dataId]: VARCHAR(100)
        [salesAmounts]: VARCHAR(100)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [purchase_standing_book] end
------------------------------------------------------------
Table [reckon_management]
    Fields: 28
        [id]: VARCHAR(100)
            NOT NULL
        [formId]: VARCHAR(50)
        [warehouseNum]: VARCHAR(20)
        [productsNumber]: VARCHAR(100)
        [productsName]: VARCHAR(255)
        [specification]: VARCHAR(100)
        [productionBatch]: VARCHAR(100)
        [reckonBatch]: VARCHAR(100)
        [stockAmount]: VARCHAR(20)
        [reckoningAmount]: VARCHAR(20)
        [profitLossNum]: VARCHAR(20)
        [productUnit]: VARCHAR(300)
        [productRemark]: VARCHAR(1000)
        [createDate]: VARCHAR(20)
        [updateDate]: VARCHAR(20)
        [createUserId]: VARCHAR(100)
        [cgunit]: varchar(30)
        [cgprice]: decimal(15, 3)
        [saleprice]: decimal(15, 3)
        [relationNum]: decimal(15, 3)
        [separateType]: decimal(1, 0)
        [productionDate]: varchar(100)
        [warningDay]: VARCHAR(300)
        [goodsType]: VARCHAR(300)
        [holderName]: VARCHAR(300)
        [companyName]: VARCHAR(300)
        [agricultureNo]: VARCHAR(300)
        [restricpesticides]: VARCHAR(20)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [reckon_management] end
------------------------------------------------------------
Table [reckon_orders]
    Fields: 12
        [id]: VARCHAR(100)
            NOT NULL
        [handlers]: VARCHAR(100)
        [handlersUserId]: VARCHAR(100)
        [formCode]: VARCHAR(50)
        [warehouseNum]: VARCHAR(20)
        [reckonDate]: VARCHAR(20)
        [createDate]: VARCHAR(20)
        [updateDate]: VARCHAR(20)
        [createUserId]: VARCHAR(100)
        [remark]: VARCHAR(1000)
        [updateType]: VARCHAR(10)
        [isReckon]: VARCHAR(10)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [reckon_orders] end
------------------------------------------------------------
Table [sales_management]
    Fields: 34
        [id]: VARCHAR(100)
            NOT NULL
        [handlers]: VARCHAR(100)
        [handlersUserId]: VARCHAR(100)
        [twodimensionCode]: VARCHAR(32)
        [restricpesticides]: VARCHAR(100)
        [sex]: VARCHAR(300)
        [formId]: VARCHAR(50)
        [formCode]: VARCHAR(50)
        [correlationCode]: VARCHAR(50)
        [salesDate]: VARCHAR(20)
        [clientName]: VARCHAR(300)
        [idCard]: VARCHAR(30)
        [companyName]: VARCHAR(300)
        [productsNumber]: VARCHAR(100)
        [productsName]: VARCHAR(255)
        [productUnit]: VARCHAR(300)
        [productUnivalence]: VARCHAR(20)
        [productAmounts]: VARCHAR(20)
        [purchaseAmount]: VARCHAR(20)
        [identifyCode]: VARCHAR(100)
        [specification]: VARCHAR(100)
        [productStatus]: VARCHAR(10)
        [totalMoney]: VARCHAR(20)
        [createDate]: VARCHAR(20)
        [updateDate]: VARCHAR(20)
        [createUserId]: VARCHAR(100)
        [salesNumber]: VARCHAR(20)
        [surplusAmounts]: VARCHAR(20)
        [salesReturnDate]: VARCHAR(20)
        [dataType]: VARCHAR(20)
        [haveStockRecord]: VARCHAR(20)
        [agricultureNo]: VARCHAR(100)
        [productionLicenseCode]: VARCHAR(100)
        [salesType]: VARCHAR(20)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [sales_management] end
------------------------------------------------------------
Table [sales_orders]
    Fields: 30
        [id]: VARCHAR(100)
            NOT NULL
        [handlers]: VARCHAR(30)
        [handlersUserId]: VARCHAR(100)
        [restricpesticides]: VARCHAR(100)
        [formCode]: VARCHAR(50)
        [returnCode]: VARCHAR(50)
        [salesDate]: VARCHAR(20)
        [companyName]: VARCHAR(300)
        [clientName]: VARCHAR(300)
        [sex]: VARCHAR(300)
        [idCard]: VARCHAR(300)
        [phone]: VARCHAR(30)
        [address]: VARCHAR(300)
        [totalMoney]: VARCHAR(20)
        [accountMoney]: VARCHAR(20)
        [practicalMoney]: VARCHAR(20)
        [advancePayment]: VARCHAR(20)
        [creditAccount]: VARCHAR(20)
        [returnMoney]: VARCHAR(20)
        [barCode]: VARCHAR(300)
        [createDate]: VARCHAR(20)
        [updateDate]: VARCHAR(20)
        [createUserId]: VARCHAR(100)
        [salesReturnDate]: VARCHAR(20)
        [productStatus]: VARCHAR(10)
        [dataType]: VARCHAR(20)
        [haveStockRecord]: VARCHAR(20)
        [salesType]: VARCHAR(20)
        [dataStatus]: VARCHAR(20)
        [remark]: VARCHAR(1000)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [sales_orders] end
------------------------------------------------------------
Table [sales_standing_book]
    Fields: 22
        [id]: VARCHAR(100)
            NOT NULL
        [dataStatus]: VARCHAR(20)
        [agricultureNo]: VARCHAR(300)
        [productsName]: VARCHAR(255)
        [specification]: VARCHAR(100)
        [restricpesticides]: VARCHAR(100)
        [companyName]: VARCHAR(100)
        [productionLicenseCode]: VARCHAR(100)
        [buyers]: VARCHAR(100)
        [buyersIDCard]: VARCHAR(100)
        [salesDate]: varchar(100)
        [twodimensionCode]: VARCHAR(32)
        [goodsNo]: VARCHAR(900)
        [productionDate]: VARCHAR(20)
        [productionBatch]: VARCHAR(100)
        [salesAmounts]: VARCHAR(20)
        [saleunit]: varchar(30)
        [dataType]: VARCHAR(100)
        [formId]: VARCHAR(100)
        [formCode]: VARCHAR(100)
        [salesType]: VARCHAR(10)
        [dataId]: VARCHAR(100)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [sales_standing_book] end
------------------------------------------------------------
Table [sqlite_master]
    Fields: 5
        [type]: TEXT
        [name]: TEXT
        [tbl_name]: TEXT
        [rootpage]: INTEGER
        [sql]: TEXT
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields:
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [sqlite_master] end
------------------------------------------------------------
Table [t_company]
    Fields: 13
        [id]: varchar(100)
        [enterpriseName]: varchar(500)
        [creditCode]: varchar(500)
        [enterpriseProperty]: varchar(100)
        [address]: varchar(1000)
        [zipCode]: varchar(100)
        [businessScope]: varchar(1000)
        [sellRestrictivePesticide]: varchar(500)
        [streetOther]: varchar(500)
        [businessLicenseCode]: VARCHAR(100)
        [phone]: VARCHAR(20)
        [userName]: VARCHAR(20)
        [uploadKey]: VARCHAR(50)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields:
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [t_company] end
------------------------------------------------------------
Table [t_enter_apply]
    Fields: 11
        [id]: varchar(100)
        [userId]: varchar(100)
        [userName]: varchar(50)
        [enterNo]: varchar(100)
        [enterDate]: varchar(100)
        [warehouseNo]: varchar(100)
        [busType]: decimal(2, 0)
        [relationCode]: varchar(100)
        [goodsIds]: varchar(2000)
        [supplierId]: varchar(100)
        [supplierName]: varchar(500)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id];[enterNo]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [t_enter_apply] end
------------------------------------------------------------
Table [t_goodsbrands]
    Fields: 5
        [id]: varchar(300)
        [brandsNo]: varchar(900)
        [brandsName]: varchar(900)
        [state]: varchar(30)
        [remark]: varchar(3000)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields:
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [t_goodsbrands] end
------------------------------------------------------------
Table [t_goodsinfo]
    Fields: 30
        [id]: VARCHAR(100)
            NOT NULL
        [goodsNo]: VARCHAR(900)
        [goodsName]: VARCHAR(100)
        [goodsType]: VARCHAR(300)
        [specification]: VARCHAR(300)
        [warningDay]: VARCHAR(300)
        [cgunit]: varchar(30)
        [saleunit]: varchar(30)
        [relationNum]: decimal(15, 3)
        [agricultureNo]: VARCHAR(300)
        [agricultureName]: VARCHAR(300)
        [agricultureTypeName]: VARCHAR(300)
        [agricultureTypeCode]: VARCHAR(300)
        [agricultureDate]: VARCHAR(300)
        [agricultureState]: VARCHAR(300)
        [holderName]: VARCHAR(300)
        [holderId]: VARCHAR(300)
        [uniqueCode]: VARCHAR(30)
        [state]: VARCHAR(30)
        [restricpesticides]: VARCHAR(20)
        [productcode]: VARCHAR(300)
        [remark]: VARCHAR(900)
        [saleprice]: VARCHAR(20)
        [numberx]: int(20)
        [regularCode]: VARCHAR(20)
        [productionLicenseCode]: VARCHAR(100)
        [companyName]: VARCHAR(100)
        [specificationType]: VARCHAR(100)
        [goodsNameSearch]: VARCHAR(100)
        [twodimensionCode]: VARCHAR(100)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [t_goodsinfo] end
------------------------------------------------------------
Table [t_goodstype]
    Fields: 7
        [id]: varchar(100)
        [name]: varchar(200)
        [pId]: varchar(100)
        [nodeLevel]: int(11)
        [levelOrder]: int(11)
        [disabled]: tinyint(1)
        [typeCode]: varchar(20)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [t_goodstype] end
------------------------------------------------------------
Table [t_goodsunit]
    Fields: 4
        [id]: varchar(100)
        [name]: varchar(200)
        [levelOrder]: int(11)
        [typeCode]: varchar(20)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [t_goodsunit] end
------------------------------------------------------------
Table [t_inventory]
    Fields: 25
        [id]: varchar(100)
            NOT NULL
        [goodsType]: VARCHAR(30)
        [warehouseNo]: varchar(100)
        [goodsNo]: varchar(100)
        [twodimensionCode]: varchar(100)
        [goodsName]: varchar(100)
        [specification]: varchar(100)
        [productionBatch]: varchar(100)
        [productionDate]: varchar(100)
        [validDate]: varchar(100)
        [cgunit]: varchar(30)
        [cgprice]: decimal(15, 3)
        [cgnum]: decimal(15, 3)
        [saleunit]: varchar(100)
        [saleprice]: decimal(15, 3)
        [relationNum]: decimal(15, 3)
        [salenum]: decimal(15, 3)
        [separateType]: decimal(1, 0)
        [enternum]: decimal(15, 3)
        [enterNo]: varchar(100)
        [warningDay]: VARCHAR(300)
        [agricultureNo]: VARCHAR(100)
        [restricpesticides]: VARCHAR(100)
        [productionLicenseCode]: VARCHAR(100)
        [companyName]: VARCHAR(100)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [t_inventory] end
------------------------------------------------------------
Table [t_othersystem_setup]
    Fields: 5
        [id]: varchar(100)
        [salenum]: decimal(15, 3)
        [earlywarnDays]: varchar(100)
        [inventoryWarning]: varchar(100)
        [batchWarning]: varchar(100)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [t_othersystem_setup] end
------------------------------------------------------------
Table [t_out_apply]
    Fields: 11
        [id]: varchar(100)
        [userId]: varchar(100)
        [userName]: varchar(50)
        [outerNo]: varchar(100)
        [outerDate]: varchar(100)
        [warehouseNo]: varchar(100)
        [outType]: decimal(2, 0)
        [relationCode]: varchar(100)
        [goodsIds]: varchar(2000)
        [accountId]: varchar(100)
        [saccountName]: varchar(500)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id];[outerNo]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [t_out_apply] end
------------------------------------------------------------
Table [t_out_goods]
    Fields: 20
        [id]: varchar(100)
        [warehouseNo]: varchar(100)
        [goodsNo]: varchar(100)
        [twodimensionCode]: varchar(100)
        [goodsName]: varchar(100)
        [specification]: varchar(100)
        [productionBatch]: varchar(100)
        [productionDate]: varchar(100)
        [validDate]: varchar(100)
        [saleunit]: varchar(100)
        [saleprice]: decimal(15, 3)
        [salenum]: decimal(15, 3)
        [enterNo]: varchar(100)
        [outremark]: varchar(100)
        [outmoney]: varchar(100)
        [inventoryids]: varchar(2000)
        [agricultureNo]: VARCHAR(100)
        [restricpesticides]: VARCHAR(100)
        [productionLicenseCode]: VARCHAR(100)
        [companyName]: VARCHAR(100)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [t_out_goods] end
------------------------------------------------------------
Table [t_repayment]
    Fields: 9
        [id]: VARCHAR(100)
            NOT NULL
        [handlers]: VARCHAR(30)
        [handlersUserId]: VARCHAR(100)
        [formCode]: VARCHAR(50)
        [payDate]: VARCHAR(20)
        [clientName]: VARCHAR(300)
        [idCard]: VARCHAR(300)
        [phone]: VARCHAR(30)
        [advancePayment]: VARCHAR(20)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [t_repayment] end
------------------------------------------------------------
Table [t_serial_number]
    Fields: 4
        [id]: VARCHAR(100)
            NOT NULL
        [createDate]: VARCHAR(20)
        [numberx]: int(20)
        [regularCode]: VARCHAR(20)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [t_serial_number] end
------------------------------------------------------------
Table [t_specification]
    Fields: 2
        [id]: VARCHAR(100)
            NOT NULL
        [specification]: VARCHAR(200)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [t_specification] end
------------------------------------------------------------
Table [t_specificationtype]
    Fields: 3
        [id]: VARCHAR(100)
            NOT NULL
        [levelOrder]: int(11)
        [specification]: VARCHAR(200)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields: [id]
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [t_specificationtype] end
------------------------------------------------------------
Table [t_sys_region]
    Fields: 12
        [id_]: double
        [name_]: varchar(300)
        [pid_]: double
        [value_]: double
        [code_]: double
        [order_]: double
        [status_]: double
        [level_]: varchar(150)
        [level_code_]: double
        [alias_]: varchar(300)
        [name_en_]: varchar(600)
        [department_id_]: varchar(300)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields:
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [t_sys_region] end
------------------------------------------------------------
Table [xp_user]
    Fields: 7
        [id]: varchar(96)
        [loginName]: varchar(96)
        [name]: varchar(300)
        [role]: Decimal(11)
        [password]: varchar(300)
        [state]: Decimal(2)
        [remark]: VARCHAR(1000)
    Indexes: 0
    Triggers: 0
    Table constraints:
        Primary Key:
            Fields:
            On Conflict:
        Foreign Keys: 0
        Unique constraints: 0
        Check constraints: 0
Table [xp_user] end

意思是：用vfp 把表中记录追加到另一数据库的 Table [sales_standing_book]表中。

谢！

cn=SQLSTRINGCONNECT("driver={SQLite3 ODBC Driver};database=C:\jxc\jxc.db")之后参考有关ODBC操作SQL的方法

连接好数据库和操作DBF差不多吧

数据库接不上呀！

能利用vfp修改中sales_standing_book表的，并且实际操作成功的，请介绍一下详细过程。急需！能指导咱成功实现的，不胜感激！

是的，只操作一个表。

字段编码规则如下：

加我QQ吧：330274961

在网上找的“DevartODBCSQLite.exe”建立的ODBC连接
-------------------------
CLEAR
_Dir=SET("DEFAULT") + SYS(2003) + "\"
_SQL=SQLSTRINGCONNECT("Driver=Devart ODBC Driver for SQLite;database="+_Dir+"jxc.db")
IF !USED('jhxx')
    USE jhxx ALIAS jhxx IN 0
ENDIF

*-表字段和数据库字段类型不一致，怀疑由此导致不能批量插入，期望老师们讲解。
*?SQLEXEC(_SQL,"INSERT INTO id,sales_standing_book (agricultureno,productsName,companyName,specification,salesAmounts,buyers,salesDate) SELECT pdno as 'id',pdno,goods,company,spec,quantity,supplier,lrsj FROM jhxx")
SELECT jhxx
GOTO TOP
DO WHILE !EOF()
    a0 = pdno    &&数据库ID字段作为主键，内容不能空且重复
    a1 = pdno
    a2 = goods
    a3 = company
    a4 = spec
    a5 = quantity
    a6 = supplier
    a7 = lrsj
    ?SQLEXEC(_SQL,"INSERT INTO sales_standing_book (id,agricultureno,productsName,companyName,specification,salesAmounts,buyers,salesDate) VALUES (?a0,?a1,?a2,?a3,?a4,?a5,?a6,?a7)")
    SKIP +1
ENDDO

?SQLEXEC(_SQL,"select id,agricultureno,productsName,companyName,specification,salesAmounts,buyers,salesDate from sales_standing_book")
BROWSE

初步实现了，其实问题正在查找 ；万分感谢！！！

在另一个没有安装odbc的机子上使用，显示，连接句柄无效！
有没有办法把odbc连编到vfp中。让别的机子只要装上我的vfp,就可以操作他电脑上的jxc.db呢？

感谢fyyylyl
结帖时漏给分了，
在此特别鸣谢！！！

以下是程序的启动界面：

以下是上传之后的目标表截图，可以看到已经新增了若干条记录：

太棒了