Hi,
We are using FC12, we have two database tables in which we wanted to export the field data. While writing java script in custom export setting, the select query is giving error. we are using the following script.
var fileName = Field("Document Section 1\\FileName").Text;
cmd.CommandTex = "Select FormID From TableName where FileName = '+filename+'" ;
Our next question is, how can we export image into database as binary format?
Comments
3 comments
Hello,
Please send your issue to the regional support. Send them your project, samples, scenario and purpose description.
Hi Ekaterina,
Can we use SELECT query in Rules with javascript?
like : cmd.CommandTex = "Select FormID From TableName where FileName = "xyz";
We need to select data from database through ABBYY flexicapture12. Is it possible?
Hello,
Do you want to query FlexiCapture database or some other database from the code that is stored in the FlexiCapture scripts?
(it is possible to do both, but please be informed that quering the FlexiCapture database directly is not recommended by ABBYY, because they may change the internal structure of database and then the queries will possibly stop working)
To simplify querying the database from the code, you may set up the connection string as an Environment Variable
http://help.abbyy.com/en-us/flexicapture/12/distributed_administrator/environment_variables
The images are available inside the FlexiCapture object model as IPage::Picture object, that can be converted to a bitmap via the Handle property and then saved any way your language supports.
However, if you have any problems with making your code inside FlexiCapture work with your database, please address it to your regional support, because this task will be out of scope of this resource.
Please sign in to leave a comment.