i need to update some values fields on one of the tables ,

i need to know some instruction for assign 0 to those fields,

like "replace" on SQL,

somebody can help me?

thanks

Juan Carlos ..

There's no really easy way to do this in AREV .. but you certainly can do it easily in either an R/BASIC program or with a Dictionary Symbolic:

RBASIC:

OPEN "YOURFILE" TO FILE_IN ELSE .. error ..

PERFORM "SELECT YOURFILE .. select criteria for the ones you want to fix

DONE=0

LOOP

READNEXT @ID ELSE

DONE=1

END

READ @RECORD FROM FILE_IN,@ID THEN

.. update the fields in @RECORD

WRITE @RECORD ON FILE_IN,@ID

END

UNTIL DONE

REPEAT

* DICT SYMBOLIC - call it FIXIT

OPEN "YOURFILE" TO FILE_IN ELSE

@ANS=NO FILE"

GOTO DONE:

END

..fix the fields in @RECORD

WRITE @RECORD ON FILE_IN,@ID

@ANS=UPDATED"

DONE:

LIST YOURFILE WITH .. your select criteria FIXIT NOPAGE

Hope it's useful

Don Miller

C3 Inc.

Juan Carlos

In your USER'S GUIDE look up "batch updating rows". It explains how to use AREV's BATCH UPDATE facility. I think sounds like what you are looking for.

Hope it helps.

JoeD

thanks for answering,

i dont have an User´s Guide, can you tell me what are the steps for "Batch Updating Rows"?

thanks again,

Juan Carlos

At a TCL command line (F5) type runmenu appmain

select menu items UTILITIES DEVELOPER BATCH

When you are in the Batch screen press Crtl/F2 read doc.

Then at each prompt press F1 read info

Hope this helps

JoeD

Have you considered pressing F5 to get TCL then

SQL UPDATE TABLE SET COLUMN=VALUE WHERE COLUMN=VALUE

The Sprezzatura Group

World Leaders in all things RevSoft

Hi,

i tried that, but i got the follow error:

A file error 250 was encountered an R/BASIC SELECT.

What is that?

Thanks

Out of conventional memory or not enough conventional memory to compile the select statement. From the TOP level Main menu, press F5. At the TCL typw WHO. There are two key issues: How much conventional memory and whether EMS is enabled. If you have less than 300K of Available Memory and EMS is not enabled, then the whole thing can become problematical. If EMS is present, press PageDown twice to see how the EMS is being used (Used vs. Allocated). If allocated is less than 4MB and you have allocated 4096 in the Memory Properties of the shortcut, then your shortcut should start AREV with the command-line AREV appname /M4096X.

Don Miller

C3 Inc.

HI Don,

i have the same problem after do the thigs wich you told me , i got the 252 error,

A file error 252 was encountered

 during an R/BASIC SELECT.

What other thing can i do?

thanks again!

View this thread on the forum...