从Oracle获取数据到InfoPath [英] Get data from Oracle into InfoPath

问题描述

从Oracle到InfoPath的数据.我被创造了 链接服务器.我正在获取数据连接基础OPENQUERY:选择 *来自OPENQUERY(ORADB，选择*来自DBCUSTOMER，位于....") 是否建议通过InfoPath变量在sql数据连接中动态输入WHERE?

I'm trying to get data from Oracle into InfoPath. I am created linked server. I am getting data connection base OPENQUERY: select * from OPENQUERY (ORADB, 'select * from DBCUSTOMER where ....') Is it advisable to dynamically input WHERE in a sql data connection from InfoPath variables?

推荐答案

当您为数据库源配置数据连接时，使用where子句.

Unfortunately, you can't add dynamic values from Infopath variables to Where clausewhen you configure the data connection for database source.

In general, when you configure a data connection form database (SQL / OLE DB provider for Oracle), there is no option to add where clause.

在这种情况下，您应该编辑SQL语句以手动为where子句提供静态数据！

In this case, you should Edit SQL Statment to provide where clause manually with static data!!

过滤数据并根据您的要求指定依赖于InfoPath字段的条件.

The available workaround is to Filter Data and specify your conditions that depend on InfoPath fields based on your requirements.

这篇关于从Oracle获取数据到InfoPath的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！