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: *

  1. GeppoDarkson

    How to know Width when creating New component

    Thank you all, now everithings works well. Ciao, Geppo Darkson.
  2. GeppoDarkson

    How to know Width when creating New component

    Hi buho, my problem is not on resizing, but on create: I have to put 10 labels spaced equally, so I need to let the component create, and only after he have the final dimensions I can calculate the space between the labels. Unfortunally until the creation is complete the width and height are...
  3. GeppoDarkson

    How to know Width when creating New component

    Hi to all, I have to make a new component based on a TPanel with some controls over it. I need to know the Width and Height to set the position of the child controls (for example, a label in the middle of the panel). When the component is creating I can't find how to know the "final" width...
  4. GeppoDarkson

    Get Stored proc SQL from StoredProcName

    I want to make a tool that works with many (all) databases, so I expect to find some ODBC or ADO function to obtain the stored proc statement. After all it should be not too different as asking AdoConnection1.GetProcedureNames, or AdoConnection1.GetTableNames, both should looking at system...
  5. GeppoDarkson

    Intelligent Agent crash with Norton Antivirus

    Hi, it seems that after the Symantec LiveUpdate execution, Norton Antivirus 2006 and Oracle Intelligent Agent works toghether well. Ciao, GeppoDarkson.
  6. GeppoDarkson

    Get Stored proc SQL from StoredProcName

    The stored procedure runs on a Oracle database, so i've take the SQL from the system tables: select * from USER_SOURCE where name = 'THEPROCEDURENAME' But it sounds me strange that there is no standard methods to obtain the SQL of a stored proc via ADO or some other Delphi component. I can't...
  7. GeppoDarkson

    Intelligent Agent crash with Norton Antivirus

    Hi, I've a new PC running XP-Pro and Oracle 9.2.0.1 After the installation of Norton Antivirus 2006, at startup Oracle Intelligent Agent crash, with the "send this error to Microsoft" window. If I uninstall the antivirus everythings works good. How can i tell Norton Antivirus to let Oracle...
  8. GeppoDarkson

    Get Stored proc SQL from StoredProcName

    Hi, someone knows how to get the SQL Statements of a Stored procedure knowing the name? I simply want to put the StoredProcedure source into a memo and let the user show it. Thanks, Geppo Darkson.
  9. GeppoDarkson

    UPDATE part of MERGE INTO problem

    Hi to all. I've solved this problem using this: Merge into TReal R Using (Select TTemp.Id,TTemp.IdSens,TTemp.Dt,TTemp.Valore,TTemp.Rank, TReal.Rank As TrRank From TTemp Left Outer Join TReal On TTemp.IDSENS = TReal.IdSens and TReal.Dt=TTemp.Dt Where...
  10. GeppoDarkson

    Update Table A (only 4 rows) with data from table B

    Hi, take a look to "Merge into" command.
  11. GeppoDarkson

    UPDATE part of MERGE INTO problem

    Sorry, the second row is: Using (Select IdStation,Dt_Hour,Measure,Rank From TTEMP) T I've notice also that "R.RANK <= T.RANK" in the ON clause triggers the INSERT statement for records (not matched) that haves a R.Rank higher than T.Rank, duplicating the primary key IdStation+Dt_Hour Should...
  12. GeppoDarkson

    UPDATE part of MERGE INTO problem

    Hi to all, may I update a field that is part of the "ON" clause of a MERGE INTO statement? I have two tables for temperature data: TReal And TTemp with the same structure: IdStation, DT_Hour, Measure, Rank I want to insert in TReal the missing records of TTemp (same IdStation & DT_Hour) and...
  13. GeppoDarkson

    Update BIG Table from data in SMALL Table

    Thank you Sam! Off course I've got an index on Big Table. I'm twice happy because the SmallTable can't have index, primay key and triggers because I use a Delphi component to insert records that uses OraLoader to put data into SmallTable: very fast but with this limitations. I would offer one...
  14. GeppoDarkson

    Joins !

    Select * From A Where Not Exists(Select * From B Where B.system_key=A.system_key) Ciao, GeppoDarkson.
  15. GeppoDarkson

    Update BIG Table from data in SMALL Table

    Hi to all, I have a table containig 60 million of records containing 15 years of temperature data. This table should be update every 15 minutes with records containing the temperature of the two last days (the new 15'+ the last 48 hours, in case of some data have changed by some external...
  16. GeppoDarkson

    How to use m$ Access forms & db in Linux?

    Aren't in Linux some Access emulators ?
  17. GeppoDarkson

    How to use m$ Access forms & db in Linux?

    SomeOne knows how to use Access forms, database and reports under linux? Could be a Windows server and Linux clients ? Running Access under Linux? Thanks, Geppo Darkson.
  18. GeppoDarkson

    Delphi source code obfuscator

    This should not be a problem: under \ProgramFiles\Borland\Delphi7\licence.rtf: &quot;Subject to the terms and conditions of this License, you may freely redistribute source code or compiled code that is entirely your own and does not contain any redistributables.&quot; Ciao, GeppoDarkson
  19. GeppoDarkson

    Delphi source code obfuscator

    I should give a functionant source. A solution may be give the source to a notary public and set the rules to obtain access to it, but the cost may be high and it's ever best not to involve lawyers. GeppoDarkson.
  20. GeppoDarkson

    Delphi source code obfuscator

    I should make a project for an university: they want the source, but they do not want to pay for it. They say that it will be used only for security pourposes, just to &quot;have it&quot;, and other bullshits, but I know that they will use it to obtain know-how to use in other similar...

Part and Inventory Search

Back
Top