Recent content by Bertiethedog

Got it Though a little surprised I somehow had a filter set, but I thought a replace all respected filters Anyway emergeny over and thanks to everyone who has helped me Richard Preston Lancs

mmerlinn I used to program in 2.6 as an IT contractor and regularly had my code assesed, SinceI started on vfp6 I have been a lone programmer or working from home. I havn't had my vfp code assesed ever, when you are self taught your thoughts and techniques tend to be limited. For instance...

Thanks everybody for your comments, I am a bit old fashioned & I like to have all the code in the exe as well as the problem of changing a dbc on a system that I will never have direct access to. (without a long drive). I am due to make a few table changes this week & I have been trying to...

I derived a cursor from this table _cursor so I scan _cursor for !deleted() and the records are put into a flagged record in the table I see what you mean Mike but it works without the transaction processing. I am not too worried but the code isn't as bomb proof as I would like, in this...

Yes the table is buffered and I am doing a Tableupdate during the transaction processing

By the way if you are going to use the index route use DTOS instead of dtoc YYYYMMDD Seeking an answer seek(dtos(date())

I have a tendancy to reuse records So a typical peice of code to amalgamate a cursor with the original table would be BEGIN TRANSACTION select <parent table> change flag field to 0 for matching records select <cursor> scan locate or seek the flagged field transfer the info endscan...

You won't believe this, the problem was in the report. Many thanks to everyone that made suggestions Richard

Hi so do I the cursor was created manually then had to be populated. The code to populate it is complex. I then selected the cursor and ran the report, the set skip was desperation. Regards Richard

I don't think this is a report problem but I have this bit of simple code SELECT _tmp2 SET SKIP TO _tmp2 REPORT FORM orderacks TO PRINTER PROMPT PREVIEW the report seemed to be skipping through the wrong table With the set skip in place we get "_tmp2 is not related to the current work...

I had a tidy up & decided to copy all the ocx files into the system32 directory where the should be anyway Because the .lic files were not in the same directory it was allowing the run time version to work but I couldn't open any of the forms. My own fault for trying to tidy up Rich

Now I have a problem I have a properly purchased and licensed copy of nav tools a faily old version but its not up to me to upgrade it When I modify form frmmainForm It has started throwing the error "ole error code 0x80040112" I have tried this on two seperate machines and recovered a backup...

Sorry I havn't replied earlier, but its been a bit busy. I am also trying to recover from an illness as well as keeping my contract. Thanks to jPadie, I will try out this technique as soon as I get half an hour to have a play Richard

lets see if i have this right. create the form in a variable $output the default action is Print $output and show the complete form. Then say by changing a variable say $action to 1 and rerunning the form it would say do some calculations instead. I already do something similar for my invoice...

thanks I have loads of simple forms with simple actions & its handy if they are all in the same file Richard