Delphi 5 with ADO

Hi

  I'm having some problems adjusting a Delphi5/MSSQL database application, which i did not wrote (what's more: i'm not a Delphi expert either) so i thought maybe someone in this comunity will enlighten me. It' about an SQL command which is issued by this delphi5 application (the sql command was traced in SQL server with profiler), but which is nowhere to be found in the souce code. I've searched already all the components which i knew that could issue the SQL command (TADOQuery, TADOCommand) but with no l
uck. Could anyone tell me other misterious places where i should look for SQL commands? Thanks.

best regards
Albert
0
Albert
2/7/2013 4:49:57 PM
embarcadero.delphi.ado 597 articles. 1 followers. Follow

10 Replies
1319 Views

Similar Articles

[PageSpeed] 41

Albert Kiss wrote:

> Hi
> 
>   I'm having some problems adjusting a Delphi5/MSSQL database
> application, which i did not wrote (what's more: i'm not a Delphi
> expert either) so i thought maybe someone in this comunity will
> enlighten me. It' about an SQL command which is issued by this
> delphi5 application (the sql command was traced in SQL server with
> profiler), but which is nowhere to be found in the souce code. I've
> searched already all the components which i knew that could issue the
> SQL command (TADOQuery, TADOCommand) but with no l uck. Could anyone
> tell me other misterious places where i should look for SQL commands?
> Thanks.
> 
> best regards
> Albert


Can you tell us what the SQL statement looks like?

Did you look inside all the projects modules, including in the project
DPR file itself?


-- 
Steve Faleiro
0
Steve
2/7/2013 6:16:18 PM
"Albert Kiss" wrote in message news:545457@forums.embarcadero.com...
>
>  I'm having some problems adjusting a Delphi5/MSSQL database application, 
> which i did not wrote (what's more: i'm not a Delphi expert either) so i 
> thought maybe someone in this comunity will enlighten me. It' about an SQL 
> command which is issued by this delphi5 application (the sql command was 
> traced in SQL server with profiler), but which is nowhere to be found in 
> the souce code. I've searched already all the components which i knew that 
> could issue the SQL command (TADOQuery, TADOCommand) but with no l
> uck. Could anyone tell me other misterious places where i should look for 
> SQL commands? Thanks.


It's possible the ADO components are querying metadata. Can you show us the 
exact SQL that is being executed?

-- 
Wayne Niddery (TeamB)
"If there is any principle of the Constitution that more imperatively calls 
for attachment than any other it is the principle of free thought, not free 
thought for those who agree with us but freedom for the thought that we 
hate." - Oliver Wendell Holmes
0
Wayne
2/7/2013 6:30:32 PM
On 07.02.2013 17:49, Albert Kiss wrote:
>    I'm having some problems adjusting a Delphi5/MSSQL database application, which i did not wrote (what's more: i'm not a Delphi expert either) so i thought maybe someone in this comunity will enlighten me. It' about an SQL command which is issued by this delphi5 application (the sql command was traced in SQL server with profiler), but which is nowhere to be found in the souce code. I've searched already all the components which i knew that could issue the SQL command (TADOQuery, TADOCommand) but with n
o luck. Could anyone tell me other misterious places where i should look for SQL commands? Thanks.
>


Maybe the application constructs the SQL text piece by piece.  And the 
ADO component may have been created at runtime.  This would make your 
hunt more "interesting".

-- 
Aage J.
0
Aage
2/7/2013 8:43:06 PM
> {quote:title=Wayne Niddery wrote:}{quote}
> "Albert Kiss" wrote in message news:545457@forums.embarcadero.com...
> >
> >  I'm having some problems adjusting a Delphi5/MSSQL database application, 
> > which i did not wrote (what's more: i'm not a Delphi expert either) so i 
> > thought maybe someone in this comunity will enlighten me. It' about an SQL 
> > command which is issued by this delphi5 application (the sql command was 
> > traced in SQL server with profiler), but which is nowhere to be found in 
> > the souce code. I've searched already all the components which i knew that 
> > could issue the SQL command (TADOQuery, TADOCommand) but with no l
> > uck. Could anyone tell me other misterious places where i should look for 
> > SQL commands? Thanks.
> 
> 
> It's possible the ADO components are querying metadata. Can you show us the 
> exact SQL that is being executed?
> 
> -- 
> Wayne Niddery (TeamB)
> "If there is any principle of the Constitution that more imperatively calls 
> for attachment than any other it is the principle of free thought, not free 
> thought for those who agree with us but freedom for the thought that we 
> hate." - Oliver Wendell Holmes



  First of all i'd like to thank all of you for the answers and yes of course, i can show you the sql; moreover i'll send you a part of the trace in csv format, maybe it's more relevant to you:


RowNumber,EventClass,Duration,TextData,SPID,ClientProcessID,LoginName,StartTime
997351,10,971,"exec sp_executesql N'DELETE FROM ""DB120""..""MaInt"" WHERE ""MaUnit""=@P1 AND ""IniTime""=@P2',N'@P1 smallint,@P2 datetime',1220,'2013-02-04 22:41:23:000'",164,244,operator,38:38.6
997350,10,7390,exec dbo.proGetTandemMachines @idArea=1,127,1780,operator,38:36.1
997349,10,883,"exec [DB120]..sp_indexes_rowset N'LoCDett',NULL,NULL",296,244,operator,38:34.3
997348,10,2486,"exec [DB120]..sp_primary_keys_rowset N'LoCDett',NULL",296,244,operator,38:34.3
997346,12,13,SET NO_BROWSETABLE ON,296,244,operator,38:34.3
997347,10,43,"declare @p1 int  set @p1=1  exec sp_prepare @p1 output,NULL,N'SELECT * FROM LoCDett',1  select @p1",296,244,operator,38:34.3
997343,12,11,SET NO_BROWSETABLE ON,296,244,operator,38:34.3
997344,10,45,"declare @p1 int  set @p1=1  exec sp_prepare @p1 output,NULL,N'SELECT * FROM MiInt',1  select @p1",296,244,operator,38:34.3
997345,10,2887,"declare @p3 int  set @p3=1220  declare @p4 datetime  set @p4='2013-02-04 00:00:00:000'  declare @p5 int  set @p5=2  exec sp_executesql N'SELECT  Sum(Quantita) as Quantita   FROM  LoCDett    WHERE   Tipo =  ''BU''  AND  CodiceMaUnit =  @P1  AND  DataTno =  @P2  AND  NumeroTno =  @P3  ',N'@P1 int OUTPUT,@P2 datetime OUTPUT,@P3 int OUTPUT',@p3 output,@p4 output,@p5 output  select @p3, @p4, @p5",164,244,operator,38:34.3
997341,10,644,"exec [DB120]..sp_indexes_rowset N'MaInt',NULL,NULL",296,244,operator,38:34.3
997342,10,68,"declare @p3 int  set @p3=1220  exec sp_executesql N'SELECT  Sum(DurataToTMicro) as Durata, Sum(TotaleMicro) as Numero  FROM  MiInt    WHERE   MaUnit =  @P1  AND  DataTno =  @P2  AND  NumeroTno =  @P3  ',N'@P1 int OUTPUT,@P2 datetime,@P3 int',@p3 output,'2013-02-04 00:00:00:000',2  select @p3",164,244,operator,38:34.3
997340,10,6602,"exec [DB120]..sp_primary_keys_rowset N'MaInt',NULL",296,244,operator,38:34.3
997338,12,20,SET NO_BROWSETABLE ON,296,244,operator,38:34.2
997339,10,69,"declare @p1 int  set @p1=1  exec sp_prepare @p1 output,NULL,N'SELECT * FROM MaInt',1  select @p1",296,244,operator,38:34.2
997336,10,622,"exec [DB120]..sp_indexes_rowset N'MaInt',NULL,NULL",296,244,operator,38:34.2
997337,10,534,"declare @p4 datetime  set @p4='2013-02-04 00:00:00:000'  declare @p5 int  set @p5=2  declare @p6 varchar(16)  set @p6='1[0-9][0-9][0-9]'  exec sp_executesql N'SELECT  sum(Durata) As Durata, Count(Durata) As Numero  FROM  MaInt    WHERE   MaUnit =  @P1  AND  DataTno =  @P2  AND  NumeroTno =  @P3  AND  CodiceInt LIKE  @P4  AND  EndTime IS NOT NULL  GROUP BY NumeroTno  ',N'@P1 int,@P2 datetime OUTPUT,@P3 int OUTPUT,@P4 varchar(16) OUTPUT',1220,@p4 output,@p5 output,@p6 output  select @p4, @p5,
 @p6",164,244,operator,38:34.2
