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

    Stored Procedure Datawindow wizard drops package.

    Hi There, New to it but trying to use an ORACLE stored procedure within a package to build a datawindow. I'm assuming this will let me pass some locally gathered info, pass it to ORACLE server by ref, update db accordingly and update the datawindow contents for reporting purposes. Trouble is...
  2. PANTLORD

    Pass PB7 string array to ORACLE 8i stored proc ?

    Hi there, Am trying to pass a string array to an ORACLE 8i stored procedure, I have tested the procedure on the server and know it works, PB7 is giving me any error though when trying to save ; 'variable reference in database statement has unsupported data type' My PB code is; dec{0}...
  3. PANTLORD

    Joins !

    Tried this originally but I'm currently using ORACLE 8i and I don't think it supports it fully. Thanks, Mully
  4. PANTLORD

    How does one delete duplicate rows from a table?

    Hmmmh I have a stinker of a delete to look at and have not a clue, bit more complex than the average I feel. Table A sys_id, sys_type, security_id Table B sys_id, sys_ver_id, release one entry in A can have multiple in B but the sys_id should be maintained throughout and new sys_ver_id values...
  5. PANTLORD

    Joins !

    OK thnk I've solved my own issue here ! select A.* from tableA A, tableB B where A.system_key = B.system_key (+) and B.system_key is null; Cheers anyhows !
  6. PANTLORD

    Joins !

    Hi there, Have two tables A & B joined on key called system_key they hold several cols each. I want to find any orphan records in A i.e. where the link is dead or unbroken I'd like to identify these recs for possible deletion before srchiving. I can get the result I want using a minus...
  7. PANTLORD

    How to manage rollbacks in package.

    Thats greats makes sense now, so everything is managed by the transactions, if multiple instances of my client ran on the one client machine each would create its own transaction, these would then be managed individually by ORACLE. Thanks again, Mully
  8. PANTLORD

    How to manage rollbacks in package.

    Cheers so basically if I ensure the procedure calls are in the correct order and do not do my commit until procedure 5 has successfully processed I should be grand. Additionally how any ideas how the package / procedure instances are managed on the server with several users having simulaneous...
  9. PANTLORD

    How to manage rollbacks in package.

    Hi there, I have several stored procedures, updating / inserting into several tables on an ORACLE 8i db in a specific order lets say procedures are 1 to 5. In order for a complete update of the db I need all to run successfully, if any fail I want to rollback to the very start, that is if...
  10. PANTLORD

    Connecting two computers

    Hi there, I am in a similar boat to Ambatim on this however there is one aditional complication. At home I have desktop with WinXP connected to a Belkin wireless 802.11g router via a USB network adapter and from work a Win2K laptop connected using a notebook network card. My issue is on my...
  11. PANTLORD

    Windows Data Types (BSTR) Mapping to PB7.

    No sorry this is from a 3rd party source. I know it was made in VB, but does not work for me in either Powerbuilder 7 / 9 or Delphi 5. If I try and regsvr32 it in windows it tells me that, the dll was loaded but the DllInstall entry point was not found. Thanks, Mully
  12. PANTLORD

    Windows Data Types (BSTR) Mapping to PB7.

    Hi there, Trying to call a function from a DLL have correct syntax and have it defined as global external function. Think the problem may be that the DLL uses the datatype BSTR, and I suspect this is not supported in PB7, any ideas ? can anyone confirm or disprove. Many thanks, Mully
  13. PANTLORD

    Timer query..

    I'm using PBB 7 at the minute soon to be 9. Is there any trick to using a gif in PB7 ? Thanks,
  14. PANTLORD

    Timer query..

    Hi there, Apologies little experience with timers in PB so bear with me.. Basically my aim is to have blinking text in a static text control on a form. I can handle this fine with a few instance variables and the forms' timer event for any form events. The issue arises when I also want the...
  15. PANTLORD

    How to pass Multi Dimensional Array to function

    Thanks for that. I ended up declaring the array as an Instance variable so I can call it from my main object functions. W.r.t the formatting I have passed other arrays and omitted the brackets and this seemed to work fine but its not the case for a multidimensional one. As soon as you try to...
  16. PANTLORD

    How to pass Multi Dimensional Array to function

    Thanks for the reply sorry bit green here your onna hav eto help me out, but what is an nvo ? and does this mean that you can't pass a multidimensional array as I wished to do to a function ? Thanks again, Mully
  17. PANTLORD

    How to pass Multi Dimensional Array to function

    Hi there, Have a defined multidimensional String array which I wish to pass by reference to a function within a window object. How do I need to define the function parameter ? currently I have it as Pass By: Reference Argument Type: String Argument Name: lsa_my_array[2,3] If I don't include...
  18. PANTLORD

    Change the colour of different lines in MultiLineEdit control..

    Hi there, Does anyone know if this can be done ? Thanks, Mully
  19. PANTLORD

    Describe function knightmare !!!

    Hi there and thanks for the answer so far, I've been digging into this some more and have found out the following. This code utilises a generic datawindow lds_eval with 1 field called eval_exp. 1 row (dummy data) is then imported into the field a string is set up in the form; ls_eval =...
  20. PANTLORD

    Describe function knightmare !!!

    Hi there, Just can't get a handle on this at all I have taken over support of a program that evaluates some quite hefy strings using IF(b,t,f) structure and I can't seem to get them to evaluate correctly at all. For instance; =if ("VS" = "AG", "ans_1", if...

Part and Inventory Search

Back
Top