Gecko [ tanishkshah.com ]

Name	Size	Permission	Date
stat1.e	2.11 KB	-rw-r--r--	2026-04-17 16:36
stat10.e	3.82 KB	-rw-r--r--	2026-04-17 16:36
stat11.e	3.69 KB	-rw-r--r--	2026-04-17 16:36
stat12.e	3.09 KB	-rw-r--r--	2026-04-17 16:36
stat12t.e	2.08 KB	-rw-r--r--	2026-04-17 16:36
stat2.e	1.99 KB	-rw-r--r--	2026-04-17 16:36
stat3.e	2.44 KB	-rw-r--r--	2026-04-17 16:36
stat4.e	3.42 KB	-rw-r--r--	2026-04-17 16:36
stat5.e	2.75 KB	-rw-r--r--	2026-04-17 16:36
stat6.e	2.64 KB	-rw-r--r--	2026-04-17 16:36
stat7.e	2.48 KB	-rw-r--r--	2026-04-17 16:36
stat8.e	3.17 KB	-rw-r--r--	2026-04-17 16:36
stat9.e	3.45 KB	-rw-r--r--	2026-04-17 16:36

Rename

/*
 *  Program type:   Embedded Static SQL
 *
 *  Description:
 *		This program should be run in conjunction with stat12.
 *		It adds some sales records, in order to trigger the event
 *		that stat12 is waiting for.
 * The contents of this file are subject to the Interbase Public
 * License Version 1.0 (the "License"); you may not use this file
 * except in compliance with the License. You may obtain a copy
 * of the License at http://www.Inprise.com/IPL.html
 *
 * Software distributed under the License is distributed on an
 * "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either express
 * or implied. See the License for the specific language governing
 * rights and limitations under the License.
 *
 * The Original Code was created by Inprise Corporation
 * and its predecessors. Portions created by Inprise Corporation are
 * Copyright (C) Inprise Corporation.
 *
 * All Rights Reserved.
 * Contributor(s): ______________________________________.
 */

#include "example.h"
#include <stdio.h>
#include <string.h>
#include <stdlib.h>

EXEC SQL	
	BEGIN DECLARE SECTION;
EXEC SQL
	SET DATABASE empdb = "employee.fdb";
EXEC SQL	
	END DECLARE SECTION;

int main(int argc, char** argv)
{
        EXEC SQL
		CONNECT empdb;
	EXEC SQL
		SET TRANSACTION;

/* Clean-up. */
	EXEC SQL
		DELETE FROM sales WHERE po_number LIKE "VNEW%";
	EXEC SQL
		COMMIT;

/* Add batch 1. */
	EXEC SQL
		SET TRANSACTION;
	printf("Stat12t:  Adding VNEW1\n");
	EXEC SQL
		INSERT INTO sales (po_number, cust_no, order_status, total_value)
		VALUES ('VNEW1', 1015, 'new', 0);
	printf("Stat12t:  Adding VNEW2\n");
	EXEC SQL
		INSERT INTO sales (po_number, cust_no, order_status, total_value)
		VALUES ('VNEW2', 1015, 'new', 0);
	printf("Stat12t:  Adding VNEW3\n");
	EXEC SQL
		INSERT INTO sales (po_number, cust_no, order_status, total_value)
		VALUES ('VNEW3', 1015, 'new', 0);
	EXEC SQL
		COMMIT;

/* Add batch 2. */
	EXEC SQL
		SET TRANSACTION;
	printf("Stat12t:  Adding VNEW4\n");
	EXEC SQL
		INSERT INTO sales (po_number, cust_no, order_status, total_value)
		VALUES ('VNEW4', 1015, 'new', 0);
	EXEC SQL
		COMMIT RELEASE;

exit(0);

}