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

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

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

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

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

Hi there, Not sure whats happpened here. Working with Delphi 5 Build 5.62 on Windows 2000 Build 2195 SP4. Basically I have a small app (lets call it MyApp) which makes use of an ActiveX and DLL I wrote, 2 other programs (...HisApp / HerApp) also make use of the same. When I run on my machine...

Hi there, I wrote a small signature for my MS Outlook using a scrolling marquee, everything looks fine and it performs as expected. Tha problem is that when people reply to me or I reply the signature allows text to be set to the right of it so it pushes the previous message header info and...

Hi there, I have written an ActiveX control using Delphi called dummyprint.ocx. If I embed this as an OLEControl after registering it in Powerbuilder I can access it fine using the dummyprint.object. notation and it behaves as expected. I do not wish to embed it though I would rather create an...

Hi there, I have written a small ActiveX control based on a TMemo component I created. I also wanted to include some functionality from another custom component with RS232 capabilities (not written by me). I created an instance of the RS232 component on my component recompiled, added to palette...

Hi There, Inherited a Win NT server there and need to know if it is a Primary Domain Controller, as I have some software to install which requires the stand alone Sever configuration. Here comes the stupid question... How can I test this as NT Server is already loaded up ? I want to be sure...

Hi there, Just wondering if I can cast a datastore string value to a boolean like below; BOOLEAN(a_local_datastore.object.field_name[1]) It doesn't seem to want to let me do it. I am passing this value to a BOOLEAN type in a struct and know that the datastore will return NO or YES. Any ideas...

Hi there, Having a problem with this, I have generated a VCL based on a TMemo. Within the TMemo I have a custom function GetLabelFileData which retrieves info from a text file and displays it in the Memo box onscreen. When I install this VCL into a package and then drag and drop it onto various...

Hi there, Have a fair bit of database knowledge but this is first experience using a server type application. Does anyone have a basic tutorial on how to connect, display edit data etc using Delphi to connect to INTERBASE? Have all my tables set up etc but want to know more about front end...

Hi there, Have been using the Database components in Delphi 5 quite successfully but have not yet started trying to use the reports aspect of the package. Does anyone know of a good basic tutorial or info location on this topic. Thanks Pantlord

Hi there, Any ideas how I can clear the displayed data in this control i.e. not the values to select from the drop down list just what is displayed in the text part. Its for a logout field and I want people to know they have to reselect a name without it the old name simply remains and it is...

Hi there, Just interested to know what the best process is when dealing with SQL for ensuring that on exiting a form or procedure that everything which needs to be closed off actually is. For instance I have a form with TQuery, Tdatasource & TTable components (1 of each). On executing an SQL...