I have a form eep that runs a WHILE loop for several thousand records.
In this WHILE loop, I have a PROPERTY command that sets a static text caption
to a variable value.
The caption does not update on the form when the eep fires.
While ....... Then
(Other coding)
Set Var vMsg = ('Part -> ' + .vPart)
Property TextMessage caption . vMsg
(More code)
EndWhile
I have used similar statements above many times in eeps with no problem.
However in this WHILE loop, I cannot get the caption to refresh.
I have tried various refresh and recalc commands but to no avail. The loop
runs fairly fast, but I would think the caption would at least occasionally
update.
Any ideas?
Thanks
Bob Thompson
LaPorte, IN
219-363-7441
Sent from my iPod
On Aug 19, 2015, at 3:10 PM, "A. Razzak Memon" <[email protected]> wrote:
> At 02:30 PM 8/19/2015, Dan Goldberg wrote:
>
>> I want to copy data from one table into another table. The problem is
>> I have one column in the destination that is an autonumber field.
>>
>> I want to put the number from the source table in that autonumber field
>> as I have already captured it using the nextnum function.
>>
>> Other than using unload/load does anybody know a way to achieve this?
>
>
> Dan,
>
> There are many techniques to achieve your goal to APPEND data from
> one table to another with AUTONUM column.
>
> Here's a very simple technique ...
>
> Steps:
>
> 01. Before attempting to APPEND data from one table to another table,
> use the following command for the "Target" table:
>
> AUTONUM ColumnName IN TargetTable DELETE
>
> 02. Now APPEND the data from source table to target table
>
> APPEND SourceTable TO TargetTable
>
> 03. Re-Assign the AutoNum for column in TargetTable
>
> SET VAR vMaxValue INTEGER = 0
> SELECT (MAX(ColumnName)) INTO vMaxValue INDIC iv1 FROM TargetTable
> AUTONUM ColumnName IN TargetTable USING .vMaxVallue 1 NUM
> CLEAR VARIABLES iv1,vMaxValue
> RETURN
>
> Hope that helps!
>
> Feel free to reach out to me with any questions.
>
> Very Best R:egards,
>
> Razzak.
>
> www.rbase.com
> www.rbaseX.com
> www.facebook.com/rbase
> --
> 32 years of continuous innovation!
> 17 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
> --
>
>
