Thanks Razzak & Bill,
Unfortunately no luck so far - even combining both your suggestions.
I'm still looking to see if I can see what's wrong but the value appears in
the control as expected but as soon as I click anywhere else (it seems) the
control is cleared. So if I click on my Save & Exit button or into another
control the value just disappears.
I have recreated the control from scratch. I'll need to check the lengths of
my current data but the next step seems to be to convert my column to text
and see if that makes any difference.
I'm pasting URLs (Amazon pages, etc) - is there a maximum length that is
allowable? I've used a Note column to save space but that's probably not
needed these days.
Regards,
Alastair.
----- Original Message -----
From: "A. Razzak Memon" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, February 24, 2009 7:02 PM
Subject: [RBASE-L] - Re: DB Memo PROPERTY TEXTVALUE strange behaviour
At 01:37 PM 2/24/2009, Alastair Burr wrote:
I have two forms in different databases that I am trying to do use
the same PROPERTY command in a DB Memo control but one works while
the other doesn't.
The only difference that I can see - and there may well be differences
I'm not seeing! - is that the one that works is based on a TEXT field
while the one that fails is based on a NOTE field.
This is the code that works:
GETPROPERTY IDDB_Food TEXTVALUE vCurrText
SET VAR vNewText = (.vCurrText & .vMenuChoice)
PROPERTY IDDB_Food TEXTVALUE .vNewText
RECALC TABLE
This is the code that fails:
SET VAR vNewText = (CVAL('CLIPBOARDTEXT'))
PROPERTY &vURLField TEXTVALUE .vNewText
RECALC TABLE
vURLField determines which of two fields is (supposed to be) updated.
If I TRACE through using the form the value appears but it won't
"stick" and the field never gets updated.
Is there something that needs to be done differently with NOTE data
types or can anybody see where I'm going wrong?
Alastair,
Without knowing further details or the actual structure of your table,
try the following command to save the current record in the table.
SET VAR vNewText = (CVAL('CLIPBOARDTEXT'))
PROPERTY .vURLField TEXTVALUE .vNewText
PROPERTY TABLE <FORMTABLENAME> 'POST'
RETURN
In your example above, RECALC TABLE is simply refreshing the data as
compared to saving the data.
Hope that helps!
Very Best R:egards,
Razzak.
--- 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.
================================================
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.3/1969 - Release Date: 02/24/09
06:43:00
