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...
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...
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...
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...
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...
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...
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...
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...
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.
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...
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.
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...
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...
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.
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...
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...
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?
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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.