Search results for query: *

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

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

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

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

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 !

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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