997335,10,6661,"exec [DB120]..sp_primary_keys_rowset N'MaInt',NULL",296,244,operator,38:34.2
997332,10,613,"exec sp_executesql N'SELECT  sum(Durata) As Durata, Count(Durata) As Numero  FROM  MaInt    WHERE   MaUnit =  @P1  AND  DataTno =  @P2  AND  NumeroTno =  @P3  AND   (CodiceInt NOT LIKE  @P4    OR   CodiceInt IS NULL)  AND  EndTime IS NOT NULL  GROUP BY NumeroTno  ',N'@P1 int,@P2 datetime,@P3 int,@P4 varchar(16)',1220,'2013-02-04 00:00:00:000',2,'1[0-9][0-9][0-9]'",164,244,operator,38:34.2
997333,12,12,SET NO_BROWSETABLE ON,296,244,operator,38:34.2
997334,10,43,"declare @p1 int  set @p1=1  exec sp_prepare @p1 output,NULL,N'SELECT * FROM MaInt',1  select @p1",296,244,operator,38:34.2
997331,12,13,SELECT 1,157,1780,operator,38:33.9
997330,10,878,"exec [DB120]..sp_indexes_rowset N'LoCDett',NULL,NULL",296,244,operator,38:31.1
997329,10,2536,"exec [DB120]..sp_primary_keys_rowset N'LoCDett',NULL",296,244,operator,38:31.1
997327,12,8,SET NO_BROWSETABLE ON,381,244,operator,38:31.0
997328,10,43,"declare @p1 int  set @p1=1  exec sp_prepare @p1 output,NULL,N'SELECT * FROM LoCDett',1  select @p1",381,244,operator,38:31.0
997324,12,10,SET NO_BROWSETABLE ON,296,244,operator,38:31.0
997325,10,43,"declare @p1 int  set @p1=1  exec sp_prepare @p1 output,NULL,N'SELECT * FROM MiInt',1  select @p1",296,244,operator,38:31.0
997326,10,2852,"declare @p3 int  set @p3=1220  declare @p4 datetime  set @p4='2013-02-04 00:00:00:000'  declare @p5 int  set @p5=3  exec sp_executesql N'SELECT  Sum(Quantita) as Quantita   FROM  LoCDett    WHERE   Tipo =  ''BU''  AND  CodiceMaUnit =  @P1  AND  DataTno =  @P2  AND  NumeroTno =  @P3  ',N'@P1 int OUTPUT,@P2 datetime OUTPUT,@P3 int OUTPUT',@p3 output,@p4 output,@p5 output  select @p3, @p4, @p5",164,244,operator,38:31.0
997323,10,70,"declare @p3 int  set @p3=1220  exec sp_executesql N'SELECT  Sum(DurataToTMicro) as Durata, Sum(TotaleMicro) as Numero  FROM  MiInt    WHERE   MaUnit =  @P1  AND  DataTno =  @P2  AND  NumeroTno =  @P3  ',N'@P1 int OUTPUT,@P2 datetime,@P3 int',@p3 output,'2013-02-04 00:00:00:000',3  select @p3",164,244,operator,38:31.0
997322,10,570,"exec [DB120]..sp_indexes_rowset N'MaInt',NULL,NULL",381,244,operator,38:31.0
997321,10,6589,"exec [DB120]..sp_primary_keys_rowset N'MaInt',NULL",381,244,operator,38:31.0
997319,12,10,SET NO_BROWSETABLE ON,296,244,operator,38:31.0
997320,10,40,"declare @p1 int  set @p1=1  exec sp_prepare @p1 output,NULL,N'SELECT * FROM MaInt',1  select @p1",296,244,operator,38:31.0
997317,10,657,"exec [DB120]..sp_indexes_rowset N'MaInt',NULL,NULL",296,244,operator,38:30.9
997318,10,569,"declare @p4 datetime  set @p4='2013-02-04 00:00:00:000'  declare @p5 int  set @p5=3  declare @p6 varchar(16)  set @p6='1[0-9][0-9][0-9]'  exec sp_executesql N'SELECT  sum(Durata) As Durata, Count(Durata) As Numero  FROM  MaInt    WHERE   MaUnit =  @P1  AND  DataTno =  @P2  AND  NumeroTno =  @P3  AND  CodiceInt LIKE  @P4  AND  EndTime IS NOT NULL  GROUP BY NumeroTno  ',N'@P1 int,@P2 datetime OUTPUT,@P3 int OUTPUT,@P4 varchar(16) OUTPUT',1220,@p4 output,@p5 output,@p6 output  select @p4, @p5,
 @p6",164,244,operator,38:30.9
