Search results for query: *

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

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

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

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

I have a string: test_123;3400;0 I want to be able to extract the middle substring 3400 What is the best way to do this ???? Any advice appreciated Martin

Hi, I am scoping out a new project at the moment. The report will be gathering information from Oracle tables and text files. Just trying to find out how well Crystal reports supports connection to txt files. Could someone give advice on this please. Thanks alot Martin

Hi, I am using strlcopy(buffer,PChar(job_array[kount].oper_id),oper_pos)); to extract a substring from a string e.g. 20001,20002,20003,20004 I want to get 20002 from this string ??? The above code works for the first substring. But can i use it to move into the string and extract a...

does anyone know the code that would return the selected row id from a string grid, from a click or double clik event on that grid ?????? Thanks Martin

how do i change the font colour of a cell in an exported spreadhseet using delphi 5 code...............i imagined something like excel.cells['b1'].color:=(clRed); ???????????????? Any suggestions welcomed please Martin

Does anyone out there know how to stretch the width of cells in spreadsheet so that the exported data all fits. I am exporting data from a string grid in my program to Excel spreadsheet. But when this happens the cells are not big enough Appreciated Martin

Hi there, I have a String Grid which contains records from an Oracle table. I wish to provide an option in the software to save the contents of the string grid out to a spreadsheet for analysis. I would be gratful if someone with experience in this could give me some information on how to...

Hi I have only srarted using the TreeView object recently. I am starting to get used to it. One question. Can someone tell me the command that allows a new node to be created during runtime. (and any other useful command if you...

I have a report of the following format: Bracnh: North Street J Bloggs Date: Transaction: J Bloggs 02/04/2001 L J Bloggs 01/04/2001 W J Bloggs 03/04/2001 L D Smith Date: Transaction: D Smith 04/04/2001 L D Smith...

COULD SOMEONE PLEASE CLARIFY THE DIFFERENCE OF COMPILING AND DISTRIBUTING A REPORT IN CRYSTAL V7. I WISH TO HAVE A STAND-ALONE FILE TO PLACE ON A PUBLIC DRIVE FOR ALL TO SEE. THE STEPS I AM TAKING ARE: 1: Report>Compile Report. I filled out the name of the compiled report 2: Then I go...