Search found 11 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: 21426

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: 21426

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: 21426

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: 21426

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: 21426

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...
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: 21426

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 ...
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: 9122

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: 12997

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
Fri Nov 07, 2003 9:38 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: macro
Replies: 4
Views: 22798

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: 22798

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
Tue Nov 04, 2003 8:39 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: macro
Replies: 4
Views: 22798

macro

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

christian