Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

帖子地址:http://gcdn.gcpowertools.com.cn/showtopic-21597-1-1.html

1.添加数据源,选择ODBC驱动,输入连接字符串

下载链接: 驱动下载链接:http://www.ch-werner.de/sqliteodbc/

Image RemovedImage Added


SQLite的连接字符串不正确导致的。
连接字符串中应包含:  DRIVERSqlite的连接字符串格式如:  DRIVER=SQLITE3 ODBC DRIVER;DATABASE=CD:\Users\Documents\SQLite_Test1Data\ArsDemo.db


2. 添加数据集

SELECT * FROM MAIN.CustomersImage Added

查询语句:select * from 财政教育经费 ;

3.

...

在需要使用参数进行数据的筛选,在数据集中添加参数,使用“?”占位符来代替参数引用

如SELECT * FROM MAIN.Customers
WHERE  CustomerID如:select * from 财政教育经费  where 学校名称=? 

Image Removed

添加参数

Image Added

查询语句

Image Added

4、预览结果

Image Added