997316,10,7278,"exec [DB120]..sp_primary_keys_rowset N'MaInt',NULL",296,244,operator,38:30.9
997314,12,13,SET NO_BROWSETABLE ON,296,244,operator,38:30.9
997315,10,45,"declare @p1 int  set @p1=1  exec sp_prepare @p1 output,NULL,N'SELECT * FROM MaInt',1  select @p1",296,244,operator,38:30.9
997313,10,610,"exec sp_executesql N'SELECT  sum(Durata) As Durata, Count(Durata) As Numero  FROM  MaInt    WHERE   MaUnit =  @P1  AND  DataTno =  @P2  AND  NumeroTno =  @P3  AND   (CodiceInt NOT LIKE  @P4    OR   CodiceInt IS NULL)  AND  EndTime IS NOT NULL  GROUP BY NumeroTno  ',N'@P1 int,@P2 datetime,@P3 int,@P4 varchar(16)',1220,'2013-02-04 00:00:00:000',3,'1[0-9][0-9][0-9]'",164,244,operator,38:30.9
997312,10,7666,exec dbo.proGetTandemMachines @idArea=1,127,1780,operator,38:26.1
997311,12,54,SELECT 1  ,213,244,operator,38:25.2
997310,12,29,SELECT 1,157,1780,operator,38:23.9
997309,10,868,"exec sp_executesql N'SELECT DataTno,NumeroTno,CodiceIntDett,DescrizioneDett,CodiceInt,Descrizione,  Round(CONVERT( real, (floor ((Sum(Durata)) / (60 * 1)) +  ((Sum(Durata) / 1) % 60) / 100.0)),2) AS DurataMin,  TestCod = CASE WHEN CodiceInt LIKE ''1[0-9][0-9][0-9]'' then 0 ELSE 1  END  FROM MaInt  WHERE MaUnit = @P1 AND DataTno = @P2  AND NumeroTno = @P3 AND EndTime IS NOT NULL  GROUP BY DataTno,NumeroTno,CodiceIntDett,DescrizioneDett,  CodiceInt,Descrizione ORDER BY DataTno DESC,NumeroTno,
CodiceIntDett  ',N'@P1 smallint,@P2 datetime,@P3 int',1220,'2013-02-04 00:00:00:000',2",164,244,operator,38:21.2
997308,10,1002,"exec [DB120]..sp_indexes_rowset N'LoCDett',NULL,NULL",55,244,operator,38:21.1
997307,10,2636,"exec [DB120]..sp_primary_keys_rowset N'LoCDett',NULL",55,244,operator,38:21.1
997305,12,9,SET NO_BROWSETABLE ON,55,244,operator,38:21.1
997306,10,50,"declare @p1 int  set @p1=1  exec sp_prepare @p1 output,NULL,N'SELECT * FROM LoCDett',1  select @p1",55,244,operator,38:21.1
997302,12,9,SET NO_BROWSETABLE ON,55,244,operator,38:21.1
997303,10,43,"declare @p1 int  set @p1=1  exec sp_prepare @p1 output,NULL,N'SELECT * FROM MiInt',1  select @p1",55,244,operator,38:21.1
997304,10,2770,"declare @p3 int  set @p3=1220  declare @p4 datetime  set @p4='2013-02-04 00:00:00:000'  declare @p5 int  set @p5=2  exec sp_executesql N'SELECT  Sum(Quantita) as Quantita   FROM  LoCDett    WHERE   Tipo =  ''BU''  AND  CodiceMaUnit =  @P1  AND  DataTno =  @P2  AND  NumeroTno =  @P3  ',N'@P1 int OUTPUT,@P2 datetime OUTPUT,@P3 int OUTPUT',@p3 output,@p4 output,@p5 output  select @p3, @p4, @p5",164,244,operator,38:21.1
997300,10,545,"exec [DB120]..sp_indexes_rowset N'MaInt',NULL,NULL",55,244,operator,38:21.1
997301,10,67,"declare @p3 int  set @p3=1220  exec sp_executesql N'SELECT  Sum(DurataToTMicro) as Durata, Sum(TotaleMicro) as Numero  FROM  MiInt    WHERE   MaUnit =  @P1  AND  DataTno =  @P2  AND  NumeroTno =  @P3  ',N'@P1 int OUTPUT,@P2 datetime,@P3 int',@p3 output,'2013-02-04 00:00:00:000',2  select @p3",164,244,operator,38:21.1
997299,10,7069,"exec [DB120]..sp_primary_keys_rowset N'MaInt',NULL",55,244,operator,38:21.1
997297,12,9,SET NO_BROWSETABLE ON,55,244,operator,38:21.0
997298,10,39,"declare @p1 int  set @p1=1  exec sp_prepare @p1 output,NULL,N'SELECT * FROM MaInt',1  select @p1",55,244,operator,38:21.0
997295,10,607,"exec [DB120]..sp_indexes_rowset N'MaInt',NULL,NULL",55,244,operator,38:21.0
997296,10,533,"declare @p4 datetime  set @p4='2013-02-04 00:00:00:000'  declare @p5 int  set @p5=2  declare @p6 varchar(16)  set @p6='1[0-9][0-9][0-9]'  exec sp_executesql N'SELECT  sum(Durata) As Durata, Count(Durata) As Numero  FROM  MaInt    WHERE   MaUnit =  @P1  AND  DataTno =  @P2  AND  NumeroTno =  @P3  AND  CodiceInt LIKE  @P4  AND  EndTime IS NOT NULL  GROUP BY NumeroTno  ',N'@P1 int,@P2 datetime OUTPUT,@P3 int OUTPUT,@P4 varchar(16) OUTPUT',1220,@p4 output,@p5 output,@p6 output  select @p4, @p5,
 @p6",164,244,operator,38:21.0
