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 derfloh 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: OAKEJ
  • Order by date
  1. OAKEJ

    Cannot find or load main class upon deployment

    I created a standalone java desktop application using netbeans. It works on my pc both in the IDE and without the IDE. The issue is when I put all of the objects that are in the project folder into a zip file and email it. When the pc tries to use the executable jar file it comes back saying...
    • OAKEJ
    • Thread
    • Replies: 2
    • Forum: Java
  2. OAKEJ

    using jexcel api to populate a jtable in netbeans

    I got it now, thankyou very much for your help, I'll try it out
  3. OAKEJ

    using jexcel api to populate a jtable in netbeans

    Sorry can't open the example, explorer couldn't find page
  4. OAKEJ

    using jexcel api to populate a jtable in netbeans

    Thankyou for you assistance, I'll try Apache POI
  5. OAKEJ

    using jexcel api to populate a jtable in netbeans

    Does anyone have any expirience using jexcel api to populate a jTable with the data read from the spreadsheet using netbeans?
    • OAKEJ
    • Thread
    • Replies: 6
    • Forum: Java
  6. OAKEJ

    Hex Issue

    ...in the Hex Code File that I created Read FLOB DOW NOT %EOF(FLOB) Read HEXFILE DOW NOT %EOF(HEXFILE) IF %SCAN(HEXCOD:OBSITE) > 0 *NOTE HEXCOD Value is 2A Eval @FLAG = 'Y' Else Eval @FLAG = 'N' Read HEXFILE ENDDO Read FLOB ENDDO However if I define a Constant like...
  7. OAKEJ

    Update SQL Help Needed

    Nevermind I have it now. SQL to change the Primary code to Y if it is the lowest cost............ UPDATE OAKEJ/FLPJ PJ SET PJPRMP = 'Y' ,PJCHGD = '1091113' ,PJCHGT = '1202'...
  8. OAKEJ

    Update SQL Help Needed

    ..."Y" when PJLCOS(Last Cost)= WP1COS(the Lowest Cost from OAKEJ/FLCP1WP for Part 'A 680 322 12 25' as well as Set PJPRMP to "N" when PJLCOS>WP1COS **************Initial SQL STATEMENT*************** SELECT PJSITE,PJSPAR,PJPRMP,PJLCOS,WP1COS FROM OAKEJ/FLPJ JOIN FLCP1WP ON PJSITE=WP1SIT...
  9. OAKEJ

    Can you use a Variable in SQL as a File Name

    That was what I thought, I wanted to see if it was possible with Embedded SQL, but it doesn't look like it is. Thanks for the response.
  10. OAKEJ

    Can you use a Variable in SQL as a File Name

    ...SQL statement, I tried :@FILE and it fails to compile, when I use @FILE by itself it will compile but in the joblog it says it can't find the file *LIBL/@FILE, any suggestions @FILE is a file name that is passed earlier in the program SQL Statement.................. C $InsertSql...
  11. OAKEJ

    CPYTOIMPF from csv to a 400 PF

    I need to upload a csv file from my pc into a PF in the 400? Does anyone know how I could do that in a CLP routine? I've tried using the CPYTOIMPF from the command line without success. CPYFRMIMPF FROMSTMF('I:\TMP\AURAPARTS.CSV') TOFILE(IESR7TEST/AURPARTS) RCDDLM(*CLRF)
  12. OAKEJ

    Excel Customization from RPG

    I'm relatively new to RPG and don't quite know it's potential or limitations, I have a PGM that builds a file then sends it in *XLS format to users via MAILXLS. The question that I have is it possible to pass VB codes into that spreadsheet that will be emailed to the users like a code to create...
  13. OAKEJ

    SQL PreCompile Fails

    EXEC SQL SET TRANSACTION ISOLATION LEVEL NO COMMIT END-EXEC EXEC SQL...
  14. OAKEJ

    SQL Help Needed - Literature

    Does anyone know a good source of literature for embedded SQL in RPGLE?
  15. OAKEJ

    Do Loop Problem

    Does anyone know if there are any good windows based RPG IV appliations out there?
  16. OAKEJ

    Import Data Problems

    USE BI_TEMP GO -- TRUNCATE TABLE DBO.OAKEJ_LSSMETRICV GO -- INSERT INTO DBO.OAKEJ_LSSMETRICV -- SELECT * -- FROM DBO.ATHOMM_LSSMETRICV *******Imported Source Table --------------------------------------------------------------------------------------------------------- -- IF (SELECT...
  17. OAKEJ

    Import Data Problems

    I'm fairly new to SQL Server 2005. I imported a Table, made a package that queries the data from the imported table, however when the package runs in the nightly refresh it runs the query but doesn't update the imported table data. Has anyone run into this before. The package is debugged and...
  18. OAKEJ

    Invalid Column Name

    I'm new to SQL Server 2005 and I've got a SQL query that I keep getting a Invalid Column Name, SELECT newreg AS region, crsite AS location, CASE WHEN crsite='COLU2' THEN.03 WHEN crsite='COLUOH' THEN.2 WHEN crsite='GARYIN' THEN.24 WHEN...
  19. OAKEJ

    SubReport Problems

    Actually I figured it out. All I needed to do is use the parameter =Parameter!Regions.Value in the properties of the subreport. Before I used =Fields!Regions.Value.
  20. OAKEJ

    SubReport Problems

    I have a report in Visual Studio. In the data tab I created a Region Dataset from my main data to use as a drop down parameter in my report. The problem is that I have three subreports in that main report that I set the parameters to reflect the dataset. It works fine for three of my four...

Part and Inventory Search

Back
Top