Search results for query: *

Thanks both solutions are great.

oops sorry it was Zografski's solution.

Thank you all for your repies. David I have used your solution as it allows me to append to a text file after each record has been evaluated. However is there a way to force a carriage return after a line of text has been appended? Basically I am recording the details of those records that have...

Hi I have a program which evaluates a database and changes the value in a field if an expression is true. Everytime the expression is true I would like to send the record number and other information from various fields to a text file. What is the best way of doing this?

Thanks jrbbldr I will look into these. Jimstarr Yes this works, I did think of trying this, but dismissed it! Thanks a lot.

Sorry Imaginecorp I had not seen your response yet, I will run through your code now. Thanks

Jimstarr Thank you for responding. I have removed GO BOTTOM and achieve the same results, the whole purpose of the program is for it to append blank so I cannot remove this, is there a way around this?

I have two tables a and b. A contains numbers 1-10, b contains numbers: 1,1,2,3,3,4,5,6,7,8,9,10. I want to compare the records in a against the records in b. If they match then *do something. so far I have this however it will not append if there are multiple instances of the same number in b...

Thanks all - I had tried various combinations of ctod() but always got the "argument mismatch" error.

Hi This is probably really easy but can't seem to get my head around it. How do you clear a date field. E.g a date field has an existing date in it and I want to remove that date and make the field blank.

I have checked Constant Band Height and it is not checked. If the objects are not blank then I need them printed on a new page and as such have specified new page with group change. Could this be why it does not work.

Really?? Does it matter where the objects are i.e. detail, header or footer.

thanks boris but that did not work.

Is there a way to suppress a page in a report if it is blank. For example I have put print when conditions on fields in a multiple page report, If the conditions are not met a blank page is printed, is there a way of telling it " do not print page if blank

Thank you all for pointing me in the right direction. Looks like I need to start reading!

Thanks Jim These white papers seem very informative, hopefully they'll help me to piece everything together and create a greater understanding of how it all works!

Mike You will have to excuse me, this is very new territory for me. I have have an example of the render procedure which I found in the help text. "PROCEDURE RENDER(nFRXRecNo,; nLeft,nTop,nWidth,nHeight,; nObjectContinuationType, ; cContentsToBeRendered, GDIPlusImage) LOCAL llCopyImage...

Thank you very much for your sample, however although I can get the co-ordinates of my image how do I reposition it so that it is centered. Currently an image control is displayed in the top left hand corner of the page.

I tried to use one of the free support tickets you get when you buy the software, but they said because I had to tap into the report listener this was not covered and the most they could do was point me in the right direction. If I wanted them to write the code for me I would have to pay them...

Yes it is to center an image on a report. Do you understand what they want me to do?