997292,12,12,SET NO_BROWSETABLE ON,55,244,operator,38:21.0
997293,10,42,"declare @p1 int  set @p1=1  exec sp_prepare @p1 output,NULL,N'SELECT * FROM MaInt',1  select @p1",55,244,operator,38:21.0
997294,10,6628,"exec [DB120]..sp_primary_keys_rowset N'MaInt',NULL",55,244,operator,38:21.0
997291,10,533,"exec sp_executesql N'SELECT  sum(Durata) As Durata, Count(Durata) As Numero  FROM  MaInt    WHERE   MaUnit =  @P1  AND  DataTno =  @P2  AND  NumeroTno =  @P3  AND   (CodiceInt NOT LIKE  @P4    OR   CodiceInt IS NULL)  AND  EndTime IS NOT NULL  GROUP BY NumeroTno  ',N'@P1 int,@P2 datetime,@P3 int,@P4 varchar(16)',1220,'2013-02-04 00:00:00:000',2,'1[0-9][0-9][0-9]'",164,244,operator,38:21.0
997288,10,70,"declare @p1 int  set @p1=87985  exec sp_prepare @p1 output,NULL,N'SELECT DISTINCT M.DataTno as DataTno,M.NumeroTno as NumeroTno,C.Tipo as Tipo, CONVERT(real, (floor(Sum(M.Durata)) / (60 *1) + ((Sum(M.Durata) / 1) % 60) / 100.0)) As DurataMin  FROM MaInt as M, CodiciIntr  as C  WHERE   M.MaUnit = 1220 AND  M.DataTno = ''02/04/2013'' AND  M.NumeroTno =2 AND M.CodiceInt=C.Codice GROUP BY  M.DataTno, M.NumeroTno, C.Tipo  ORDER BY  M.DataTno DESC, M.NumeroTno, C.Tipo   ',1  select @p1",164,244,op
erator,38:21.0
997289,10,4,exec sp_unprepare 87985,164,244,operator,38:21.0
997290,12,716,"SELECT DISTINCT M.DataTno as DataTno,M.NumeroTno as NumeroTno,C.Tipo as Tipo, CONVERT(real, (floor(Sum(M.Durata)) / (60 *1) + ((Sum(M.Durata) / 1) % 60) / 100.0)) As DurataMin  FROM MaInt as M, CodiciIntr  as C  WHERE   M.MaUnit = 1220 AND  M.DataTno = '02/04/2013' AND  M.NumeroTno =2 AND M.CodiceInt=C.Codice GROUP BY  M.DataTno, M.NumeroTno, C.Tipo  ORDER BY  M.DataTno DESC, M.NumeroTno, C.Tipo   ",164,244,operator,38:21.0
997287,12,148,SELECT 1  ,276,3144,operator,38:19.7
997286,10,7552,exec dbo.proGetTandemMachines @idArea=1,127,1780,operator,38:16.1
997285,12,13,SELECT 1,157,1780,operator,38:13.9
997284,10,831,"exec [DB120]..sp_indexes_rowset N'LoCDett',NULL,NULL",55,244,operator,38:13.9
997283,10,2515,"exec [DB120]..sp_primary_keys_rowset N'LoCDett',NULL",55,244,operator,38:13.9
997281,12,8,SET NO_BROWSETABLE ON,55,244,operator,38:13.9
997282,10,52,"declare @p1 int  set @p1=1  exec sp_prepare @p1 output,NULL,N'SELECT * FROM LoCDett',1  select @p1",55,244,operator,38:13.9
997278,12,10,SET NO_BROWSETABLE ON,55,244,operator,38:13.8
997279,10,87,"declare @p1 int  set @p1=1  exec sp_prepare @p1 output,NULL,N'SELECT * FROM MiInt',1  select @p1",55,244,operator,38:13.8
997280,10,2767,"declare @p3 int  set @p3=1220  declare @p4 datetime  set @p4='2013-02-04 00:00:00:000'  declare @p5 int  set @p5=2  exec sp_executesql N'SELECT  Sum(Quantita) as Quantita   FROM  LoCDett    WHERE   Tipo =  ''BU''  AND  CodiceMaUnit =  @P1  AND  DataTno =  @P2  AND  NumeroTno =  @P3  ',N'@P1 int OUTPUT,@P2 datetime OUTPUT,@P3 int OUTPUT',@p3 output,@p4 output,@p5 output  select @p3, @p4, @p5",164,244,operator,38:13.8
997276,10,574,"exec [DB120]..sp_indexes_rowset N'MaInt',NULL,NULL",55,244,operator,38:13.8
997277,10,66,"declare @p3 int  set @p3=1220  exec sp_executesql N'SELECT  Sum(DurataToTMicro) as Durata, Sum(TotaleMicro) as Numero  FROM  MiInt    WHERE   MaUnit =  @P1  AND  DataTno =  @P2  AND  NumeroTno =  @P3  ',N'@P1 int OUTPUT,@P2 datetime,@P3 int',@p3 output,'2013-02-04 00:00:00:000',2  select @p3",164,244,operator,38:13.8
997275,10,6586,"exec [DB120]..sp_primary_keys_rowset N'MaInt',NULL",296,244,operator,38:13.8
997273,12,9,SET NO_BROWSETABLE ON,296,244,operator,38:13.8
997274,10,38,"declare @p1 int  set @p1=1  exec sp_prepare @p1 output,NULL,N'SELECT * FROM MaInt',1  select @p1",296,244,operator,38:13.8
997271,10,608,"exec [DB120]..sp_indexes_rowset N'MaInt',NULL,NULL",55,244,operator,38:13.8
997272,10,529,"declare @p4 datetime  set @p4='2013-02-04 00:00:00:000'  declare @p5 int  set @p5=2  declare @p6 varchar(16)  set @p6='1[0-9][0-9][0-9]'  exec sp_executesql N'SELECT  sum(Durata) As Durata, Count(Durata) As Numero  FROM  MaInt    WHERE   MaUnit =  @P1  AND  DataTno =  @P2  AND  NumeroTno =  @P3  AND  CodiceInt LIKE  @P4  AND  EndTime IS NOT NULL  GROUP BY NumeroTno  ',N'@P1 int,@P2 datetime OUTPUT,@P3 int OUTPUT,@P4 varchar(16) OUTPUT',1220,@p4 output,@p5 output,@p6 output  select @p4, @p5,
 @p6",164,244,operator,38:13.8
