Update, I think it is working but the message is wrong. it should say the number of rows in the update and not the amount of rows that were actually updated from another amount?
Or is this a change? Dan Goldberg From: [email protected] <[email protected]> On Behalf Of Dan Goldberg Sent: Monday, March 6, 2023 4:59 PM To: [email protected] Subject: [EXTERNAL] [RBASE-L] - update not working 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<https://nam12.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.rbase.com%2Fsupport%2Fusersgroup_guidelines.php&data=05%7C01%7Cdang%40lancecamper.com%7Cf3df13f50fea45abb2f808db1ea727dd%7Ca2aced7c848c489495946621d8634555%7C0%7C0%7C638137475532908099%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=%2FGR%2BSbJ60xx9rhfkiwf%2FQRmkl5Pq5ZdPlgvMSTSJwB4%3D&reserved=0> --- 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 [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/PH0PR19MB5034C7C166E2112B5406E999D4B79%40PH0PR19MB5034.namprd19.prod.outlook.com<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Frbase-l%2FPH0PR19MB5034C7C166E2112B5406E999D4B79%2540PH0PR19MB5034.namprd19.prod.outlook.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cdang%40lancecamper.com%7Cf3df13f50fea45abb2f808db1ea727dd%7Ca2aced7c848c489495946621d8634555%7C0%7C0%7C638137475533064777%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=qAIDgKcazP4TGU%2Bc2NA7W3m8c4c5sq3bDl46YWVmYek%3D&reserved=0>. -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/PH0PR19MB5034A024CC962594C176F273D4B79%40PH0PR19MB5034.namprd19.prod.outlook.com.
