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.
================================================