997268,12,11,SET NO_BROWSETABLE ON,55,244,operator,38:13.7
997269,10,41,"declare @p1 int  set @p1=1  exec sp_prepare @p1 output,NULL,N'SELECT * FROM MaInt',1  select @p1",55,244,operator,38:13.7
997270,10,6636,"exec [DB120]..sp_primary_keys_rowset N'MaInt',NULL",55,244,operator,38:13.7
997267,10,591,"exec sp_executesql N'SELECT  sum(Durata) As Durata, Count(Durata) As Numero  FROM  MaInt    WHERE   MaUnit =  @P1  AND  DataTno =  @P2  AND  NumeroTno =  @P3  AND   (CodiceInt NOT LIKE  @P4    OR   CodiceInt IS NULL)  AND  EndTime IS NOT NULL  GROUP BY NumeroTno  ',N'@P1 int,@P2 datetime,@P3 int,@P4 varchar(16)',1220,'2013-02-04 00:00:00:000',2,'1[0-9][0-9][0-9]'",164,244,operator,38:13.7
997264,10,61,"declare @p1 int  set @p1=87984  exec sp_prepare @p1 output,NULL,N' SELECT    ColClt = 0,  DurataMin  = Round(CONVERT(real, (floor (round(M1.Durata / 1, 0) / 60.0) +    (round(M1.Durata / 1, 0) % 60) / 100.0)),2),    TestCod = (CASE WHEN M1.CodiceInt LIKE ''1[0-9][0-9][0-9]'' THEN 0 ELSE 1 END),          M1.*  FROM     MaInt M1 WHERE M1.MaUnit = 1220 AND M1.DataTno > ''02/01/2013 00:00:00''ORDER BY IniTime DESC  ',1  select @p1",164,244,operator,38:13.6
997265,10,3,exec sp_unprepare 87984,164,244,operator,38:13.6
997266,12,9764," SELECT    ColClt = 0,  DurataMin  = Round(CONVERT(real, (floor (round(M1.Durata / 1, 0) / 60.0) +    (round(M1.Durata / 1, 0) % 60) / 100.0)),2),    TestCod = (CASE WHEN M1.CodiceInt LIKE '1[0-9][0-9][0-9]' THEN 0 ELSE 1 END),          M1.*  FROM     MaInt M1 WHERE M1.MaUnit = 1220 AND M1.DataTno > '02/01/2013 00:00:00'ORDER BY IniTime DESC  ",164,244,operator,38:13.6
997262,10,813,"exec [DB120]..sp_indexes_rowset N'LoCDett',NULL,NULL",55,244,operator,38:10.8
997263,10,10095,"exec sp_executesql N'SELECT DataTno,NumeroTno,CodiceIntDett,DescrizioneDett,CodiceInt,Descrizione,  Round(CONVERT( real, (floor ((Sum(Durata)) / (60 * 1)) +  ((Sum(Durata) / 1) % 60) / 100.0)),2) AS DurataMin,  TestCod = CASE WHEN CodiceInt LIKE ''1[0-9][0-9][0-9]'' then 0 ELSE 1  END  FROM MaInt  WHERE MaUnit = @P1 AND DataTno = @P2  AND NumeroTno = @P3 AND EndTime IS NOT NULL  GROUP BY DataTno,NumeroTno,CodiceIntDett,DescrizioneDett,  CodiceInt,Descrizione ORDER BY DataTno DESC,NumeroTn
o,CodiceIntDett  ',N'@P1 smallint,@P2 datetime,@P3 int',1220,'2013-02-04 00:00:00:000',2",164,244,operator,38:10.8
997261,10,2561,"exec [DB120]..sp_primary_keys_rowset N'LoCDett',NULL",296,244,operator,38:10.8
997259,12,8,SET NO_BROWSETABLE ON,55,244,operator,38:10.8
997260,10,41,"declare @p1 int  set @p1=1  exec sp_prepare @p1 output,NULL,N'SELECT * FROM LoCDett',1  select @p1",55,244,operator,38:10.8
997256,12,10,SET NO_BROWSETABLE ON,55,244,operator,38:10.8
997257,10,43,"declare @p1 int  set @p1=1  exec sp_prepare @p1 output,NULL,N'SELECT * FROM MiInt',1  select @p1",55,244,operator,38:10.8
997258,10,2762,"declare @p3 int  set @p3=1220  declare @p4 datetime  set @p4='2013-02-04 00:00:00:000'  declare @p5 int  set @p5=2  exec sp_executesql N'SELECT  Sum(Quantita) as Quantita   FROM  LoCDett    WHERE   Tipo =  ''BU''  AND  CodiceMaUnit =  @P1  AND  DataTno =  @P2  AND  NumeroTno =  @P3  ',N'@P1 int OUTPUT,@P2 datetime OUTPUT,@P3 int OUTPUT',@p3 output,@p4 output,@p5 output  select @p3, @p4, @p5",164,244,operator,38:10.8
997254,10,572,"exec [DB120]..sp_indexes_rowset N'MaInt',NULL,NULL",55,244,operator,38:10.8
997255,10,65,"declare @p3 int  set @p3=1220  exec sp_executesql N'SELECT  Sum(DurataToTMicro) as Durata, Sum(TotaleMicro) as Numero  FROM  MiInt    WHERE   MaUnit =  @P1  AND  DataTno =  @P2  AND  NumeroTno =  @P3  ',N'@P1 int OUTPUT,@P2 datetime,@P3 int',@p3 output,'2013-02-04 00:00:00:000',2  select @p3",164,244,operator,38:10.8
997251,12,9,SET NO_BROWSETABLE ON,55,244,operator,38:10.7
997252,10,38,"declare @p1 int  set @p1=1  exec sp_prepare @p1 output,NULL,N'SELECT * FROM MaInt',1  select @p1",55,244,operator,38:10.7
997253,10,6511,"exec [DB120]..sp_primary_keys_rowset N'MaInt',NULL",55,244,operator,38:10.7
997250,10,537,"declare @p4 datetime  set @p4='2013-02-04 00:00:00:000'  declare @p5 int  set @p5=2  declare @p6 varchar(16)  set @p6='1[0-9][0-9][0-9]'  exec sp_executesql N'SELECT  sum(Durata) As Durata, Count(Durata) As Numero  FROM  MaInt    WHERE   MaUnit =  @P1  AND  DataTno =  @P2  AND  NumeroTno =  @P3  AND  CodiceInt LIKE  @P4  AND  EndTime IS NOT NULL  GROUP BY NumeroTno  ',N'@P1 int,@P2 datetime OUTPUT,@P3 int OUTPUT,@P4 varchar(16) OUTPUT',1220,@p4 output,@p5 output,@p6 output  select @p4, @p5,
 @p6",164,244,operator,38:10.7
