Description Joseph Vincens 2011-10-05 15:26:56 EDT

function func3(ds sqldatasource)
		rs1 SQLResultSet?;

		// OPEN a result set using the same SQLDataSource
		// This query happens to get all CUSTOMERs
		try
			sqlStmt SQLStatement?;
			prepare sqlStmt from ds with "select Name, id from Table1";
			open rs1 from ds with sqlStmt;
			foreach(myRecord from rs1) 
				Syslib.writeStdOut("Customer name: " + myRecord.name);
			End
		onException(ex SQLException)
	    	syslib.writeStdout(ex.message);
	   		syslib.writeStdout("ErrorCode:" + ex.ErrorCode);
    		syslib.writeStdout("SQLState:" + ex.SQLState);
	    end
			
	end