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.