Is it just the email message, or is there really a space between ". vMsg"?
Karen -----Original Message----- From: Bob Thompson <[email protected]> To: karentellef <[email protected]> Sent: Wed, Aug 19, 2015 4:05 pm Subject: [RBASE-L] - Static text caption 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! > -- > >
