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 Chriss Miller 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: *

  1. igorsandler

    foxpro print

    You don't have to do it at the same time. Let user to print laser report and then call the program to create a text file
  2. igorsandler

    Valid event fires when clicked outside of test box

    I don't quite understand your sample code but I am assuming you are trying to validate the entry in this textbox and show the message if there is no value. Do it on LostFocus() and return -1 so the cursor stays in the textbox. I don't really like this because the user will have to enter...
  3. igorsandler

    Grid - control source being ignored.

    Just check every single grid control for Control Source. Finally, you can set all this up programmatically on the Form.INIT() before DEFAULT()
  4. igorsandler

    Help with default setting to capitalize key words

    Chris, have you seen the snapshot I sent to you? Does it look correctly to you? Because it doesn't work. I am typing some code inside the program
  5. igorsandler

    Help with default setting to capitalize key words

    Chris, that's what I thought but it doesn't do it. Here is what I got: And it still doesn't do it
  6. igorsandler

    Help with default setting to capitalize key words

    Well, when I will own the company I work for :), I will do it. For now I just work there
  7. igorsandler

    Help with default setting to capitalize key words

    Thank you but this is not what I was looking for. I was talking to capitalize by default. If I type alltrim and open parenthesis, it used to capitalize to ALLTRIM(. Doesn't do it anymoer.
  8. igorsandler

    Help with default setting to capitalize key words

    Hello fellow programmers. A bit embarrassed but will try it anyway. We are using FoxPro7 and I am having an issue with default capitalization of key words, like TRANSFORM() or ALLTRIM(). They keep showing up in low cases and, for the life of me, I can't find the default setting. Can't find it in...
  9. igorsandler

    Progress of report being processed

    You really need to determine Exactly how long it takes for the cursor to be created. Unless your report is extremely complicated and has a lot of formulas, as soon as the cursor has been created, the report should pop up nearly instantaneous. You can use Time() before Select and after and it...
  10. igorsandler

    Progress of report being processed

    Are you sure this time is for pulling report and not to create your cursor???
  11. igorsandler

    Report not receiving data properly

    Most likely, the form creates the alias but report set to private data session, like you said. Even though I don't understand how what did he mean by able to preview it but running the form it doesn't work. Seems preview in design mode, not GUI
  12. igorsandler

    Sorting an array

    What kind of error?
  13. igorsandler

    delete having more than 1 count

    Completely agree. I would go even further and I would create an updatable view, browse it first and if I like what I see, DELETE ALL==> TABLEUPDATE()===>Requery(), unless FoxUp is not familiar with views
  14. igorsandler

    sorting

    If you need to sort a view or a cursor, you can add an additional field to it INT(VAL(grade)) AS igrade_sort. If you need to order a table then you need to create an index, like it was suggested above. I am using it all the time
  15. igorsandler

    Can NOUPDATE prevent a DBF corruption

    Keep in mind the size of the table. Reaching 2GB will corrupt the table permanently
  16. igorsandler

    Sum of values in a Report Detail band

    Maybe I am missing something but if you have the totals already calculated on the form, then you don't need any report totals, just correct groupings on report and display form totals as a variables. Otherwise, you will need to create multiple groupings on the report and create report totals for...
  17. igorsandler

    SQL query syntax

    I am confused by your explanation. If you need a single record from the parent, why would you need any detail in the first place? The only thing you would have from detail or child is some kind of amount if you group and the rest of information from the child will collapse to the last...
  18. igorsandler

    Report with no Data Environment

    Well, you have very valid responses from other users and I completely agree with them about this very strange request. Report with 300 fields on one page? That would be pretty hard to implement. But if you still want to do it, the suggestion to create a bogus cursor with a number of records for...
  19. igorsandler

    Report with no Data Environment

    As long as those variables are public or global and the report has to be set with default data session. It's a bit weird, quite frankly. I don't see why you can't create a cursor at least with the fields selected on the form but without more details it's hard to day

Part and Inventory Search

Back
Top