Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Posts: 1
Joined: Fri Jun 03, 2005 10:49 pm


Postby akrinker » Fri Jun 03, 2005 11:10 pm

Hi, Simon...

congrats on a great product... Just started using it, already completed several data cleansing projects..

Question: (forgive my ignorance, i'm new to this)... I'm trying to use the data connection filter. How do I "hard code" into the filter the sql statement I need it to pass to the ODBC driver? A related question is how do I read the file or specify the input into the trial run area

I'm trying to write it in a way that it can be run from the command line interface, on a machine that won't have the full text pipe installed. What other prodcts / licences do I need to purchase to develop and distribute the applet?

Thanks for ur help

User avatar
DataMystic Support
Site Admin
Posts: 2139
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

Postby DataMystic Support » Mon Jun 06, 2005 11:09 am

Hi there,

1. Just set the Input Filter to 'Input from Trial Run Input', and then in the Trial Run Input area, just write:

select * from mytable;

or whatever your SQL is.

You can also place this SQL into a file, and use the normal file processing option.

2. If it's just for one client, you'll probably want TextPipe Pro Run Time, which doesn't allow editing. We also have the TextPipe Engine, which is a COM object you can connect to and convert documents on the fly.

Simon Carter, - Insulin dose calculator for Type 1 diabetes - 250,000 free software downloads - send huge email attachments

Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: No registered users and 2 guests