Search results for query: *

Sorry if this is appallingly simple... I've got a SSTAB with 20 tabs down the side, one level deep. I would like the text on the tab to display horizontally. The problem is that even with the tabs appropriately sized, the text aligns to the bottom of the tab. Can it have a top alignment so...

I have composed this trigger: CREATE OR REPLACE TRIGGER JobCost after update [clock_out] ON CIM_TIMECLOCK BEGIN INSERT INTO FORJOBCOST SELECT CIM_FOLDER11.JOB_NUMBER, CIM_FOLDER11.OP_NO, CIM_FOLDER11.MACHINE, CIM_FOLDER11.QTY_GOOD, CIM_FOLDER11.QTY_SCRAP, CIM_TIMECLOCK.OPERATOR...

I have data that needs to be pulled from oracle, modified, and pushed into PervasiveSQL. I would like to fire a trigger in oracle when an employee clocks out. I need data from that and 2 other tables in oracle. I would like to insert that into a table in Access. Being my first trigger, I'm...

I have captured data from PervasiveSQL, modified it (so I have the 'ET' of 'Extract, transform, and load). (Well, I actually load it into a table in access for safe keeping). At any rate, where I need this data is to update and insert a table in Oracle. Here is what it looks like: Dim...

I have a disconnected recordset from a stored procedure. I know I can loop through the records to populate a table, but is there a way to execute this as a single SQL statement? For example: SELECT rsFromSP.Field1, rsFromSP.Field2, rsFromSP.Field3 INTO tLocalTable FROM rsFromSP;

I have a disconnected recordset from a stored procedure. I know I can loop through the records to populate a table, but is there a way to execute this as a single SQL statement? For example: SELECT rsFromSP.Field1, rsFromSP.Field2, rsFromSP.Field3 INTO tLocalTable FROM rsFromSP;

Using pervasive SQL 2000 I have created: CREATE PROCEDURE spINTXCT(in :UpperDate date) RETURNS(chrItem char (20), chrLoc char(7), chrLayer chr(3), numStock numeric, numQtyRemn numeric, dtApplDate date) AS BEGIN SELECT INTXCT.Itemkey, INTXCT.Location, INTXCT.Layertyp, INTXCT.Stockqty...

I have created 2 stored procedures using pervasive's Control Center. When I attempt to open a recordset using ADO, with a valid connection object, I get: 3704 - The operation requested by the application is not allowed if the object is closed. Since there are several legacy Access databases...