Recent content by LGEAI Developers

  1. LGEAI Developers

    Select into using TOracleQuery

    Thank you for your replies. Delphi code completion allows us to specify Text which says type TMaskedText. As it turns out the Text property of a dbedit control appears to be unidirectional. What we mean by that is that you can set the text field to a value in either insert or edit mode but it...
  2. LGEAI Developers

    Select into using TOracleQuery

    Our attempt to prefill TDbedit controls from a TQuery is not working the way we thought it would. The dataset and dbedit controls are in insert mode and the GetVariable assignment populates the control and the user can see the data. If you save the record the contents of the dbedit controls are...
  3. LGEAI Developers

    Select into using TOracleQuery

    Thank you for your reply. The help on Declare Variable was very informative. We declared variables at design time. GetVariable retrieved the requested values. Button code was modified as follows: FRIA0033dm.oqGetFroiInfo.Close; FRIA0033dm.oqGetFroiInfo.SetVariable('DBEACN', dbeAcn.Text)...
  4. LGEAI Developers

    Select into using TOracleQuery

    Thank you for your prompt reply! Begin SELECT FIRST_REPORT_OF_INJURIES.SSN, FIRST_REPORT_OF_INJURIES.EE_L_NAME INTO :dbeSsn, :dbeLastName FROM FIRST_REPORT_OF_INJURIES, CLAIMS WHERE FIRST_REPORT_OF_INJURIES.FRI_NUMBER = CLAIMS.FRI_FRI_NUMBER AND CLAIMS.AGENCY_CLAIM_NUMBER = :dbeAcn; End...
  5. LGEAI Developers

    Select into using TOracleQuery

    Select into using TOracleQuery We are using Delphi 7 and DOA 4.0.3 and PL/SQL Dev 9.0.2.6.0 under Win XP SP2 . In a Delphi button we need to get fields to pre-fill a TOracleDataSet that is already in Insert mode. The test SQL (which worked fine) we used as a model in PL/SQL Dev tool looks like...
  6. LGEAI Developers

    SQL-Developer Update 6-->7

    We have downloaded the last (7.02) Version from SQL-Developer. After enter the Product Code, we have got the Message "You are not allowed to install the product". Have something changed since version 6?
  7. LGEAI Developers

    Annoying things

    I finaly took the time to post some very annoying things in plsql-developer (7.02.1076). Not that the tool is all bad, but I thing these are some basic things every IDE should have. 1. search UP with short-cut key (eg shift-f3) 2. when having searched everything (after returning to the...
  8. LGEAI Developers

    OracleScript output

    Thank you for your response. All output parameters are set to true. Where does the output go?
  9. LGEAI Developers

    OracleScript output

    Using DOA 4.0.3 and trying to use the OracleScript component. I set up a test button with the following Delphi 7 code: procedure TFRIA0024frm.btnExecSqlScriptClick(Sender: TObject); begin FRIA0024dm.OracleScript1.Execute; end; String List Editor has the following: select count(*) as...
  10. LGEAI Developers

    Preference Sets

    Hey! Who Is Laszlo Kerepeszki and why is that name appearing with my (very first) post? Randy
  11. LGEAI Developers

    Preference Sets

    I'm having a related(?) problem: All my preferences have disappeared. Is this due to the recent upgrade? Does every upgrade reset the preferences to the defaults? Is the preference files name "plsqldev.GID" on a Windows workstation? Thanks
  12. LGEAI Developers

    AfterConnect.sql

    We execute this code. DECLARE -- -- BEGIN -- INSERT INT TMP_PEDRO (C1, C2) VALUES (SYSDATE, '1'); COMMIT; -- END; / Regards
  13. LGEAI Developers

    AfterConnect.sql

    Hi Allroundautomations, We migrate to PL/SQL Developer 7.0.0.1050, with a short code in AfterConnect.sql, when work with PL/SQL 6.0.6.947 AfterConnect.sql fires fine and all sessions works ok. Now with new version AfterConnect don't fire, can you help me ? Thanks in advance.
  14. LGEAI Developers

    Macros take a long time to execute

    It seems to be every macro I have tried (ones I recorded) at some point displays this behavior. The problem sometimes also occurs when I am just typing. There are times when I can type faster than it can display. But with the macros I would say this typing phenomenon occurs 90% of the time.
  15. LGEAI Developers

    Macros take a long time to execute

    Whenever I record a macro in 7.0.1.1066 the macro takes a long time to execute. Is there a preferences setting that reduces the delay between each macro step?
Back
Top