Messed up calculations.
I have an inventory program that does complex interest calculations
using several tables. The previous version was in VFP5. But for about
a year now with VFP9 a few of my customers complain of ocasional
wrong results. It seems random and I cannot reproduce it on my
XP PC with their tables. Most customers don't seem to have the
problem and run fine. Never had that problem with VFP5.
Is there a bug in VFP9 that could cause that and/or in connection
with other interfering software residing in memory?
-----------------------------------------------------------------
Paul Lee ........ Abri Technologies ........ http://www.abri.com/
'Recover' - top rated FoxPro file repair utility.
----------------------------------------------------------------- Tag: Test Tag: 236203
Remote view with date parameter?
Hi,
VFP 9.0 sp1, I'm trying to build a parameratized remote view against a SQL
2000 backend where the parameter is a date. The field on the SQL table is
of type datetime.
My view looks like this:
create view myview connection myconnection as ;
select slip_number, date_printed ;
from packing_slips ;
where date_printed >= ?prndate
My test code looks like this:
prndate = date()
use myview in 0
browse
This returns many records with various dates, not just todays dates. I
tried putting dtoc(date()) but that changed nothing. There must be a way to
do this, any suggestions?
The SQL table has slip_number of type varchar and date_printed as type
datetime. When I run the code form the query analyzer I simply enter the
date as '09-14-2007' and it converts automatically.
Thanks in advance,
Linn Tag: Test Tag: 236199
Why isn't intellisense ON a default?
The screwy installation I'm working has intellisense off by default, so I
turn it on manually. Isn't there a way to save "on" as the default?
-Lew Tag: Test Tag: 236183
Report Preview Toolbar
Hi,
My user sometimes closes the report preview toolbar instead
of the actual report. is there a way that if the toolbar is closed,
the report will also close?
Thanks,
Herbert Tag: Test Tag: 236182
String Search
Is there a function that can do this:
Search String as one expression only:
"black white"
Result I want to have:
"black"
"white
"black white"
"white black"
"black blue white"
Thanks Tag: Test Tag: 236177
Common dialog with additional control?
I need to display a common dialog with an extra checkbox for a user option.
I have tried using the _comdlg class in VFP foundation classes. After
dropping the comdlg on a form I have tried the following code:
thisform._COMDLG1.AddObject('chkTest', 'checkbox')
thisform._COMDLG1.chkTest.visible = .t.
thisform._COMDLG1.chkTest.caption = 'MyCheckbox'
thisform._COMDLG1.chkTest.top = 11
thisform._COMDLG1.chkTest.left = 11
thisform._COMDLG1.showdialog()
Nothing happens, and I get no error messages. Can someone tell me what I
missed? Tag: Test Tag: 236176
Its urgent - half page report
hi all,
I have to make the layout of the invoice printing which should fit in half
page. but the paper which i am using is A4. I always need to take two copies
of invoice. Therefore, i want to use the upper size of paper as invoice with
rates and lower size of paper without rates. please help me is it possible?
Also is it possible to print the report twice on the same page.
any other way of using half page layout. I hope i am clear in explaining my
problem.
In brief, how to print the report on half page?
I tried to make the paper size as custom size but seems many printers are
not supporting it. I mean after making it custom size, the paper size turn
backs to original A4 size. any solution. Earlier i used to manage it by way
of making report in foxpro under dos. Tag: Test Tag: 236175
VFP?
I'm puzzled. The rage in the development tools industry now is dynamically
typed, designer languages, some even talking about command line interpreters
coming soon. There is even a project working closely with Microsoft on a so
called Dynamic Library Runtime (DLR) which works with the CLR that .NET is
built on to facilitate creation of these dynamically typed languages. So
here sits the worlds largest software house, strangling the last bits of
life out of the world's greatest dynamically typed data oriented language.
Is this another case like with the internet and security where Microsoft has
completely missed the boat? Tag: Test Tag: 236172
Southwest Fox conference 2007
North America's best Visual FoxPro conference will take place in Mesa (near
Phoenix), Arizona. It is the place to be in October 2007 as the top VFP gurus
on the planet show you how to make the most of VFP. http://www.swfox.net/
Place: Arizona Golf Resort and Conference Center, Mesa, Arizona
Dates: October 18 - 21, 2007
Worth every nickel....
--
Message posted via http://www.dbmonster.com Tag: Test Tag: 236168
Is rename always copy/erase?
I can't find an api call for a simple rename, leading to my question: Is
rename *always* a copy/erase function?
-Lew Tag: Test Tag: 236159
How do I capture time input from a user in a 24 hour format
How do I capture time input from a user in a 24 hour format without the
date and seconds? I need to get the arrival time and departure time from
a user and find the time in between.
Thanks,
Thorkell Tag: Test Tag: 236139
Lost dev environment
Hi All,
All of a sudden my VFP has lost it's memory. Before, yesterday, when I
would launch VFP the Task Manager would pop up and have a list of recently
used projects. When opening a project all the tabs, Data, Documents,
Classes, Code and Other, would open with all of the trees left in how I had
them when using them previously. The editor windows would open sized the
way I liked them, even the command window would be as I had it setup.
All of a sudden, just today, everything acts like it had never been opened
before. The task manager doesn't remember my recent projects, the All tab
is the default and all the windows open small so I have to resize them to
use them.
What gives? The only thing I remember doing is compiling the application
and creating an install routine with Install Shield Express. Any one know
how I can recover my environment, or at least get VFP to remember it from
session to session? This is VFP 9.0 sp1, BTW.
Thanks,
Linn Tag: Test Tag: 236136
VFP to SQL via ODBC add records to table with key field
Using VFP 9 remote view connecting to SQL 2005 via ODBC.
On the SQL side I have a table with three fields, one is a primary key type
BigInt, other two are text
On the VFP side I have a remote view selected, append blank, browse, type in
number to key, then text to other two.
When I try and close the view it errors out saying the key field does not
accept null values, but in the remote view it is not null and has a value.
There is only one record added in the remote view.
What am I missing? Tag: Test Tag: 236135
Dumb Grid Question
I would like to use a method to modify a specific cell's value using a
cell click/rightclick event.
Not seeing anything obvious with respect to taking action on a single
cell... i.e. if the cell is readonly, is there a way to run a method on
the cell when it's clicked/rightclicked?
Feeling dumb again... help!
Thanks in advance,
Beverly Howard Tag: Test Tag: 236134
Troubles in showing a web site which contains a flash animation
I have developed a Visual FoxPro 6.0 application which has two forms.
The first form has the following value "2 - As Top-Level Form" in
"ShowWindow" property. The second one has the following value "1 - In
Top-Level Form" in "ShowWindow" property; it also has the following
value "0 - Off" in "TitleBar" property. So, the first form becomes the
main window, and the second one is located inside the main window
area. In the main window an ole control named "_webbrowser4" (based on
"ShellExplorer2" class) is inserted for showing a website content. My
aim is to show a set of banners, which are shown in a sequential way;
these banners are animated gifs, jpgs and flash animations. In the
second form I inserted a TextBox object for entering a string.
The trouble is: when a flash animation is showed in the web site, the
TextBox object loses the focus, which may cause an inconvenience to
user who is entering data in a Textbox. I would like to know how I can
avoid that "_webbrowser4" ole control (from the main window) gets the
focus, when a banner with Flash is showed (this doesn't happen when a
banner with an animated gif or with a jpg is showed).
The ole control named "_webbrowser4" is located in the following class
library:
c:\Program Files\Microsoft Visual Studio\Vfp98\Gallery\_webview.vcx
Thank you for your help. Tag: Test Tag: 236127
filetostr() /strtofile() capacities
I have to make multiple copies of some files in the size range of 2000 to
7000 kb and it seems like it'd be more efficient to do a single filetostr()
followed by multiple strtofile()'s --rather than multiple copy's - I'm using
winapi CopyFile()-- but I have no clue as to how this would affect system
performance. The pc in question has 2g ram.
Can anyone share their experience with this sort of thing?
-Lew Tag: Test Tag: 236126
table names from a query
Hi
I have 2 like querys. The only difference is one picks the .T. , the other
picks the .F.
Here is the code behind the query;
SELECT Reservefile.pbfrsvcd1, SUM(Reservefile.wrvrsvamt),;
Reservefile.pbfcd, COUNT(Reservefile.pbfrsvcd1),;
SUM(Reservefile.pbfprm), SUM(Reservefile.pbfprmannl),;
SUM(Reservefile.pbfamt), SUM(Reservefile.wrvprmdefg),;
SUM(Reservefile.wrvprmdefn), SUM(Reservefile.wrvprmuneg),;
Reservefile.wrvyr1flag, Reservefile.wrvprmcd, Reservefile.pmdtype,;
SUM(Reservefile.wrvprmunen);
FROM ;
reservefile;
WHERE Reservefile.wrvyr1flag = ( .T. );
GROUP BY Reservefile.wrvyr1flag, Reservefile.pbfrsvcd1;
ORDER BY Reservefile.pbfcd, Reservefile.pbfrsvcd1;
INTO TABLE 1styear.dbf
This query names the table A or B or C Then expect to find that file later.
The second query
SELECT Reservefile.pbfrsvcd1, SUM(Reservefile.wrvrsvamt),;
Reservefile.pbfcd, COUNT(Reservefile.pbfrsvcd1),;
SUM(Reservefile.pbfprm), SUM(Reservefile.pbfprmannl),;
SUM(Reservefile.pbfamt), SUM(Reservefile.wrvprmdefg),;
SUM(Reservefile.wrvprmdefn), SUM(Reservefile.wrvprmuneg),;
Reservefile.wrvyr1flag, Reservefile.wrvprmcd;
FROM ;
reservefile;
WHERE Reservefile.wrvyr1flag = ( .F. );
GROUP BY Reservefile.wrvyr1flag, Reservefile.pbfrsvcd1;
ORDER BY Reservefile.pbfcd, Reservefile.pbfrsvcd1;
INTO TABLE renewal.dbf
This one names the table renewal.dbf ---as I want.
I do not want aliass
thanks
sherry Tag: Test Tag: 236120
File exists notification or dir update
I'm writing a program that processes files arriving on our server via ftp. Is
there a windows service that could notify me or my program when files arrive
in the target directory? A work around is adir() plus a timer control, I know.
-Lew Tag: Test Tag: 236119
MAPI program loop
I am using the MAPI control to send email from my application but it
seems that if I send an email to one email address then subsequently try
to send another message to another email address I get a program loop
(somewhere). My code is as follows (executed in the click method of a
button)
If !This.Parent.signon() && Use the custom method
MESSAGEBOX("Email sign-on failed.",16,thisform.caption)
Return
ENDIF
If This.Parent.LogSession && Check if the user was able to login
This.Parent.OleMMess.sessionid = This.Parent.OleMSess.sessionid
* Start a new mail message and build the text
This.Parent.OleMMess.compose
lcMessageText = '<No Text>'
lcSubject = '[tbs]'
lcRecipAddress = lcemail
lcRecipDisplayName = lcRecipAddress
This.Parent.OleMMess.RecipAddress = lcRecipAddress
This.Parent.OleMMess.RecipDisplayName = lcRecipDisplayName
This.Parent.OleMMess.msgnotetext = lcMessageText
This.Parent.OleMMess.msgsubject = lcSubject
This.Parent.OleMMess.Send(1)
This.Parent.OleMSess.signoff
MESSAGEBOX("Signed off")
Endif
Is there a method other than signoff that I need to call to discard the
message?
The button is on a form that has a list of potential contacts and the
intent is to be able to go down that list and select individual contacts
to send an email to.
thanks
pete Tag: Test Tag: 236114
Exact match using INLIST()
Hi --
Using VFP9 + XPPro.
I tried to use the INLIST() function in an SQL SELECT statement to get
only certain information from a table. I used SET EXACT ON before
running the statement. However, this did not result to "exact"
matches.
For example, I asked for 'African American', but I received 'African
American', as well as 'African American Females', and 'African
American Males'. I finally had to redo the statement without the
INLIST() function and use the "==" convention.
Thanks in advance for any clarification or advice.
David Tag: Test Tag: 236109
Lookups in listbox?
Hi,
Using VFP 9.0 sp1, I have a listbox control setup where the bound column is
1 of 2 columns. I have the row source type set to 6 and have picked my two
fields from the cursor. Column one is an ID and column two is a name. When
I tab into or select the listbox I can type an ID and it finds it in the
list, pretty cool. However, my users really think in names, not ID's. How
can I allow the fast searching by the second column but still return the
first column in the value?
I tried simply changing the bound column to 2 but then it returned the name
not the ID, which I need for a lookup. I'm sure this can be done I just
haven't figured out how yet. Any suggestions?
Thanks in advance,
Linn Tag: Test Tag: 236101
frx not found
Help! I compiled an vfp9 sp2 exe which includes frx, not error during build.
Then I copy the exe to other directory and try to run it. It can not find the
included frx!
Did I missing anything? Please help!
TIA Tag: Test Tag: 236083
Michael Hogan on XML at Chicago FUDG at 11 Sep 07
The topic at the September 11 meeting of Chicago FUDG will be "MetaTables
Using XML: Tables Within Tables" presented by Chicago's own Michael Hogan.
Data changes: fields required for different types of records may differ. When
different records within the same table require one-to-one joins with
different child tables or when a table gets bloated with mostly unused fields,
it's time to consider a more efficient way of handling the supplemental data.
XML to the rescue! Using VFPâ??s CursorToXML and on-the-fly cursor structures
you can encapsulate that data in memo and varchar fields. You'll learn how
to:
* Avoid table bloat from rarely-used fields in tables
* Save and extract phantom sub-tables from memo and varchar fields
* Use different sub-table structures for different record types
* Use Memo to Object and Memo to Cursor techniques and their corollaries
* Choose When to use or not use this technique
Michael Hogan is an independent VFP consultant, and runs Ideate, LLC to
provide business solutions in the Chicago area. His primary tools are Visual
FoxPro and Web Connection.
Same time and place. Tues, Sept 11th. 5:30 pm. 53 W Jackson Blvd, Suite
826.
Dues are due. And bring a fin for pizza. We'll have a report from the Fox
Forward Conference in Atlanta. See ya then.
More info and upcoming meetings at http://www.ChicagoFUDG.com
Future speakers include Whil Hentzen, Toni Feltman, and a CFUDG members night.
--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums.aspx/foxpro-general/200709/1 Tag: Test Tag: 236072
Subst.exe internal table
Is there a way to retrieve the drive letters & associated devices created by
subst.exe? (Would need to distinguish bet these and those created via net use
calls). Tag: Test Tag: 236069
ShowWindow situation
I have a method called OpenDatabaseFiles. This method can be called
from the LOAD method or a Database Maintenace procedure to switch
processing to another database. The main form is a TLF.
If there is an error loading the database, I want to show wizard like
forms to help the users correct the condition.
Problem is, from the Load method, you cannot show the forms in a TLF
because it is not ready yet (ShowWindow = 1) while from the Database
Maintenance procedure I want to show in the TLC. ShowWindow is a
read-only property so it is not possible to set the setting before
activating the form.
The only solution I can see is the have two forms, one ShowWindow = 2
for the LOAD procedure and Show Window =1 for the Database
Maintenance procedures. Then put all the logic in a container that is
added in Initialization.
I would appreciate your expertise and comments
Lee Jefferies Tag: Test Tag: 236057
Creating an inline attachment for Outlook
I am using FoxPro7 to create a mailer using Outlook 2000. I wish to add a .
jpg as an inline attachment, which I have not been able to do. I am able to
creat the message with the .jpg as normal attachment. Can someone give me the
Foxpro statement to add a .jpg as an inline attachment?
Mohan
I got the following response from the Outlook forum:
Reply to this Message Report Abuse Ken Slovak - [MVP - Outlook] - 09-06-
2007 23:24
You won't find many or any FoxPro programmers here but just use the
olByReference argument when you add the attachment and not olByValue.
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm
I then tried the VBA forum; from where I got the advice to use olByreference
instead if p\olByValue
But my problem is
oooooooo
olByValue (=1)attaches the normal attachment
olByReference (=4) attaches a Shortcut
OlEmdeddedItem (=5) attaches a shortcut
olOLE (=6) attaches a shortcut.
My statement is - lonewmsg.Attachments.Add("d:\prdpl\order\greetings2.jpg",5,
1)
Can someone help?
Mohan
--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums.aspx/foxpro-general/200709/1 Tag: Test Tag: 236051
programming question
I would like to know why the data can't append to the output file from the
script below:
**
close databases
set date to british
set safety off
set century on
set cpdialog off
set talk off
set defa to c:\GP\utilities
set path to c:\GP\utilities
startday=ctod("01/09/2007")
endday=ctod("03/09/2007")
inpath = "D\Source\"
USE ABC_Count
ZAP
in_date = startday
DO WHILE in_date <= endday
?in_date
wdate = DTOC(in_date,1)
wdd = SUBSTR(wdate,7,2)
wmm = SUBSTR(wdate,5,2)
wyy = SUBSTR(wdate,1,4)
filename = inpath + wyy + wmm + "\" + wyy + wmm + wdd + "-stock.dbf"
use &filename in select(1) alias a
select a.date,a.location,a.stock,ud.type, ;
sum(iif(a=1)) as stockAcount, ;
sum(iif(b=0)) as stockBcount, ;
from a;
group by a.location;
into table a1
APPEND FROM a1 FOR (stock= 'A')
REPLACE bdate WITH in_date FOR EMPTY(bdate)
in_date=in_date+1
ENDDO
copy to stock.csv type xls
close database Tag: Test Tag: 236047
The Windows Help (WinHlp32.exe) program is no longer included with
http://support.microsoft.com/kb/917607/en-us
Windows Help (WinHlp32.exe) is a Help program that has been included with
Microsoft Windows versions starting with the Microsoft Windows 3.1
operating system. WinHlp32.exe is required in order to display 32-bit help
content files that have the ".hlp" file name extension.
However, the Windows Help program has not had a major update for many
releases and no longer meets Microsoft standards. Therefore, starting with
the Windows Vista operating system release, the Windows Help program will
not ship as a component of the Windows operating system. Also, third-party
programs that include .hlp files are prohibited from redistributing the
Windows Help program together with their products.
Users who want to view 32-bit .hlp files must download the program from the
Microsoft Download Center, and then install it on their computers. Users
who have not installed this program on their computer will be directed to a
help topic in the Windows Vista Help and Support application. To download
WinHlp32.exe, visit the following Microsoft Web site: Tag: Test Tag: 236041
Printing labels?
Hi All,
I am trying to put together a simple label printing program but, of course,
am having a small problem(s). I have my data setup following a previous
post on relating views. I have a view with names and I use the selected
name to then query another view for addresses. Each name may have more than
one address.
In the second view I select the address I am interested in and have defined
a report with the layout that I want. Problem is that if I print someone
with more than one address all their addresses are printed, not just the
address I selected. Anyone know of any examples of how to do this? Or a
better approach I should be taking?
I thought about using scatter to an object but then I didn't know how to
reference that object in the report designer. I'm thinking it is a scoping
issue, I don't quite know how to make the scattered object global.
To print the labels we have a fancy thermal label printer with 4" x 5"
labels. I've only been using the print preview so I don't know if it will
work for sure or not. With that in mind, is there anyway to hard code the
printer so that the user doesn't have to select it each time?
Also, we want to print only one label at a time, not a set of records, just
the person and address combination the user selects.
Hope all this makes sense and that someone can offer some suggestions. I'm
using VFP 9.0sp1 btw.
Thanks in advance,
Linn Tag: Test Tag: 236032
odbc, foxplus and office desktops apps
When I create a standalone table via copy to ... type foxplus/fox2x, do all
other office apps still use odbc to view the table or do some of them use old
style direct file io? I ask because I'm rewriting an older app & the previous
developer believes that the foxplus/fox2x tables can always be opened by
other office apps regardless of odbc version/install issues. I find this
difficult to believe. Anyone know for sure?
-Lew Tag: Test Tag: 236026
Collecting data in vfp vs fox2x
I need to collect and sum data from related database, something I know
how to do in fox2x based on the speed and efficiency limits of that
platform, but would like to get input on (efficient) ways to do the same
in vfp.
Assuming a large related table with a handful of records meeting the
relation scope, how would I best sum a (non indexed) numeric field field
for the scope of the relation?
here's what I assume would still be most efficient;
select ordent &&parent
onum = ordernum
select orddet &&o2m child
if seek(onum)
CALCULATE sum(qtyord * price) while ordernum = onum TO otot
*or
sum (qtyord * price) TO otot while ordernum = onum
endif
select ordent
goto recno()
Thanks in advance,
Beverly Howard Tag: Test Tag: 236017
Old spr bug occurs when changing from VFP8 to VFP9
This is an odd one that I doubt anyone has encountered but I'll throw it
out in case I get lucky:
We have a large application (hundreds of screens) that was developed in
the FP2.6 days that has been working fine under VFP8. For our next
release we'd thought it would be a good idea to move the development to
the latest version of VFP9 (SP1). We thought we got through the
transition clean but now a strange problem has popped up.
On quite a few of the old SPRs that were created with 2.6 where we have
a list that is populated from a field the list is not being refreshed
when the user selects to add a record (via a button). The code behind
the button just does:
APPEND BLANK
SHOW GETS
If you put your cursor in the list then it refreshes correctly and shows
you the new record.
What's odd is there is also a button that deletes a record. It has code
that deletes the record and then does a "SHOW GETS". This button works
fine.
If I run the code in VFP8 it works as intended. If I then run it with
VFP9 I get the quirky behavior.
Any insight would be greatly appreciated,
- Lee Blue Tag: Test Tag: 236014
programing question
Hello,
I am sure I am asking a stupid one and maybe the answer is already out
there, but when you don't know what keywords to search for that practically
nulifies that.
Ok so I have this filter that I want to make shorter:
substr(Invlines.Product,1,3)='CAP' Or substr(Invlines.Product,1,3)='CCC' Or
substr(Invlines.Product,1,3)='CCO' Or substr(Invlines.Product,1,3)='CDC' Or
substr(Invlines.Product,1,3)='CDO'
so I want to say in one line of code search the first three letters of this
product and pull out all that have the CAP, CCC ... and so on.
Thank you. Tag: Test Tag: 236009
Packing Code?
Having just gone through a worst case scenario related to lost source
code and noting another thread here concerning maintaining reference
code, I'm wondering if there is any way to easily include a zip or other
file containing an application's code within the application itself.
Expanding on the thought, an option could be included in the utility
menu to copy the file out to disk.
At the moment, I'm uploading a zip containing the current code to the
customer's site with each build but it would seem that an embedded
solution would be preferable for a number of possible reasons.
I've tinkered with simply including the zip in the project, but that
does not seem to be workable. I note the "other" file category but
havn't yet found how to directly manipulate that.
The info on projects seems to show a lot of power, but nothing directly
related to this type of need.
Any thoughts and other solution approaches would be appreciated.
Beverly Howard Tag: Test Tag: 235998
SQL Aggregation and .NULL. Mess
On investigation of a bug in a report, it turns out that some
work might not have any disbursements. Because I have been using
inner joins to add columns to build up the report data, that work does
not show up on the report.
I have solved this, I think, but it is not nice. Where I join
the various columns together and there is danger of .null., I have
made the joins left outer, the resulting cursor readwrite, and follow
by replaces like
replace thing with 0 for isnull(thing)
for each potentially-.null. column.
You think this is a kludge, right? So do I. It is too easy to
miss a case, and it is ugly.
Is there a better way of handling these idiot .null.s?
(I am quite aware that the sum of zero numbers is 0. A pity SQL
does not understand.)
(Yes, I could use set enginebehavior, but that is likely to bite
if I have to have a VFP 9 SQL feature.)
Sincerely,
Gene Wirchenko
Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices. Tag: Test Tag: 235982
Tree View in Grid
Hello,
Can anyone help on Create a form by using Tree View in a grid ?
- Reference , Particulars , Amount
- Product Amount
- Product Amount
+ Reference, Particulars , Amount
+ Reference, Particulars , Amount
Regards,
John Chu Tag: Test Tag: 235980
Command Buttons
Dear "All"
How can i add command buttons interactively on my forms..
example : if i type 5 on the textbox then it will display 5 command buttons
on the form..
it that possible?
thanks...
gechelle Tag: Test Tag: 235974
Using writemethod()
I'm trying to automate the adding of a method and code to a series of vcx
class defs. Using .WriteMethod() generates the error "...must be in design
mode." So how do I get into design mode from a prg? (I've actually posted
the answer to this question on this list, but I lost the code & don't
remember the answer.)
--
-Lew
The workers took the robot for Maria. Tag: Test Tag: 235973
Preparing to install VFP 9
Why to I get & how do I turn off the annoying message "Preparing to install
VFP 9 ..." when I click on a .prg in Windows Explorer? VFP 9 has been
installed for years & it's working fine.
--
-Lew
The workers took the robot for Maria. Tag: Test Tag: 235972
PDFSplitMerge - wierd !
Hi All
I have been out of town, so I have started a new thread
My previous post said:
<<We just purchased PDFSplitMerge from Guangmingsoft
It is a set of dll's that work fine in development
Does not work in runtime (vfp9, sp1)
Fails on createobject>>
on further testing, this is not correct !
our framework has classes: cntSend, and Frmrpt that are used
here
Frmrpt class has cntSend as member, cntSend handles report,
email, fpt, etc thru contained classes cntMapi etc
situation 1:
method cntSend.open tries to:
This.oSplitMerge =
createobjec("PDFSplitMerge.PDFSplitMerge.1")
in development, this works once !!
on 2nd attempt, fails (restarting vfp => once again)
in runtime, always fails
situation 2
Frmrpt button has code:
oObj = createobjec("PDFSplitMerge.PDFSplitMerge.1")
this works always in development and runtime !!
anybody have any idea what is going on ?
al
ps. for anybody who is interested, when this works it is
very fast, combines 50 reports into one pdf over 10 MB in
about 1 second ! Tag: Test Tag: 235969
Vista Solutions
Hi.
When running a vfp app in vista "aero" you get the missing borders on child
forms and dropdown box items all get highlighted when using the mouse. If you
run an app as administrator, the problem magically goes away. Microsoft
obviouslly has the code to fix these display issues. Can they not just parse
out the code that fixes the display problem and make it as another
"compatibility" option. Surely the code involved can't be "dangerous" enough
to warrant being run as administrator. I,m sure millions of apps could
benefit from this. Is there someone who can be emailed the suggestion that
would actually take it a serious look at it? Thanks.
Mike Tag: Test Tag: 235960
Field called Year
I have a field I've named year. First I tried it as a numeric type and
got 2,007 ib the form that I was using to feed data into the table.
Then tried character as the type and got 20,07 in the form.
How can I get the field just simply to show the year and only the
year?
Thanks, Thomas Tag: Test Tag: 235943
Help with buffered table
I have 2 tables: in one of them I have the parents of the childs of the 2nd
table. This means, I have a 1 to n relationship. Let's say, for key 'A' I
have 3 childs A1,A2,A3.
Table 1:
primary key A
primary key B
primary key C
Table 2:
candidate key A1
candidate key A2
candidate key A3
candidate key B1
The candidate key in table 2 is to ensure that there are no double A1 or A2
o A3 or B1.
Now I delete in table 2 the record A2 , and append from another table
another record A2. This works fine as long I have no table buffering.
But when I turn buffering on (in order to make it work within a
transaction), I get "uniqueness of index .... violated" when I issue the
APPEND command.
What can I do? I don't want to update the record A2, I want to delete it and
to append it.
Walter Tag: Test Tag: 235940
calling an external form from an executable
I have a standard executable that I want to add a customised form to without
compiling it into the executable.. This will be an external .SCX file.
This works fine by adding in
DO FORM MyForm.SCX as a menu option in the executable, ensuring that it does
not get compiled into the executable.
The problem occurs when MyForm.SCX calls another form in the Executable. It
fails, complaining that it can not find the form in the directory.
How can I get the external form to call a form inside the executable that is
calling it?
ie:
My.EXE ---------> MyForm.SCX (external form in the
directory) --------------------> My.SCX (inside My.EXE)
Cheers
David Younger Tag: Test Tag: 235931
Learn to develop internet applications
I am not a "techi", but I need to learn how to put my VFP application on the
internet for my customers to use. Can anyone point in the direction to learn
this?
--
TIA
Cowboy Tag: Test Tag: 235912
UPDATE - SQL very slow
Yesterday I had 2 tables: table 1 has 5 million records, table 2 has 2.5
million records, both in dbf format. Both tables are free tables,i.e. with
no dbc belongign to. The tables have no memo fields.
I want to update the first column of table 1 with the first column of table
2. So I did:
UPDATE table1 SET column1=table2.column1 FROM table2 ON table1.id=table2.id
The whole process vas very, very slow (more than half an hour on a Intel
D915 with Pentium4 3.00 GhZ), Then I thought it would be better to index
both tables on the field id which is an Integer. Performance was still the
same.
Then I did it the old way: a little program with SCANning table1 and SEEKing
table2, and REPLACEing and it was fast.
How come the UPDATE - SQL command is so slow?
Walter Tag: Test Tag: 235905
Printing .prg etc files
In Foxpro 2.0 there used to be a way to create a special report format
that could be used to print .prg files. If I remember correctly we
modified or created a new report file that could be used to print the
file with a header (etc) page numbers and the like. It seems that 9.0
has the report format included in the build and it is not possible to
do the substitution. Is there any way to enhanse the printout format
in VFP 9. If not does anyone agree this would be a nice enhancement
for an update. Tag: Test Tag: 235904