Transactional Integrity in Data Store
In my Data Store, I want to subtract quantities from some tables, add them to others and subtract them from others. However, I want to make sure that if one operation fails, the others are reverted, or don't occur. In SQL I know I can achieve this like:
BEGIN TRANSACTION;
INSERT INTO table1 (column1, column2) VALUES (value1, value2);
DELETE FROM table2 WHERE condition;
UPDATE table3 SET column1 = value1 WHERE condition;
COMMIT;
ROLLBACK;
This way, I ensure that my data keeps integrity and is synchronised. My understanding is that ZCQL doesn't support this. How's the best way to achieve something like this in Catalyst?
Announcements
Announcing Catalyst Developer Bootcamps in India - Zoho Community
Hey everyone! We're excited to announce a set of developer bootcamps dedicated to Catalyst! These bootcamps are aimed to empower developers to build, scale, and deploy applications with speed and precision, using Catalyst. Whether you're a newcomer or
[Webinar] Upgrade Retail Experiences with Serverless & AI
Ever wondered if you could build lightning-fast, intelligent retail solutions and experiences without touching infrastructure? Join our upcoming live session to explore how you can combine the agility of serverless with the power of large language models
[Webinar] Powering Industry Innovation: Building Unified Solutions with Catalyst
Struggling with fragmented apps or patchwork workflows across teams? Join us for a practical session on how developers are building unified, scalable industry solutions using Catalyst by Zoho—without wrangling with infrastructure. In this live session,
[Webinar] Bridging the Gap: Middleware for Cloud & On-Prem Integration with Catalyst by Zoho
Integrating cloud and on-prem systems can be complex - but it doesn’t have to be. Join us for a live webinar where we break down how middleware simplifies integrations, enhances scalability, and ensures secure data exchange. 🔹 Learn from Experts – Chris
Important Announcements in Support for Catalyst Features
Hello Catalyst Users, This announcement is to bring to your notice some of the recent updates in our support for various Catalyst components, to ensure that your existing Catalyst applications function properly. You can continue to build robust applications