Hi Lee,
Only a slight variation of what you have will work.
For example, try this test:
transact = "123456"
daterecevd = DATE()
test=["<HTML> ;
<H2>Order information</H2> ;
<BODY>Regarding your order Ref: <B>"+ ;
TRIM(transact)+"</B> which was received by us on <B> ...
Hi Oakgrove,
Have you been able to resolve this? I guess I'm feeling bad that no one's replied to your question yet. :( Maybe it's cuz not many have used the new object-assisted reporting in VFP9. Actually, we don't even have VFP9 yet. So, despite risking complete and utter embarrassment by...
Hi Nikki,
I know your last post is a few months old. Just in case you see this message, could I take a look at the code you mentioned? ("I've also got a tool set up in Excel which creates pdfs automatically (i.e. bypassing the dialog box) from reports created in Excel. If you'd like a...
Thanks a lot guys for taking the time to reply.
Found something on MS website. Though it says it applies to VFP3, I can only assume it's still applicable to VFP7:
http://support.microsoft.com/default.aspx?scid=kb;en-us;136765
It says, regarding sorts done within an SQL: "temporary files...
In earlier versions of Foxpro, I remember the documentation said something like this: "to be safe, the amount of free disk space you'll need for temp tables created during SQL queries is about 2 to 3 times the total amount of disk space your database takes up."
Assuming I remembered...
Hi. One of our developers started working on a VB form that lets users pick the graph type, which fields to include, etc. Then when they click the <Show me the graph> button, all the properties are set. BUT, we're having problems trying to handle all the different graph types and the many...
Gippo,
Since you mentioned Service Pack 4, you probably already know about this:
http://gethelp.devx.com/techtips/vfox_pro/10min/10min0700.asp
This site specifically mentions problems fixed with the Hebrew localized version in SP4.
But, VFP 6.0 (Visual Studio) has a Service Pack 5. Here is...
Below is the resolution I used (well, pretty much. a lot of error checking code was removed). Many thanks to Dave S (DSummZZZZ) for the basic premise:
PROCEDURE fixblksize
PARAMETER p_dbf
l_saveblock = SET("BLOCKSIZE")
SET BLOCKSIZE TO 0
l_savesele = SELECT()
IF NOT USED(p_dbf)...
Dave,
Ohhhhhh.... what I had tried first was including the indexes in the copy, but it didn't like that because the indexes were built with the long names.
So, I'll 1) save index info, 2) copy without indexes, 3) do as you said (close/rename), then 4) rebuild the indexes.
I'll let you know...
(ugh...)
Thanks very much for the replies.
I must do this in code since the program has to be run at client sites.
I inherited this app from others who are long gone, so was hoping to write code that would be able to handle the things I don't know. I mean... even though I may not know...
Sorry in advance if this was answered elsewhere, but I couldn't find anything like this...
I have a DBC with some tables in it. Some of these tables have memo fields. I just ran into a problem with the FPT file sizes becoming HUGE. Turns out the blocksize was set to 64 (the default), and...
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.