Search results for query: *

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

Aren't in Linux some Access emulators ?

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.

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

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.

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