Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Bertiethedog
  • Order by date
  1. Bertiethedog

    code not working inside a transaction as expected

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

    code not working inside a transaction as expected

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

    code not working inside a transaction as expected

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

    code not working inside a transaction as expected

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

    code not working inside a transaction as expected

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

    INDEX ON coding problem

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

    code not working inside a transaction as expected

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

    Skipping problem

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

    Skipping problem

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

    Skipping problem

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

    Nav tools

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

    Nav tools

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

    encapsulation

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

    encapsulation

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

    encapsulation

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

    setting up db with mysql

    I had a problem with concept when I first started, In theory you don't need phpmyadmin at all, just the mysql control console. I have loaded a wamp server onto my portable which allows access to all the config files. Its quite difficult to request access to various files if you don't know of...
  17. Bertiethedog

    encapsulation

    Hi Obviously I am not stuck as I could go back to my original method of calling a completely seperate file (updatefuel.php) It would be nice if I could encapsulate the code with the calling form as neither are very big. At the mo I get error 404 Richard <th height="206" scope="row"><form...
  18. Bertiethedog

    field missing off report

    This is how I solved it I created a group Put the top part of the quote in the group header and the T&C's in the group footer. I had to be careful about "Floating" otherwise the fields in the group header would vanish. The T&C's will wrap onto the next page no problem. I still think a word...
  19. Bertiethedog

    field missing off report

    Thanks everyone for your help The report is a quotation and they wanted to put 24 lines of text on the bottom. I overcame it by stretching the report and placing it in the footer. I couldn't just type the text in as the customer wanted the ability to change the t&c's. Personally I would have...
  20. Bertiethedog

    field missing off report

    I have a stretchy line in a report which contains the terms & conditions. It is in the page footer area and contains 24 lines of text which should push it into page 2. Unfortunatly nothing is printed. Anyone have any ideas Richard

Part and Inventory Search

Back
Top