Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mmayo
  • Content: Threads
  • Order by date
  1. mmayo

    sstab, tabs on side, text alignment?

    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...
  2. mmayo

    Trigger for insert

    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...
  3. mmayo

    Trigger to execute an insert

    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...
  4. mmayo

    VB, ADO, and insert into Oracle

    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...
  5. mmayo

    Insert or append data from disconnected recordset

    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;
  6. mmayo

    Insert or append data from disconnected recordset

    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;
  7. mmayo

    Passed parameter in stored procedure

    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...
  8. mmayo

    Pervasive SQL 2000 stored procedure and VB6

    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...

Part and Inventory Search

Back
Top