Recent content by MARTINRODDY

How hard is it to run an Excel macro through a Delphi program. I think an OLE excel object should be used ??? Then there is some command to run the macro ???? I appreciate any advice. Thanks Martin.

Hi, I have created an instance of an excel worksheet in a system I'm developing. The data is read from the spreadhseet and everything works fine. The problem I have is that the instance of excel stays open in memory when I close the software. The process list from alt+ctrl+del shows that...

Hi, I am looking to read data from several worksheets within an Excel Spreadsheet. I will then manipulate the data and write into an Oracle table. Can anyone shed light on the most efficient way of doing this. Would it be through an Excel component? I appreciate any help you can give me...

the delphi help files are as good as any most of the time.

I have been using Visual Source Safe for a while now. It is a good package. Dont know how you want it to integrate with Delphi. Martin

HI, I am trying to plot a contour map for a circlcular surface. I have the contour map working great for the square surface but for the round surface the contour map does not look correct. The contour lines are not joining. I am using the TChart component in Delphi 5. Here is the code...

i would go with the switch statement above. it is easier coded, easier read and more efficient than using multiple if statement. default can be used as the ultimate exception at the end. case option of 1: 2: 3: Martin

I have just started using JBuilder - I use QueryDataSet to do queries from an Oracle table. How do I insert rows onto the table?? I am not using a data aware control, the data is coming from a JTable.

how can i subtract one date from another to get the deifference in seconds. e.g. start date - end date Any help appreciated Martin

I am subtracting two dates to get the duration in a certian state. The duration will be in seconds. Some people have suggested using the: DateDiff(IntervalType,StartDateTime,EndDateTime) This is perfect, brillant piece of functionality. The only problem I have is...

It sets the date at 31/12/1899 because this is the first date in the calender. The calender is treated like an array, with base element 0, '31/12/1899' in this case. I would suggest formatting your date field with a formula; if field is null then date = sysdate I have had the same...

Hi there, I am trying to subtract 2 date and time fields to work out a duration in a state; For example: end time start time (26/11/2001 16:22:00) -(26/11/2001 16:00:00) duration here will = 00:20:00 in hh:mm:ss format. How can I do this...

Hi there, I am trying to convert a value like '75:04' (being 75 mins 04 secs) to HH:MM:SS format...............If anyone can offer help i would be gratful. Thanks Martin

Troyu, Here is a procedure that i wrote, it appends a string to the text file......hope it is some help procedure TForm1.WriteLog; var f: TextFile; LogFileName : string; begin LogFileName := 'C:\ERR_LOG\Errors.log'; AssignFile(f, LogFileName); Append(f); Writeln(f, Error...

Hi I am trying to update a record in a table using SQL within Delphi using the similiar code to the following: info_query.sql.clear; info_query.sql.add('update INFOTABLE set name = :name'); info_query.sql.add('where DBTABLE = '''+'COMPTECH_INFO'+''''); info_query.sql.add('and mach =...