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

  1. C

    Report not receiving data properly

    Perhaps I should add, BlueSharpe, what I explained was a basic concept not only of reports. If you take that concept of the current workarea into consideration you automatically arrive at a solution that differs from what I assume you're doing. But I don't exactly know what your doing, until...
  2. C

    Report not receiving data properly

    I wouldn't wonder in detail about what goes on there, it's up on BlueSharpe to provide more details. I would imagine you open up some tables to design the report, as that allows to make use of the Expression Builder dialog, for example. Then the rerpot runs fine from the report designer preview...
  3. C

    Report not receiving data properly

    Since you're completely new, there are two standard ways to feed a report with data. 1. The report has a private data session and you add the table or tables you want to print in the reports data environment 2. The has no private data session and you feed it from whatever is the current...
  4. C

    .dbf files mysteriously gone missing (or being deleted)

    To be very clear about PACK: It's neither documented that it creates new files nor what file extensions they get, it's only clearly known from experience. Likewise that once it completes you have the same filenames and no kept bak or other files. What file extensiosn PACK uses is undocumented...
  5. C

    .dbf files mysteriously gone missing (or being deleted)

    Okay, I experimented a bit and in case someone modifies a table with the table designer, one of two cases apply: a) the table designer uses the dbf exclusive and no other user can open it b) the table designer does not get exclusive access and only shows the dbf structure in read only mode...
  6. C

    .dbf files mysteriously gone missing (or being deleted)

    No, you were asking "Does the 'strange name' have any pattern?" and all I was saying is that VFP only chnages the extension of files it works on or creates temporary files with other extensions than normal to finally rename them. If you search the help for bak or .bak you don't find PACK, so...
  7. C

    .dbf files mysteriously gone missing (or being deleted)

    Just one obvious thing nobody mentioned - maybe because it's obvious: The best protection against data loss, no matter if by table corruption or the file deletion you encountered, is a backup of data. That should be a feature of your software. You're concentrating very much on just the problem...
  8. C

    .dbf files mysteriously gone missing (or being deleted)

    Sorry, I got this wrong. You also said: "In one case, the owner is the only one using our software. There isn't any good reason to sabotage himself." I took that as there being a single user mode, where you might give the user the ability to modify the tables. There could also be the case...
  9. C

    .dbf files mysteriously gone missing (or being deleted)

    Have you even found a bak file? The only documented case for a bak file is using the table designer. And that's not a runtime feature. If you just work on data with either APPEND, REPLACE and (xBase) DELETE or SQL INSERT/UPDATE/DELETE you never get a bak file.
  10. C

    .dbf files mysteriously gone missing (or being deleted)

    I agree with what ggreen said last. But when your dbf is missing after an alter table or using the table designer to change the structure, that means storing the latered table failed and you may have the old structure in a DBC or have some informations about the table updated, some not. In...
  11. C

    Report printed status

    The solution that always works is a reportlisteners OnPreviewClose method and SYS(2040) works with SET REPORTBEHAVIOR 80 or in older VFP versions (up to 8). So there's a solution to any case.
  12. C

    Report printed status

    Just watch out, in REPORTBEHAVIOR 90, SYS(2040) does not become "2". I double checked that in VFP9 9.0.0.7423. I think it's be design, as VFP 9 report behavior is using a pagecage that exactly prints what preview showed and thus does not do a separate pass for actual printing. You might be able...
  13. C

    .dbf files mysteriously gone missing (or being deleted)

    That's also an option I thought of, but it's following the whol off topic thread. Since Vince said his software is used by one person and they want to use it, I don't see a reason they sabotage it at all and that train of thought was gone far off and too far in the totally wrong direction. If...
  14. C

    Report printed status

    Which version of VFP are you using. If it's the usual VFP9, you can make use of the reportlistener "OnPreviewClose" method. The help on that has good example code.
  15. C

    .dbf files mysteriously gone missing (or being deleted)

    That's not a good idea, you know a dbf most of the time has a cdx and fpt file, too. You said that one has no fpt, but that's not generally the case, is it? If you restore some state of a dbf that was saved as a .bak file that doesn't match the fpt and cdx files, you gain nothing. Find the root...
  16. C

    Report layout differs when running

    This was done without specifing the "from left" value but using the snap-to-grid functionality. For finer granularity in smaller steps I reduced the grid spacing, that's up to you, of course. You also have several other tools others also mentioned already, like the layout toolbar. You can...
  17. C

    Report layout differs when running

    Just to showcase what is possible: 1. The Report Designer screenshot: 2.The Report Preview Screenshot 3. PDF Output viewed at 400% zoom: I don't see any problem. Do you?
  18. C

    Report layout differs when running

    The snap to grid function only works whn using the mouse to position objects, just like it works in the form designer. That's not true. All left sides of bands are the same offset from the left page margin: The margin width you set, so put in the same "from left" number and the labels left...
  19. C

    Report layout differs when running

    Fine, SitesMasstec. The HPOS values are the "from left" position. I don't see them matching for Emissao and Navio, for example. So you haven't alligned these labels in the designer. Simple truth, simple effect. Of course you don't get aligned output, it's not even aligned in the design.
  20. C

    .dbf files mysteriously gone missing (or being deleted)

    Neither SQL (Insert/Update/Delete) nor xBase (Replace, Append, Delete) do that. I wonder what you mean by updating tables. I already mentioned ALTER TABLE, if you mean structural updates, but they are not the normal operation. And by the way, not even using transactions creates new/other files...

Part and Inventory Search

Back
Top