At 07:48 PM 7/14/2008, Mike Casey wrote:
I am trying to create a form that allows a user to enter information
into a multi-line input box. I have the database column as a varchar(50).
If I create the input box as a Variable Edit, it works fine but I lose
my multi-line capabilities. If I try either a Variable Memo or a Variable
Rich Edit, I am able to get my multi-line, but the form does not work.
It puts a -0- in each box and the system does not recognize when I enter
text in it. How do I get a multi-line input box to go into a varchar(50)
column?
Mike,
Without knowing all details on your end, is there any particular reason to
use VARCHAR data type for a column to only store multi-line 50 characters?
In your specific circumstances, to maintain the multi-line 50 characters,
I suggest that you use NOTE data type. Then, using the Variable Memo Control
on your variable form to collect data, you can still maintain the linefeed
(Return) characters as well as all features of Variable Memo Control.
Having said that, if you really have to use the VARCHAR data type to store
multi-line text for 50 characters, you have to make sure that the following
properties are enabled for the Variable Memo control when entering the data.
General:
. [x] Word Wrap
. [x] Allow Returns
. Text Alignment: Left
Effects:
. Maximum Length (use this option accordingly)
Scroll Bars:
. [x] Horizontal
. [x] Vertical
Finally, here is a sample application to demonstrate the use of such
feature in R:BASE Turbo V-8 for Windows.
Sample Applications: http://www.razzak.com/sampleapplications/
Application: Managing Customers (Entering Data Using a Variable Form)
Supported Version: R:BASE Turbo V-8 for Windows
Database:
- ManagingCustomers
Associated Table(s):
- Customer
Associated Form(s):
- NewCustomer (A Variable Form to Enter Required Data for New Customer)
- ReviewExistingCustomers (Review Existing Customers)
Startup File:
- ManagingCustomers.DAT
For your viewing pleasure:
- http://www.razzak.com/sampleapplications/ManagingCustomers_01.jpg
- http://www.razzak.com/sampleapplications/ManagingCustomers_02.jpg
Enjoy the application and make sure to have fun exploring all details!
Very Best R:egards,
Razzak.
P.S.
As always, make sure that you are using the latest updates of R:BASE!
- http://www.rupdates.com/rbg8/
- http://www.rupdates.com/rbg8/enterprise/
- http://www.rupdates.com/rbg8/corporate/
- http://www.rupdates.com/rbg8/rcompiler/
- http://www.rupdates.com/rbg8/runtime/
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