997249,10,593,"exec [DB120]..sp_indexes_rowset N'MaInt',NULL,NULL",55,244,operator,38:10.7
997248,10,6648,"exec [DB120]..sp_primary_keys_rowset N'MaInt',NULL",296,244,operator,38:10.7
997246,12,11,SET NO_BROWSETABLE ON,55,244,operator,38:10.7
997247,10,42,"declare @p1 int  set @p1=1  exec sp_prepare @p1 output,NULL,N'SELECT * FROM MaInt',1  select @p1",55,244,operator,38:10.7
997242,10,80,"declare @p1 int  set @p1=87983  exec sp_prepare @p1 output,NULL,N'SELECT DISTINCT M.DataTno as DataTno,M.NumeroTno as NumeroTno,C.Tipo as Tipo, CONVERT(real, (floor(Sum(M.Durata)) / (60 *1) + ((Sum(M.Durata) / 1) % 60) / 100.0)) As DurataMin  FROM MaInt as M, CodiciIntr  as C  WHERE   M.MaUnit = 1220 AND  M.DataTno = ''02/04/2013'' AND  M.NumeroTno =2 AND M.CodiceInt=C.Codice GROUP BY  M.DataTno, M.NumeroTno, C.Tipo  ORDER BY  M.DataTno DESC, M.NumeroTno, C.Tipo   ',1  select @p1",164,244,op
erator,38:10.7
997243,10,4,exec sp_unprepare 87983,164,244,operator,38:10.7
997244,12,707,"SELECT DISTINCT M.DataTno as DataTno,M.NumeroTno as NumeroTno,C.Tipo as Tipo, CONVERT(real, (floor(Sum(M.Durata)) / (60 *1) + ((Sum(M.Durata) / 1) % 60) / 100.0)) As DurataMin  FROM MaInt as M, CodiciIntr  as C  WHERE   M.MaUnit = 1220 AND  M.DataTno = '02/04/2013' AND  M.NumeroTno =2 AND M.CodiceInt=C.Codice GROUP BY  M.DataTno, M.NumeroTno, C.Tipo  ORDER BY  M.DataTno DESC, M.NumeroTno, C.Tipo   ",164,244,operator,38:10.7
997245,10,528,"exec sp_executesql N'SELECT  sum(Durata) As Durata, Count(Durata) As Numero  FROM  MaInt    WHERE   MaUnit =  @P1  AND  DataTno =  @P2  AND  NumeroTno =  @P3  AND   (CodiceInt NOT LIKE  @P4    OR   CodiceInt IS NULL)  AND  EndTime IS NOT NULL  GROUP BY NumeroTno  ',N'@P1 int,@P2 datetime,@P3 int,@P4 varchar(16)',1220,'2013-02-04 00:00:00:000',2,'1[0-9][0-9][0-9]'",164,244,operator,38:10.7
997241,10,24237,"exec sp_executesql N'DELETE FROM ""DB120""..""MaInt"" WHERE ""MaUnit""=@P1 AND ""IniTime""=@P2',N'@P1 smallint,@P2 datetime',1220,'2013-02-04 17:20:43:000'",164,244,operator,38:07.5
997240,10,8439,exec dbo.proGetTandemMachines @idArea=1,127,1780,operator,38:06.1
997239,12,18,SELECT 1,157,1780,operator,38:03.9
997238,10,932,"exec sp_executesql N'DELETE FROM ""DB120""..""MaInt"" WHERE ""MaUnit""=@P1 AND ""IniTime""=@P2',N'@P1 smallint,@P2 datetime',1220,'2013-02-04 17:20:43:000'",164,244,operator,37:57.2
997237,10,7361,exec dbo.proGetTandemMachines @idArea=1,127,1780,operator,37:56.1
997236,12,55,SELECT 1  ,213,244,operator,37:55.2
997235,12,11,SELECT 1,157,1780,operator,37:53.9
997234,12,129,SELECT 1  ,276,3144,operator,37:49.7
997233,10,822,"exec sp_executesql N'DELETE FROM ""DB120""..""MaInt"" WHERE ""MaUnit""=@P1 AND ""IniTime""=@P2',N'@P1 smallint,@P2 datetime',1220,'2013-02-04 17:03:56:000'",164,244,operator,37:48.9
997232,10,7601,exec dbo.proGetTandemMachines @idArea=1,127,1780,operator,37:46.1
997231,12,12,SELECT 1,157,1780,operator,37:43.9
997230,10,799,"exec [DB120]..sp_indexes_rowset N'LoCDett',NULL,NULL",70,244,operator,37:43.9

I know, it looks pretty messy like this, but if you put it in a spreadsheet you get a completly different view. The lines numbered 997351,997241,997238 and 997233 are causing me the headaches, so if any ideas how do they got there...
0
Albert
2/8/2013 9:21:03 AM
Albert Kiss wrote:

> > {quote:title=Wayne Niddery wrote:}{quote}
> > "Albert Kiss" wrote in message news:545457@forums.embarcadero.com...
> > > 
> > >  I'm having some problems adjusting a Delphi5/MSSQL database
> > > application, which i did not wrote (what's more: i'm not a Delphi
> > > expert either) so i thought maybe someone in this comunity will
> > > enlighten me. It' about an SQL command which is issued by this
> > > delphi5 application (the sql command was traced in SQL server
> > > with profiler), but which is nowhere to be found in the souce
> > > code. I've searched already all the components which i knew that
> > > could issue the SQL command (TADOQuery, TADOCommand) but with no
> > > l uck. Could anyone tell me other misterious places where i
> > > should look for SQL commands? Thanks.
> > 
> > 
> > It's possible the ADO components are querying metadata. Can you
> > show us the exact SQL that is being executed?
> > 
 
> 
>   First of all i'd like to thank all of you for the answers and yes
> of course, i can show you the sql; moreover i'll send you a part of
> the trace in csv format, maybe it's more relevant to you:
> 
> 

 [snip]
 
> I know, it looks pretty messy like this, but if you put it in a
> spreadsheet you get a completly different view. The lines numbered
> 997351,997241,997238 and 997233 are causing me the headaches, so if
> any ideas how do they got there...

Clearly its some code in your app that is executing these SQL
statements on the database server.

Would it be possible for you to post your project to the attachments
group?


-- 
Steve Faleiro
0
Steve
2/8/2013 11:11:00 AM
> {quote:title=Steve Faleiro wrote:}{quote}
> Albert Kiss wrote:
> 
> > > {quote:title=Wayne Niddery wrote:}{quote}
> > > "Albert Kiss" wrote in message news:545457@forums.embarcadero.com...
> > > > 
> > > >  I'm having some problems adjusting a Delphi5/MSSQL database
> > > > application, which i did not wrote (what's more: i'm not a Delphi
> > > > expert either) so i thought maybe someone in this comunity will
> > > > enlighten me. It' about an SQL command which is issued by this
> > > > delphi5 application (the sql command was traced in SQL server
> > > > with profiler), but which is nowhere to be found in the souce
> > > > code. I've searched already all the components which i knew that
> > > > could issue the SQL command (TADOQuery, TADOCommand) but with no
> > > > l uck. Could anyone tell me other misterious places where i
> > > > should look for SQL commands? Thanks.
> > > 
> > > 
> > > It's possible the ADO components are querying metadata. Can you
> > > show us the exact SQL that is being executed?
> > > 
>  
> > 
> >   First of all i'd like to thank all of you for the answers and yes
> > of course, i can show you the sql; moreover i'll send you a part of
> > the trace in csv format, maybe it's more relevant to you:
> > 
> > 
> 
>  [snip]
>  
> > I know, it looks pretty messy like this, but if you put it in a
> > spreadsheet you get a completly different view. The lines numbered
> > 997351,997241,997238 and 997233 are causing me the headaches, so if
> > any ideas how do they got there...
> 
> Clearly its some code in your app that is executing these SQL
> statements on the database server.
> 
> Would it be possible for you to post your project to the attachments
> group?
> 
> 
> -- 
> Steve Faleiro

although i'd like very much to do that, i'm not allowed to... so i'm looking rather  for some  guidelines where should i start looking for this "hidden" code sequence... if anyone could help me with that would be greatly appreciated...
0
Albert
2/8/2013 3:14:36 PM
Albert Kiss wrote:

