[RBG7-L] - RE: Replace all column values in Data Browser.

[Javier Valencia]

I run into this condition until I figure out my big duh! I was replacing data for a column that was used for the selection: EDIT * from my_table WHERE my_column = ‘CAR’ Then I did a global replace of my_column to ‘TRUCK’ And all the rows disappeared without a message and all that is left is a blank row…but this is the correct behavior since my_column is no longer = “CAR’ and no rows meet the original selection condition …hence the duh! Is this by any chance what is happening to you? Javier,   Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.  Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ======================================================   -----Original Message----- From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED]On Behalf Of dgallup Sent: Tuesday, June 07, 2005 5:58 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Replace all column values in Data Browser.   I have noticed that when I do the same thing , replacing a column of values with a single value, the screen dumps the table except for a last blank row, then, when I recall the same table, the values have been replaced properly. The more rows, the more it happens - ergo one might surmise it is a memory problem, or, as others may surmise,  maybe I have a problem. I do not, however, get an error message of any kind. Dave. Lawrence Lustig wrote: It's probably too obvious but shouldn't you put '100772' or 'X100772'?       Well, it's not obvious to me!!!!  But it does make a difference -- when I do that I get the error "Resources Are Not Available" (I'm the only user in this database). -- Larry