Re: [RBASE-L] - update not working

[Buddy Walker]

Dan   I would try putting paren around where clause as Where ((t1.dlrnum = t2.dlrnum and t1.serial < 900000) and t1.invdate is null) Buddy Sent from my iPhone On Mar 6, 2023, at 7:59 PM, Dan Goldberg <d...@lancecamper.com> wrote:  I have an update command in am trying to run. I am using the newest rbase version.   update orders99 set region = t2.region from orders99 t1, dealer t2 where t1.dlrnum = t2.dlrnum and t1.serial < 900000 and t1.invdate is null   it will say no rows exists   but if I run the browse command the rows come up.   browse t1.dlrname, t1.region, t2.region from orders99 t1, dealer t2 where t1.dlrnum = t2.dlrnum and t1.serial < 900000 and t1.invdate is null   I have checked the database, did an unload/reload, and I am stumped.   Any one have any ideas why the update command does not work?   TIA   Dan Goldberg -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/PH0PR19MB5034C7C166E2112B5406E999D4B79%40PH0PR19MB5034.namprd19.prod.outlook.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/6CBB3BF1-C783-4E7C-95F6-F62F34F392FC%40comcast.net.