Delphi Pages Forums  

Go Back   Delphi Pages Forums > Search Forums

Lost Password?

Showing results 1 to 50 of 288
Search took 0.24 seconds.
Search: Posts Made By: rmt
Forum: General Today, 04:49 PM
Replies: 2
Views: 50
Posted By rmt
Dear Norrit, Actually I have the code below...

Dear Norrit,

Actually I have the code below to export adoDataSet Recordset into Excel. Now, I want to format the DATE column in excel with some datemask like 'yyyy-mm-dd'. So, how shall i check if...
Forum: General Today, 08:36 AM
Replies: 2
Views: 50
Posted By rmt
Check the datatype of the datafields of the RecordSet of TADODataset

Dear Expert,

I have been using the below code to check the datatype of the datafields of TClientdataset:

if (cdsReport.Fields[col].DataType = ftDateTime) then
//something here

Now, how...
Forum: General 12-19-2018, 09:56 AM
Replies: 0
Views: 5,388
Posted By rmt
delphi5 : To get top few records from ClientDataSet

Dear Team,

Kindly suggest if it is possible to get top few records from ClientDataSet in Delphi5; Like we do in sql as below:

select top 10 name from nameTABLE

Please suggest.

Thanks and...
Forum: General 12-12-2018, 09:24 AM
Replies: 2
Views: 5,564
Posted By rmt
Its resolved by using the solution in the link...

Its resolved by using the solution in the link below:

https://stackoverflow.com/questions/46505004/delphi-adoquery-clientdataset
Forum: General 12-12-2018, 06:46 AM
Replies: 2
Views: 5,564
Posted By rmt
Dear Expert, Kindly come up with suggestion....

Dear Expert,

Kindly come up with suggestion.

Thanks in advance
Forum: General 12-11-2018, 06:07 AM
Replies: 2
Views: 5,564
Posted By rmt
Delphi5: Load AdoDataSet with ClientDataSet

Dear Expert,

Kindly suggest how can I load AdoDataSet with ClientDataSet records in Delphi5 application.

Regards,
Rashmita
Forum: General 11-14-2018, 04:34 AM
Replies: 1
Views: 6,150
Posted By rmt
Delphi 5: Access violation at address 767E139D in module 'kernel32.dll'

Dear Expert,

I have a Delphi Application where I generate Report that uses Report Builder.
I am getting an error "Access violation at address 767E139D in module 'kernel32.dll'" in machine with...
Forum: General 11-12-2018, 07:26 AM
Replies: 0
Views: 6,044
Posted By rmt
Ignore Groups in TPPReport in Delphi5

Dear Expert,

I am developing a report using Report Builder 6.02 in delphi5. There are two groups in the report designer. I want only one group in one case and in other case i want both groups. I...
Forum: General 09-17-2018, 09:37 AM
Replies: 6
Views: 5,856
Posted By rmt
Dear Norrit, Actually this form is called...

Dear Norrit,

Actually this form is called from another form. Kindly suggest where i went wrong.

Regards,
Forum: General 09-17-2018, 07:44 AM
Replies: 6
Views: 5,856
Posted By rmt
Dear Norrit, The property [formStyle] of the...

Dear Norrit,

The property [formStyle] of the form is [fsNormal].

The actual code is as below:

var
DialogFormHandle: HWnd;