> > {quote:title=Steve Faleiro wrote:}{quote}
> > Albert Kiss wrote:
> > 
> > > > {quote:title=Wayne Niddery wrote:}{quote}
> > > > "Albert Kiss" wrote in message
> > > > news:545457@forums.embarcadero.com...
> > > > > 
> > > > >  I'm having some problems adjusting a Delphi5/MSSQL database
> > > > > application, which i did not wrote (what's more: i'm not a
> > > > > Delphi expert either) so i thought maybe someone in this
> > > > > comunity will enlighten me. It' about an SQL command which is
> > > > > issued by this delphi5 application (the sql command was
> > > > > traced in SQL server with profiler), but which is nowhere to
> > > > > be found in the souce code. I've searched already all the
> > > > > components which i knew that could issue the SQL command
> > > > > (TADOQuery, TADOCommand) but with no l uck. Could anyone tell
> > > > > me other misterious places where i should look for SQL
> > > > > commands? Thanks.
> > > > 
> > > > 
> > > > It's possible the ADO components are querying metadata. Can you
> > > > show us the exact SQL that is being executed?
> > > > 
> >  
> > > 
> > >   First of all i'd like to thank all of you for the answers and
> > > yes of course, i can show you the sql; moreover i'll send you a
> > > part of the trace in csv format, maybe it's more relevant to you:
> > > 
> > > 
> > 
> >  [snip]
> >  
> > > I know, it looks pretty messy like this, but if you put it in a
> > > spreadsheet you get a completly different view. The lines numbered
> > > 997351,997241,997238 and 997233 are causing me the headaches, so
> > > if any ideas how do they got there...
> > 
> > Clearly its some code in your app that is executing these SQL
> > statements on the database server.
> > 
> > Would it be possible for you to post your project to the attachments
> > group?
> > 
> > 
> > -- 
> > Steve Faleiro
> 
> although i'd like very much to do that, i'm not allowed to... so i'm
> looking rather  for some  guidelines where should i start looking for
> this "hidden" code sequence... if anyone could help me with that
> would be greatly appreciated...

As already mentioned, it could be code that is embedded in some ADO
components that have been dropped on one of the forms or datamodules in
your project. Or it could be Delphi code present in your project module
(DPR file) or one of the modules (PAS files) that is connecting to the
database and execucting. Check carefully.. Good luck.


-- 
Steve Faleiro
0
Steve
2/8/2013 4:31:43 PM
"Albert Kiss" wrote in message news:545957@forums.embarcadero.com...
>
> although i'd like very much to do that, i'm not allowed to... so i'm 
> looking rather  for some  guidelines where should i start looking for this 
> "hidden" code sequence... if anyone could help me with that would be 
> greatly appreciated...


The SQL in question clearly seems to be specific to your application. Thus 
it has to be in *some* .dfm or .pas file that is being compiled into the 
app.

Note that such files are not limited to what is listed in the project 
manager/dpr file; it can be a unit that is specified in any Uses clause in 
any of those units, or in any other those include in turn. Search every unit 
in the project folder and sub folders, and if still not found then you must 
start looking for other units in other folders that appear in any uses 
clause.

-- 
Wayne Niddery (TeamB)
"To take from one, because it is thought his own industry and that of his 
fathers has acquired too much, in order to spare to others, who, or whose 
fathers, have not exercised equal industry and skill, is to violate 
arbitrarily the first principle of association, the guarantee to everyone 
the free exercise of his industry and the fruits acquired by it. -- Thomas 
Jefferson
0
Wayne
2/8/2013 8:02:32 PM
Hello 
  is there any chance that the SQL could be set up within a stored procedure 
in your database server? If so, you might need to search for a call to that 
procedure, not some code that creates the SQL query itself.

Bruce


