Search results for query: *

Hi All, I need to pass a parameter from one form to another. For example, suppose I have a form containing a grid control that gives me a list of customers. I would like to click on one of the rows and open a new form to display all the customer's details. If I pick up the CustomerId field...

Hi all. I have an application written in Delphi 7 which accesses an Interbase 2007 database using dbExpress. I have created a master / detail relationship between 2 tables using a nested dataset. There is a 'Before Insert' trigger / generator on the master table which generates a unique id...

Many thanks to both of you for replying so quickly! I have applied the formatting you suggested and it works a treat. Thanks for your help. Regards, Merceng

Hi, I have an Excel 2003 spreadsheet which has been created by exporting data from a Delphi application. I have written a macro to format the output (change column widths, add colours etc) and this is working fine. However, I need to format a range of cells containing numbers such that if the...

Unclejimbob Many thanks for taking the time to reply (twice!) I copied your example and adapted it to reflect the structure of my data and it works a treat. The only problem I'm having is with the line to strip off the trailing comma (sCSV = substr(sCSV,1,strlen(sCSV)-1);). I have defined...

Hi All, I am trying to write an Interbase (Version 6.5) stored procedure (or view) that returns a key field and count followed by comma-separated string derived from a recordset containing multiple rows. For example, my data is as follows : Machine Centre Machine Name C/Lathe...

Windows XP Pro, CR XI, Delphi 7, Interbase 6.5 Hi, I am having a similar problem to Tom's I have a report that needs to print 5 memo fields at the bottom of the page. Since the size of the fields can vary, I have checked the 'Can Grow' option for each field and placed each of them in a...

Hi All, Crystal XI Developer Windows XP Pro I need to colour the backgraound of a Crystal Reports text object depending on whether a file exists in a particular folder on the server. I know how to conditionally change the background colour but is there any way to check whether the file exists...