Oma
Could you use a Temp Table to store the Var Field and just Use
Update Temptable set ColumnA = .....
Or base the form on a Temp Table use Update Column for each EEP
then Update the regular table?
Marc
--------------------------------------------------
From: "OmaYahoo" <[email protected]>
Sent: Friday, June 05, 2009 2:59 PM
To: "RBASE-L Mailing List" <[email protected]>
Subject: [RBASE-L] - SPACE ADDED TO A VAR FIELD IN A FORM
Hello everyone!
I have a var field on a form
I have several buttons defined with different alpha characters.
I'm using this on a touch screen! No keyboard for entry.
I have each entry display as they are entered using the var field.
Like vField = (.vField+.vNewButtonValue)
The one thing I need to do is some times a space is needed between the
alpha
characters entered. The space requirement is random.
I've attempted to define a space button using either ' ' or (char(32))
The var using ' ' does not added a space after the previous button pushed
or
the next button after the space button is pushed.
The same for var = (char(32))
I have a work around but it involves using '.' as space
After completion of the field entry
I replace the '.' with ' '.
vField = (SRPL(.vField,'.',' ',0))
The users think this is a little strange seeing a '.' instead of a space!
Does anyone have any suggestions?
Best Regards,
Oma Cox
O.C. Services Inc.
P.O. Box 5485
Brandon, MS 39047
662.820.7599
601.992.6785
www.ocservicesinc.com