> "Albert Kiss" wrote in message news:545957@forums.embarcadero.com...
> 
>> although i'd like very much to do that, i'm not allowed to... so i'm
>> looking rather  for some  guidelines where should i start looking for
>> this "hidden" code sequence... if anyone could help me with that
>> would be greatly appreciated...
>> 
> The SQL in question clearly seems to be specific to your application.
> Thus it has to be in *some* .dfm or .pas file that is being compiled
> into the app.
> 
> Note that such files are not limited to what is listed in the project
> manager/dpr file; it can be a unit that is specified in any Uses
> clause in any of those units, or in any other those include in turn.
> Search every unit in the project folder and sub folders, and if still
> not found then you must start looking for other units in other folders
> that appear in any uses clause.
>
0
Bruce
2/11/2013 8:51:34 PM
> {quote:title=Bruce Eglington wrote:}{quote}
> Hello 
>   is there any chance that the SQL could be set up within a stored procedure 
> in your database server? If so, you might need to search for a call to that 
> procedure, not some code that creates the SQL query itself.
> 
> Bruce
> 

  I guess not (besides i have already checked that ;)). If this dubious SQL statement would be executed from a stored procedure (or trigger) in the SQLServer trace it should appear as executed from the server, which means the 'hostname' and 'clientprocessid' columns should be pointing clearly to the server which is not the case (it can be checked in the trace listing i've posted). 
  So the problem still remains... This is a very ugly bug, i think... It appears randomly in 3-4days only when certain conditions are met. The real mistery is how the fu$%^*%$&* accomplishes the delete from database, considering the fact that there isn't any delete related query in the source.
0
Albert
2/13/2013 8:41:13 AM
Reply:

Similar Artilces:

Convert Delphi 5 ADO App to Delphi 2007 ADO.NET
I have an appliction tha that is writen in Delphi 5 with ADOConnetion, ADOTable, and ADOQuery components. I need to upgrade to Delphi 2007 and use ADO.NET. I have the program building in with Delphi 2007. Is there anything I need to do to convert the ADO to ADO.NET? > I need to upgrade to Delphi 2007 and use ADO.NET. Why ? -- With best regards, Dmitry Arefiev AnyDAC (www.anydac.com) - Oracle, MS SQL Server, IBM DB2, MySQL, Firebird, Interbase, PostgreSQL, Sybase ASA, SQLite, MS Access, DBX, ODBC, InMem - universal high-speed native data access engine Reasons for ...

Delphi 6 to Delphi 2010 upgrade and ADO
We have an application written in Delphi 6 Professional that uses ADO to access databases servers that may be on other PCs in our network. We want to move to Delphi 2010 but can't decide if we need Professional or Enterprise. 2010 Pro has dbGO - will this give us the same functionality as the ADO components we use in Delphi 6 Pro? Thanks, Keith > 2010 Pro has dbGO - will this give us the same functionality as the > ADO components we use in Delphi 6 Pro? Yes. > {quote:title=Joachim Uersfeld wrote:}{quote} > > 2010 Pro has dbGO - will this give us the same func...

ASA7 ADO & Delphi ADO ?? Anyone is using it?
Any comments? Is it working? Any Problems? Thanks Hi, PR <noemail@no.com> schrieb in im Newsbeitrag: BoTThJaq$GA.89@forums.sybase.com... > Any comments? Is it working? Any Problems? I tried to connect to ASA7 via the new OLE DB - Provider and ADOExpress from Delphi 5.01. No chance. Only the error message 'Invalid Enum Value'. About the new provider I haven't heard anything good until now... Regards Frank Frank, I've experienced the same problem with the ASA 7 OLEDB Provider. I'm not sure if this is a bug in the AsaProvider or Delp...

ASA7 / ADO / Delphi 5.01
Has anyone figured out the problem with Delphi 5.01 and ASA7 via ADOExpress? All we get is Invalid Enum Value errors when trying to connect. Thanks, Rhett Price IndySoft Rhett, I've been informed by a Sybase representative in Norway that they are working on this problem, and hopefully have a fix in one of the first EBFs to come. Regards Ole Willy Tuv > Has anyone figured out the problem with Delphi 5.01 and ASA7 via ADOExpress? > All we get is Invalid Enum Value errors when trying to connect. ...

Delphi 5+ ADO ASAProv Problem
Hello, I try to connect from Delphi to ASA 7.03 with ADO. Via the ODBC Provider everthing seems to work. When I try to use ASAProv I can connect, but after connect the mode property of the connection is forced to cmUnknown and any attempt to open a result set lead to the error "Object or provider is not capable of performing requested operation". This is the same if I use the Connection string dialog or if connect manually ADOConnection1.ConnectionString:='Provider=ASAProv.70;Password=sql;Persist Encrypted=True;Persist Security Info=True;User ID=dba;Data Sourc...

Delphi 5 to Delphi XE4
Thinking about making the conversion. Of course we have numerous components such as: TurboPower AsyncPro, TurboPower Orpheus ICS2 Synactis All-In-The-Box. You guys have any advice as to the effort and time it may possibly take. It is a large application, several hundred thousand lines. And that's what happens when using third party components, a lot of extra work. I have been burned a few times. I now minimize the use to a few well known suppliers, like TMS. I have "banned" a lot of other components. Regards, Ole > > Thinking about making the conver...

Delphi 5 To Delphi 2009
I upgraded to Delphi 2009 from D5. The install says I can install Delphi and/or C++. Delphi installed OK but I see nothing of C++. What am I missing or does my upgrade not include C++? Thanks It depends on what you bought. If you bought Delphi 2009 only, that's what you get. If you bought Delphi 2009 and C++ Builder 2009 you get both. My guess is you got Delphi 2009 only. The simplest way to verify is look your invoice - it should say I would think. You could also go to members.embarcadero.com, login, then click on my registered products. There will be a textual description of...

Delphi 5 to Delphi 6 and up
Dear List, Trying to add 7Zip compression support to my delphi application. I am using the ported 7Zip sdk (see their website, they have a link). I am stumped on how to rewrite a single function: function ReverseDecode(var Models: array of SmallInt; ....): ..... where the input is mostly a fixed size array of SmallInt. This code perfectly compiles and functions in Delphi 6 and up, but in Delphi 5 I get the error: There is no overloaded version of 'ReverseDecode' that can be called with these arguments And obviously, the input (fixed) isn't the same as the param de...

SEPA components for Delphi with Source Code (Delphi 5
Hi all, in the european union change next year the Bankingformat to the SEPA Format. All peoples and companies must change the bankingssoftware and the costumer data form acountnummers in the new IBAN and BIC numbers. See: http://www.arma-it.de/shop/artikelueber.php?wgruppeid=211&wgruppe_offen=211 Functions: - generate SEPA XML'S - Calc IBAN - BIC Database (DE,AT and CH) Questions: vertrieb@arma-it.de PS: Bankinssoftware for Develpoers (Germany only) http://www.arma-it.de/shop/artikelueber.php?wgruppeid=212&wgruppe_offen=212 El 26/10/13 21:38, A...

Do the ADO components (DBGo) come with the Professional version of Delphi 5
Delphi 5 professional version comes with ADO components? If not then how can i get these component and where? What are the other option available with delphi 5 professional version to connect the oracle database? narendra rathod wrote: > Delphi 5 professional version comes with ADO components? If not then how can i get these component and where? What are the other option available with delphi 5 professional version to connect the oracle database? My recollection is that ADO was an upsell for Delphi 5, and we've not sold it for a long time, maybe 10 years. Your only option in the...

Upgrading to Delphi 2009 from Delphi 5
I've decided it's time to upgrade to Delphi 2009 Professional from my current Delphi 5 Professional which (according to the FAQ) makes me eligible for the upgrade pricing. However, I'd just like to clarify how this process works. My concern is that my Delphi 5 is not registered on the CodeGear site and this doesn't seem to be possible as far as I can tell. When installing the trial I noticed that Delphi 2009 registers itself with your CodeGear account so does this mean that the previous version must be registered there to verify you own a Professional edition? I plan to o...

Migration from Delphi 5 to Delphi 2005
Hi, Currently we are using Delphi 5 in that we have lot of source file now we planned to migrate from Delphi 5 to Delphi 2005. My question is - 1. Is it possible to migrate directly from Delphi 5 to Delphi 2005, my old code was developed using Delphi 5 IDE. Can we able to compile and build without any issue in Delphi 2005? 2. If we can able to do then what are the ways to migrate to Delphi 2005 IDE and also provide some link regarding this migrate? Thanks, Rizwan Rizwan Ahmed schrieb: > Hi, Currently we are using Delphi 5 in that we have lot of source > f...

Delphi 5 to Delphi 6 conversion
Hi We are moving our product from D5 to D6. I have dealt with all the deprecated functions. However, we are getting various platform specifc warnings. These include: Symbol 'FileGetAttr' is specific to a platform Symbol 'FileSetAttr' is specific to a platform Symbol 'faReadOnly' is specific to a platform We want this conversion to be carried out correctly. We don't view the simple solution of switching off those warnings or symbols as being the correct way. What we want is the same platform independence as other functions. For example, all o...

ASA7, ADO and Delphi
Hello! I've got a problem with accessing a database via ADO with Delphi 5. Everytime I set the ADOConnection active I get the error "Invalid enum value". I'm using Delphi 5 Enterprise and ASA7 with EBF #449. Is there anybody who ever get an ADOConnection to ASA7 with Delphi 5? Gruesse, Matthias I'm using C++ Builder 5 and get the same problem. I've asked this question before and no one seems to be able to respond... Matthias Hovestadt wrote: > Hello! > > I've got a problem with accessing a database via ADO > with Delp...