procedure TformPreviewReport.DataExportToExcel(cdsReport:...
Forum: General 09-17-2018, 06:41 AM
Replies: 6
Views: 5,856
Posted By rmt
Delphi5 MessageDlg window behind the main form

Dear Expert,

In my delpi5 application, I call MessageDlg Window. The Dialog pops up behind the main Form and locks the program as a result. Ho do I get the Dialog Window to appear on top of the...
Forum: General 07-31-2018, 04:18 AM
Replies: 1
Views: 950
Posted By rmt
Dear Expert, Please suggest. Thanks in...

Dear Expert,

Please suggest.

Thanks in advance.
Forum: General 07-30-2018, 09:23 AM
Replies: 1
Views: 950
Posted By rmt
To check if the given file is in use in delphi5

Dear Expert,

I am using the below function to check if the required file is in use in delphi5
application. The code is working in Windows7. However, it is not working in Windows 10 OS. Kindly...
Forum: General 07-23-2018, 09:03 AM
Replies: 4
Views: 1,007
Posted By rmt
Dear Norrit, Thanks for responding..

Dear Norrit,

Thanks for responding..
Forum: General 07-23-2018, 04:38 AM
Replies: 4
Views: 1,007
Posted By rmt
Dear Expert, Kindly come up with solution. ...

Dear Expert,

Kindly come up with solution.

Thanks in advance.
Forum: General 07-22-2018, 10:05 AM
Replies: 4
Views: 1,007
Posted By rmt
Inserting New Worksheet to CSV file from Delphi5 Application.

Dear Expert,

I am developing a program to export clientDataset to CSV file from Delphi5 application. I am loading StringList with clientdataset and saving file to CSV as below:

procedure...
Forum: General 06-19-2018, 03:41 PM
Replies: 2
Views: 1,142
Posted By rmt
dear Norrit, tnx a lot..its working.

dear Norrit,
tnx a lot..its working.
Forum: General 06-18-2018, 04:23 AM
Replies: 2
Views: 1,142
Posted By rmt
SQL SERVER ERROR: Explicit conversion from data type numeric to time is not allowed.

Dear Expert,

I am getting an error "Explicit conversion from data type numeric to time is not allowed" while trying to convert Numeric Value to Time.

Actually I am getting 10:00:00.0000000 and...
Forum: General 06-05-2018, 07:28 AM
Replies: 9
Views: 3,691
Posted By rmt
Dear Norrit, I think you need coffee this...

Dear Norrit,

I think you need coffee this time. The problem I mentioned here is when I export the value '1234.80' to CSV, it shows 1234.8 in CSV. So I took this approach using [1234.80] , it...
Forum: General 06-03-2018, 11:16 AM
Replies: 9
Views: 3,691
Posted By rmt
Dear Jasser, Sorry, I am replying after a...

Dear Jasser,

Sorry, I am replying after a long time. Actually all is well while exporting to excel. But while exporting to CSV, same problem e.g if i export the value '1234.80' to CSV, it shows...
Forum: General 04-27-2018, 06:34 AM
Replies: 1
Views: 1,224
Posted By rmt
Delphi5: Show Caps Lock Warning Message.

Dear Expert,

I would like to show capslock warning message on LogId exit event in my dephi application if CapsLock is on. I used below code to show respective message but I want to show the...
Forum: General 04-18-2018, 04:44 AM
Replies: 15
Views: 2,440
Posted By rmt
Dear Norrit, I have existing code as below....

Dear Norrit,

I have existing code as below. How shall I proceed now.

procedure TfrmMainForm.wwDBEditFeeExit(Sender: TObject);
begin
CalculateTotal;
end;

Procedure...
Forum: General 04-17-2018, 05:43 AM
Replies: 15
Views: 2,440
Posted By rmt
Sorry for the late feedback and thank you both...

Sorry for the late feedback and thank you both for suggestions.

Dear Norrit,

I tried the option given by you and its working as desired. The color is being changed on Exit and Enter. But how...
Forum: General 04-15-2018, 04:22 AM
Replies: 2
Views: 937
Posted By rmt
Dear Rojam, Thank you so much. Its working...

Dear Rojam,

Thank you so much. Its working as expected.

Regards,
Forum: General 04-13-2018, 06:50 AM
Replies: 2
Views: 937
Posted By rmt
Delphi5: How to detect click in Gutter(Left Margin)of TDbgrid

Dear Expert,

I am using TDBGrid in my Delphi5 application. I can detect the OnCellClick and OnDblClick Event. But I want to to detect click in Gutter i.e. when I clicked on Left Margin of the...
Forum: General 03-27-2018, 09:36 AM
Replies: 3
Views: 1,372
Posted By rmt
Dear Expert, Thanks for all help. But I...

Dear Expert,

Thanks for all help. But I coded as below and worked as desired.

procedure TfrmVerifyDataBackup.btnVerifyClick(Sender: TObject);
//var n:Integer;
var cmd: _Command;
Conn:...
Forum: General 03-27-2018, 04:14 AM
Replies: 3
Views: 1,372
Posted By rmt
Dear Norrit, Thanks for the suggestion. I...

Dear Norrit,

Thanks for the suggestion. I tried as below, but I could not get any message.

procedure TfrmVerifyDataBackup.btnVerifyClick(Sender: TObject);
begin
try
try...
Forum: General 03-26-2018, 10:23 AM
Replies: 3
Views: 1,372
Posted By rmt
Delphi5: Retrieve Messages returned while executing SQL command

Dear Expert,

How to read the Messages returned when SQL Query is executed from Delphi5 using TClientDataSet in case when Result Sets are not returned.

Suppose we are executing following SQL...
Forum: General 03-22-2018, 05:42 AM
Replies: 15
Views: 2,440
Posted By rmt
Dear lex, Thanks for the suggestion. Can u...

Dear lex,

Thanks for the suggestion. Can u please elaborate a bit more? Please provide me a code to override events.

Regards,
Forum: General 03-21-2018, 08:19 AM
Replies: 15
Views: 2,440
Posted By rmt
Delphi5: Change the Background Color of TEdit

Dear Expert,

I am working on a Delphi5 project. I need to change the Background color of TEdit component on its Entry. Once the Cursor enters the TEdit component, the color should change to say...
Forum: General 01-18-2018, 07:20 AM
Replies: 5
Views: 2,016
Posted By rmt
Dear Norrit, After removing...

Dear Norrit,

After removing (oExcel.Disconnect;oExcel.Quit; ) and using

ActiveWorkbook.SaveAs(FileName,xlNormal,EmptyParam,EmptyParam, EmptyParam, EmptyParam, ...
Forum: General 01-16-2018, 05:18 AM
Replies: 5
Views: 2,016
Posted By rmt
Dear Expert, Pls come up with some...

Dear Expert,

Pls come up with some suggestions.

Regards
Forum: General 01-12-2018, 08:02 AM
Replies: 5
Views: 2,016
Posted By rmt
Dear Norrit, Thanks for response. I tried...

Dear Norrit,

Thanks for response. I tried that but the new file being saved as excel is blank in this case.

Regards
Forum: General 01-12-2018, 07:03 AM
Replies: 5
Views: 2,016
Posted By rmt
Delphi5: All excel application closes while saving data using TExcelApplication

Dear Expert,

I am using the code as below to export Tclientdataset data to Excel sheet from delphi5 application. Everything is ok except all the EXCEL application closes while running the code....
Forum: General 11-02-2017, 03:56 AM
Replies: 8
Views: 3,068
Posted By rmt
Dear Rojam, It is not included in Delphi5....

Dear Rojam,

It is not included in Delphi5. After applying the code, I got an error "Too many actual parameters" while compiling.
Forum: General 11-01-2017, 04:52 AM
Replies: 8
Views: 3,068
Posted By rmt
Dear Rojam, Actually I have a Delphi5...

Dear Rojam,

Actually I have a Delphi5 application in which I am calling Form2 from MainForm. From Form2, I am trying to execute TOpenDialog which when gets executed and files selected and once the...
Forum: General 10-31-2017, 09:14 AM
Replies: 8
Views: 3,068
Posted By rmt
yes it is a form. And I am using Visible:=true...

yes it is a form. And I am using Visible:=true instead of showmodal since there are certain codes that get executed on Form's OnShow event. Hope it wont create any problem though.
Forum: General 10-31-2017, 07:08 AM
Replies: 8
Views: 3,068
Posted By rmt
Dear Expert, I need your suggestion. I...

Dear Expert,

I need your suggestion. I modified the previous code as below and it seems its working. Kindly suggest if it is ok.

procedure TfrmChqRelacc.btnBrowseClick(Sender: TObject);
var...
Forum: General 10-31-2017, 05:19 AM
Replies: 8
Views: 3,068
Posted By rmt
Delphi5: Delphi Calling Form moves behind while executing TOpenDialog

Dear Expert,

While executing TOpenDialog in Delphi5, the calling Form moves behind. The code is as below:

procedure TfrmChqRelacc.btnBrowseClick(Sender: TObject);
begin
try
...
Forum: General 10-27-2017, 04:05 AM
Replies: 4
Views: 2,232
Posted By rmt
Dear Rojam, I am using sqlserver .

Dear Rojam,

I am using sqlserver .
Forum: General 10-24-2017, 09:57 AM
Replies: 4
Views: 2,232
Posted By rmt
Delphi5 :Export TAdoDataSet to Excel

Dear Expert,

I am exporting TadoDataSet to Excel from Delphi5 application. All the values are exported properly. But in case of Numeric datatype, there is some error in excel "Number Stored as...
Forum: General 10-10-2017, 08:25 AM
Replies: 2
Views: 1,907
Posted By rmt
Please ignore this thread.

Please ignore this thread.
Forum: General 10-10-2017, 07:50 AM
Replies: 2
Views: 1,907
Posted By rmt
Delphi5 :If condition

Dear Expert,

The following is the code being used in delphi5;



The first showmessage() above shows EFalse i.e fState='E' and vValidSaveTF=False. But it meets the condition and shows second...
Forum: General 06-13-2017, 07:27 AM
Replies: 19
Views: 6,881
Posted By rmt
Dear Norrit, Emptied the folder, no change....

Dear Norrit,
Emptied the folder, no change. Problem occurs at SMTP.authenticate;
Forum: General 06-09-2017, 09:53 AM
Replies: 19
Views: 6,881
Posted By rmt
Dear Norrit, The result for given command in...

Dear Norrit,

The result for given command in both system is

C:\windows\system32\libeay32.dll

and same is for ssleay32.dll also.

And the size of both dlls are same in both system.
Forum: General 06-08-2017, 11:43 AM
Replies: 19
Views: 6,881
Posted By rmt
Dear Rojam, I am using DelphiXE3 . And as I...

Dear Rojam,

I am using DelphiXE3 . And as I have already mentioned in the post ,the application is working without any problem for 64 bit system with Windows 7 OS. Only the problem is in 64 bit...
Forum: General 06-07-2017, 03:57 AM
Replies: 19
Views: 6,881
Posted By rmt
Hi Expert, Please give some workable...

Hi Expert,

Please give some workable suggestion. I am not being able to make my code workable in windows 12 server.

Thanks.
Forum: General 05-30-2017, 04:32 AM
Replies: 19
Views: 6,881
Posted By rmt
Dear Norrit, No Change. Same error at same...

Dear Norrit,

No Change. Same error at same point. Hope for some other solution.
Forum: General 05-29-2017, 11:08 AM
Replies: 19
Views: 6,881
Posted By rmt
Dear Norrit, the problem is raised on the...

Dear Norrit,

the problem is raised on the following line:

SMTP.Authenticate;

Kindly suggest how to proceed further.
Forum: General 05-29-2017, 09:42 AM
Replies: 19
Views: 6,881
Posted By rmt
Dear Norrit, Software disabled and test ;...

Dear Norrit,

Software disabled and test ; not working.
Made Firewall off and test ; not working.
Copied Dll to respective folder and test; Not working.

Now, kindly suggest how shall i add...
Showing results 1 to 50 of 288

 
Forum Jump

All times are GMT. The time now is 08:28 PM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.