Search found 14 matches

by Christian Lempereur
Thu Jan 26, 2006 8:57 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Error-Invalid variant operation since upgrade to 7.4.2
Replies: 9
Views: 17203

Possible. I got my problem solved by using the OpenOffice.org Database to retrieve the full memo fields. I think they have their own MS Access connection instead of the ODBC I use with TexPipe.

best regards,
Christian
by Christian Lempereur
Tue Jan 24, 2006 9:49 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Error-Invalid variant operation since upgrade to 7.4.2
Replies: 9
Views: 17203

If I understand your answer correctly, there is no way to handle memo fields larger than 255 characters in length with TextPipe and that's it.
Bottomline what you say is: look at another SW to do that. Tell me I did not get your message correctly.

Christian
by Christian Lempereur
Mon Jan 23, 2006 1:46 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Error-Invalid variant operation since upgrade to 7.4.2
Replies: 9
Views: 17203

Well apparently my workaround does not work if data is really more than 255 characters. I'm stuck!

Christian
by Christian Lempereur
Sun Jan 22, 2006 11:23 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Error-Invalid variant operation since upgrade to 7.4.2
Replies: 9
Views: 17203

In the meantime I found the following (clumpsy) workaround: instead of using left(MyField, 500) use: mid(MyField,1,250), mid(MyField,251,500) (add more if needed) And then use a filter to put the separate fields back in one field by restricting on those fields and removing the field delimiters and t...
by Christian Lempereur
Sun Jan 22, 2006 10:42 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Error-Invalid variant operation since upgrade to 7.4.2
Replies: 9
Views: 17203

Error-Invalid variant operation

TextPipe current version: 7.6.3 Sorry had other priorities. Finally here is an answer on your question: the field is a memo field. I come back on it because there is another odd problem with this type of data. Besides the "Error-Invalid variant operation" problem, if I use my workaround it will work...
by Christian Lempereur
Tue Jul 05, 2005 1:49 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Error-Invalid variant operation since upgrade to 7.4.2
Replies: 9
Views: 17203

Error-Invalid variant operation since upgrade to 7.4.2

I just updated TextPipe Pro from 7.0.something to 7.4.2 and I am getting an "Error-Invalid variant operation" which I did not get with previous version. The filter is getting data out of an Access DB with an SQL statement in the trial run area. I could solve the problem by changing SELECT T.Desc FRO...
by Christian Lempereur
Tue Nov 09, 2004 9:14 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Accessing more than one db?
Replies: 1
Views: 6804

Accessing more than one db?

I need to select data from 2 data bases.
Special filter > DataBase connection seems to only accept one database.
Any way it can be done in a single TextPipe filter?

thanks,

Christian
by Christian Lempereur
Wed Jul 21, 2004 10:13 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Database connection, SQL and BLOB
Replies: 0
Views: 9277

Database connection, SQL and BLOB

I receive 'BLOB' as a result of a 'count(status)' in my SQL select statement. TextPipe's Help says to try to use a subfilter with 'mime base64 encoding', I tried many of the possible encoding choices finally I got my result just using 'SUBSTRING(count(status),1,100)' instead of the 'count(status)'. ...
by Christian Lempereur
Sun Jul 18, 2004 6:58 am
Forum: DetachPipe.com and DetachPipe Add On Support
Topic: Did I miss something?
Replies: 5
Views: 23550

Finally got Global variables to work

I had no time to look into it before now, but I finally upgraded to Textpipe Pro, had to learn how to use VBScript and lost most time finding out how to pass data to a Global variable and getting it back on the line level. By the way, it is documented and a search in the help with 'global variables'...
by Christian Lempereur
Fri Nov 07, 2003 9:38 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: macro
Replies: 4
Views: 15797

And if it gives date and time, maybe it's not a good idea to call it @today, it may be better to call it @now or @timestamp.

christian
by Christian Lempereur
Thu Nov 06, 2003 6:26 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: macro
Replies: 4
Views: 15797

I don't really care about the format because textpipe's filters can be used to reformat to whatever is needed.
I would suggest something like YYYY-MM-DD HH:MM:SS

christian
by Christian Lempereur
Thu Nov 06, 2003 6:23 pm
Forum: DetachPipe.com and DetachPipe Add On Support
Topic: Did I miss something?
Replies: 5
Views: 23550

VBScript, meaning only with TextPipe PRO, I need to upgrade then.
Not a problem, I am so satisfied with the standard, I'm sure Pro will provide me even more fun!

christian
by Christian Lempereur
Tue Nov 04, 2003 8:53 am
Forum: DetachPipe.com and DetachPipe Add On Support
Topic: Did I miss something?
Replies: 5
Views: 23550

Did I miss something?

Textpipe is OK but I wonder if I can do the following : I have a file consisting of a header and a number of detail lines. I have to find some values in the header part and put them on each detail line to make a CSV for another application. I've been searching for the whole WE and could not find a s...
by Christian Lempereur
Tue Nov 04, 2003 8:39 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: macro
Replies: 4
Views: 15797

macro

Currently 3 macros available (@inputfilename, @fullinputfilename and @clipboard).
What about a macro to insert current date and time? Something like : @today?

christian