Page 1 of 1

Varchar

Posted: Thu Apr 11, 2013 6:19 pm
by swushw
Hello,

I've been tasked with accepting a large amount of text (varchar 10000A), storing it, and then printing it, retaining at least the carriage-returns. What's the best widget to use to accept the text, how to store it (in ASCII?) and is there an easy way to print it? I'd appreciate any information you can give me.

Thanks in advance.

Re: Varchar

Posted: Thu Apr 11, 2013 6:43 pm
by Scott Klement
If you are using our Open Access Handler (and I'm assuming you are) then you have a bit of a problem, because display file objects don't support the varchar data type. So you'd need to use a fixed-length 10000A field, and just trim the trailing blanks off of it.

I would suggest that you bind that field to a "text area" widget, which should allow them to type carriage returns, et al.

If you want something more sophisticated, you might consider writing your own HTML for a text area that submits to a CGI program, and embed it into your PUI screen using an iframe control. This would allow you to handle huge amounts of data, et al, if desired. But, of course, that requires a different level of web programming skill...

Let me know if the text area widget and a 10000A field will work for you or not...

Re: Varchar

Posted: Fri Apr 12, 2013 1:00 pm
by swushw
Scott,

Thanks for the prompt reply.

The text area widget and a 10000A field worked. Now I just need to figure out a way to print it :).