Recent content by skuhlman

I'm trying to get my report (CR 8.5) to show at least one detail line on the same page as the group footer. I don't want to use "KEEP TOGETHER" because I don't want large (more than 2 inches) blank sections at the bottoms of some pages. My detail line(s) vary from .25 inches to an inch or...

I'm using Microsoft Visual Foxpro 7 and Crystal Reports 9 I've got the crystal viewer popping up with the report and am able to use the viewer's controls to "save as..." an excel or pdf or text or... file and it works great. Now I'm trying to program the ability to export the file directly...

We're using VFP7 here. The problem is that the Incremental Search (IncrementalSearch) is not working for us when our combo box contains disabled items (we disable the selection items by using the "\" leading character). The items are appearing correctly in the list as greyed out and disabled...

The following code creates a table (LoanTest), puts 3 sample starting records into the table, creates the indexes for the table, and creates an insert trigger for the table. In this example the insert trigger will use the startdate on the inserted record as the end date for any un-ended loan of...

I would do this using a trigger in most cases. The exception would be a table with a very large number of records, where changes to many records at a time happens on a regular basis. If changes to few records are being processed at any given time, I like the trigger as a way of keeping the...

It all depends upon how you know which records exist and which are missing? Are you comparing values from a different table? Are the records supposed to be sequential based upon a sequence field? ... Triggers and SPs can be used to validate the integrity of the table as long as rules can be...

The choice of Unions vs. Joins depends upon how you want the results to look. If you want A, B, and C data to all appear on a single record, you should use the JOIN. If you want A, B, and C to appear as 3 records with the same ID, you should use a UNION.

Your first JOIN is missing the ON clause select * FROM ( ) as A JOIN ( ) as B ON A.ID = B.ID JOIN ( ) as C on A.ID = C.ID

Mike, Thanks for the suggestions, but I've pretty much ruled out all of those things. The view has 37 fields (33 updatable) and 270 rows. The WHERE statement is correctly pulling the correct set of records into the view. I've checked and double and triple checked the field definitions. The...

Taking "very long" should not make the program "hang". I've run the same data through with and without the set step. With the "set step" it takes less than 1/2 a second to post the change to the back end. Without the "set step" the program will sit there "forever". We've let it hang for as...

useing VFP7 frontend with a SQL backend I am using a view to make modifications to some data. My TABLEUPDATE command hangs when it tries to run. If I put a SET STEP ON command immediately before the TABLEUPDATE statement, the debugger pops up and I can either RESUME or STEP INTO the code and...

Your code looks like it will work as long as the latest transaction number for an ID is on the latest date. The problem is when an earlier date has a higher transaction number than a later date's transaction. Your join conditions are saying that 1) the date matches the highest date and 2) the...

One of the fields in my data source contains one of the basic 15 colors used in the color dialog boxes (ie RED, BLACK, LIME, NAVY, SILVER...). I would like to just put the field in the color dialog box like: {MyDataSource.MyColorField} Since I can put "RED" in the conditional formating box...

Give something like this a shot: declare email_cursor cursor for select s.ord_hdrnumber, s.cmp_id, s.stp_schdtlatest, s.stp_arrivaldate, s.stp_departuredate, datediff(mi,s.stp_arrivaldate,GetDate()), s.stp_type, s.stp_event, o.ord_billto, l.lgh_driver1, l.lgh_tractor from...

Hi there, I'm looking for FREEWARE which can be used to give read only access to a SQL database. Any suggestions?