Example of create index with ADOX
Hi,
I need an example of How to create an index of a fox table with ADOX,
using VFP8 OLEDB Provider.
Thank you,
Gonzalo Ferreyra
Córdoba, Argentina Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190798
OLEcontrol in a form and winsock
I am stuck again. The wincsock control was added, but it didn't connect
to remote host. Clicking the connect button didn't initiate any tcp
connection to my smtp server.
local owinsock
oform=createobject("myform")
oform.show(1)
define class myform as form
add object owinsock as myole with ;
protocol=0, ;
remotehost="192.168.2.1", ;
remoteport=25
add object text1 as textbox with top=0
add object command1 as commandbutton with ;
top=220, left=100, caption="\<connect"
procedure command1.click
thisform.caption=thisform.owinsock.localip
thisform.owinsock.connect
* should dispaly 6 for connecting, 7 for connected
thisform.text1.value=thisform.owinsock.state
thisform.owinsock.close
endproc
enddefine
define class myole as olecontrol
oleclass="MSWinsock.Winsock.1"
enddefine
--
.~. Might, Courage, Vision. In Linux We Trust.
/ v \ http://www.linux-sxs.org
/( _ )\ Linux 2.4.22-xfs
^ ^ 5:38pm up 22:44 1 user 0.95 0.92 Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190794
Putting Formatted Text into Email
I am using Word automation to open a document, edit the formatted text, and
somehow email it to a recipient list I have in a DBF.
I have created an Outlook.application item but can't figure out how to paste
the formatted text into it (there is no 'paste' method in the Outlook object
model). I also tried to figure out how to email directly from Word but
can't find a 'recipient' property to set.
Any help would be appreciated. --Mike Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190790
Passing parameter to an EXE
Hi
I want to pass a parameter to my VFP EXE such as running it like
MyApp.EXE /s /
How can I do this? I am using a .PRG as my "main". I tried using PARAMETER on the first line of my "main".PRG but I can't use the "/" switch. It gives me a "datatype mismatch".
Please help
ALC Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190788
Ken Levy's March 2004 Letter from the Editor
From http://msdn.microsoft.com/vfoxpro/letters/
March 2004 Letter from the Editor
There are many exciting announcements in this month's letter, so we'll dive
right into the details.
There is life on Europa... Visual FoxPro 9.0!
Announcing here formally (insert mental drum roll here)... the next version
of Visual FoxPro from Microsoft, code named Europa, will be named Visual
FoxPro 9.0. Visual FoxPro 9.0 is scheduled to be released during the second
half of this year. Announcing the official name of the next version of
Visual FoxPro now will allow upcoming articles, conferences, events, etc. to
freely use the name Visual FoxPro 9.0 instead of the Europa code name.
Oh, beta!
This coming June, Microsoft will release a public beta version of Visual
FoxPro 9.0 on msdn.com for anyone world-wide to download and install for
free!
Life is like a box of Visual FoxPro 9.0
We have recently started the process with the packaging and branding group
within Microsoft to create the product box for Visual FoxPro 9.0. It is very
likely that the screen shot used on the back of the Visual FoxPro 9.0 box
will be of the enhanced Report Writer. For the Visual FoxPro 8.0
back-of-the-box product highlight listing, I was unable to convince the team
that we should include a bullet item for the return of the Puzzle: ACTIVATE
WINDOW Puzzle
FoxTalk Reloaded
FoxTalk has been in existence for many years and is a great technical
resource for FoxPro developers. I was a contributing author and editor of
FoxTalk during the early days of GenScrnX and the new object-oriented
features of Visual FoxPro 3.0. The publishers of FoxTalk, Ragan
Communications (which acquired Pinnacle Publishing 15 months ago), have
recently been making some big decisions concerning FoxTalk.
After talking with the FoxTalk team at Ragan, we've come up with a plan to
make the publication better than ever. FoxTalk welcomes to the team David
Stevenson who is an experienced technical editor. Additionally, FoxTalk will
now include a monthly column submitted by the VFP team at Microsoft called
"Tips from the VFP Team", to give an insider's view of how to get the most
from VFP. Along with the editorial changes, Ragan has decided to offer a new
lower subscription rate! Ragan has confirmed with me that all of these
changes will begin with the May 2004 issue of the publication now called
FoxTalk 2.0. While Microsoft will be contributing monthly to the FoxTalk 2.0
publication, editor David Stevenson and the FoxTalk team will of course make
all of the decisions regarding content, editing, etc. For example, if the
VFP team suggests an article on the FoxPro "Puzzle", they may decline for
other content readers would prefer to see.
You should expect to see articles in FoxTalk 2.0 submitted by VFP team
members as well as the top FoxPro authors world-wide. Stay tuned for more
information about FoxTalk 2.0 and visit to subscribe at PinPub.com or renew
your subscription today to show your support for FoxTalk while obtaining
great upcoming Visual FoxPro content. The June issue of FoxTalk 2.0 will be
dedicated exclusively to articles and information on Visual FoxPro 9.0 to
complement the upcoming free public beta download on msdn.com. The May issue
of FoxTalk 2.0 will include more details from the editor on the plans for
exciting upcoming issues.
Hocus pocus, more CoDe Focus
David Stevenson, while previously working at EPS Software, worked with the
VFP team on the special CoDe Focus issue for Visual FoxPro 8.0. The VFP team
is currently working with Markus Egger at EPS Software on another great CoDe
Focus issue for Visual FoxPro 9.0. That special issue is scheduled to be
released and given to attendees at Advisor DevCon in Las Vegas, September
29, when we launch Visual FoxPro 9.0. The Visual FoxPro 8.0 issue of CoDe
Focus, as well as a new issue on the topic of Office 2003, can be found free
online at code-magazine.com/focus.
FoxPro books in your FoxToolbox.com
The online e-commerce store FoxToolbox.com, owned by DBX-Technologies, is a
great resource for obtaining Visual FoxPro, Visual Studio .NET 2003, and
MSDN Subscriptions as well as third party add-on products for Visual FoxPro.
Our friends at FoxToolbox.com, including Jim Eddins, are busy working on
plans to create, publish, and sell Visual FoxPro books on the upcoming
release of Visual FoxPro 9.0. David Stevenson, the new technical editor for
FoxTalk 2.0, is working part-time with the folks at DBX on their Visual
FoxPro book publishing plans.
The Eight FoxPro wonders of the world
Yet more exciting news in the FoxPro community is the fact there will be
eight conferences world-wide this year focusing on Visual FoxPro.
DevEssentials - June in Kansas City, MO
DevTeach - June in Montreal, Canada
Praha DevCon - June in Prague, Czech Republic
Advisor DevCon - September in Las Vegas, NV
SouthwestFox - October in Phoenix, AZ
Germany DevCon - November in Frankfurt, Germany
PortalFox Conference - November in La Coruna, Spain
OzFox - November in Sydney, Australia
Take one Tablet PC with VFP and call me in the morning
Later this month, we will be posting a new whitepaper on msdn.com called
Creating Tablet PC Applications with Microsoft Visual FoxPro written by Mike
Stewart of the VFP team. This new whitepaper will complement the article by
Markus Egger of EPS Software in the July 2003 issue of FoxPro Advisor
Magazine entitled Build Tablet PC Applications with Visual FoxPro. For more
information on Microsoft's strategy with Tablet PCs, refer to the ZDNet
article called Microsoft swallows tablet concept whole. In case you missed
it, Visual FoxPro was recently mentioned in an article on InternetNews.com
called Small Business Embraces the Tablet.
AccountMate of the Month
Last month in San Francisco, Softline AccountMate introduced a new interface
to its software line at Evolution (its reseller conference). I spoke at a
general session to almost 200 attendees, most of whom were FoxPro developers
who have not yet upgraded to Visual FoxPro 8.0 but who plan to do so soon
with the new release of AccountMate 6.5. It was stressed in AccountMate's
keynote presentation that Visual FoxPro 8.0 played a significant role in
AccountMate's new version 6.5 release. Most people (including the press) at
the conference were amazed what AccountMate has done in the user interface
using Visual FoxPro 8.0. The event made the news for Accounting Technology ,
which has 30,000 readers with 3 times that via pass along rate. AccountMate
and AccPac are now both owned by the same parent company, see the article
Best Strikes Again.
A case of FoxPro identity
We have several new case studies highlighting solutions based on Visual
FoxPro 8.0 submitted to the case study team at Microsoft which are currently
in the process of being posted on the Microsoft web site. These case studies
will be targeting non-developers such as IT managers, decision makers, and
executives. When the upcoming case studies on Visual FoxPro 8.0 are added to
the Microsoft case studies web site, we will also make sure that the proper
announcements go out about them in various Microsoft newsletters such as
MSDN Flash, just like what occurs for Visual Studio and other case studies
announced. Stay tuned for these new Visual FoxPro 8.0 case studies to be
posted, and when they are, we will include links to them on the Visual
FoxPro home page.
Don't get blogged down without weblogs
The new VS Data Team's WebBlog will have regular entries from VS Data group
manager Alan Griver, myself, and others on the VS Data team, which includes
the VFP team. The list of Microsoft employees and teams with their own
weblogs is growing weekly at blogs.msdn.com.
We encourage FoxPro developers to consider creating their own blog to
discuss FoxPro related topics. A great example of a FoxPro related weblog is
Craig Bernston's FoxBlog. For FoxPro developers adding .NET Framework
programming to their toolbox of knowledge, read Rick Strahl's WebLog. For
more generalized geek topics, check out master blog commander Robert
Scoble's weblog at Scobleizer. For more Visual FoxPro resources in general,
check out the listings on the Visual FoxPro Dev Center at Related
Communities for Visual FoxPro.
March to the beat of the FoxPro drum
Here are some calls to action for all FoxPro developers to consider. It is
important to not only say thanks to the vendors and sponsors within the
community, but to also be active to show your support. Upgrade to Visual
FoxPro 8.0 via product or MSDN at FoxtoolBox.com. Subscribe to BOTH FoxTalk
2.0 and FoxPro Advisor. Attend at least one Visual FoxPro conference this
year to learn about Visual FoxPro 9.0, make contacts with other Visual
FoxPro developers, and help continue to improve our great FoxPro community.
As Gordon Gecko says in the movie Wall Street, "The most valuable commodity
I know is information."
Same Fox time, same Fox channel
If you missed reading any of the letters from previous months, check them
out at the side bar links on this web page under Archive. In next month's
letter, we will have more Visual FoxPro whitepapers, new Visual FoxPro 8.0
sample downloads posted on msdn.com, and more juicy details on new features
coming in Visual FoxPro 9.0.
Ken Levy
VS Data Product Manager
Microsoft
E-mail: klevy@microsoft.com
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org www.cindywinegarden.com Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190787
Foxpro 2.6w under XP database access issues
I have been testing out using a legacy 2.6w app on XP boxes and have
been encountering "Not A Table/DBF" error messages which are temporary
and incorrect. It will happen when I am using a shared table in 2
different instances of foxpro at the same time. Does anyone have any
knowledge of a work around or fix to this?
Thanks,
Jonathan Kadish Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190784
Pass parm to form, form is "main" in project - doesn't work!
I have a simple form that receives two parameters in form.init. I run form
with parameters from within VFP, it works. I put form in project, set form
as "main", compile into exe. I run the exe, with the same parameters. I get
"no parameter statement is found". I'm thinking that you can't do this,
anyone else confirm or comment? Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190780
How to remove code page warning on tables from fox 2.6?
I use vfp8 and winxp.
On a regular basis I have to append records from a fox 2.6 table to a table
in a vfp8 database.
The code below works, but it gives me two windows the user have to deal
with. A 'table update warning' window and a 'select code page' window.
As far as I gather from previous postings the first window no one knows how
to get rid of, but what about the second?
Sincerely,
Jan Nordgreen
The code:
* oapp.cdatfolpat is the folder for the database and cfilepath is the fox
2.6 table
caux = oapp.cdatfolpat + 'newathlt.dbf'
COPY FILE (cfilepath) TO (caux)
IF INDBC('newathlt', 'TABLE') then
REMOVE TABLE 'newathlt'
endif
ADD TABLE 'newathlt'
* append the new records to the sdstud.dbf table
USE newathlt IN 0 EXCLUSIVE
SELECT sdstud
INSERT INTO sdstud (st_house, st_sex, st_studid, st_class, st_name) ;
SELECT st_house, st_sex, st_studid, st_class, st_name FROM newathlt Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190777
ReportDepot for .NET
Announcement: New version of ReportDepot for .NET released by Semurg Enterprise
Now ReportDepot for .NET provides complete code integration with the Visual FoxPro environment
ReportDepot for .NET can make your reporting solutions more flexible, since it allows you to output FRX reports to PDF, RTF, XML SpreadSheet, and HTML files
Take a look at how easy it is to incorporate ReportDepot for .NET in your VFP application
ReportDepot for .NET v. 04.02.00 is currently available fo
download at http://www.semurg.c Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190775
Need HELP...! I have problem with formset.
Hi, my problem is that i have a program and i want that the first windows to
be in a formset.
In this formset i've got my main windows. But i don't know why my windows
appears only if i set it to 'As top level form'. But the fact is that i
don't want this windows in 'As top level form' cause i'm not abble to open
another windows over.
frmLoading : As top level form
frmSetMain
--> frmMain : In top level form
--> frmAccess : As top level form
--> frmSetOther
--> frmOther : In top level form
--> frmForm2 : As top level form
--> frmForm3 : As top level form
From my program (program.prg) i call frmSetMain and frmSetMain open frmMain.
If i set frmMain to "As top level form" it's work but when i load my
frmAccess windows (to type an access code to acces my form) the windows
appears in back of the frmMain windows. And if i set frmMain to "In Top
Level form" the windows is loading but everything is close and i return to
foxpro windows.
I'm going to be crazy....
I hope that you will understand my problem..(sorry for my bad english).
thanks
maxime Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190774
Foxprow
I have several old programs running on Foxprow alongside some new ones
developed in VFP6. I use the patch so that Foxprow runs on faster
machines.
My query is this. My machine is getting old and runs at 450 mz using
Windows 98. If I upgrade to a new machine using Windows XP and running
at a much faster speed, is there a speed limit at which the Foxprow
patch stops being effective ? Will Windows XP run old foxprow programs ?
Thanks.
--
Tim Hobson Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190771
Union problem in view
I use vfp8 and winxp.
This parametric view I have used as a recordsource for a list.
CREATE VIEW v_Sdstud AS ;
SELECT ;
sdstud.st_name AS Athletes, ;
sdstud.st_studid ;
FROM ;
Sdstud ;
WHERE ;
sdstud.st_house = ?choicehouse ;
AND sdstud.st_sex = ?choicesex ;
AND sdstud.st_athlete = .T. ;
AND (Sdstud.st_class = ?choiceclass OR upper(?choiceclass) = 'OPEN') ;
order by ;
sdstud.st_name
It works fine. When I run the form, the list is filled the way it should
with name of students.
Now, on the top of the list of students I would like to add the record '(No
athlete)'.
I have tried this:
CREATE VIEW v_Sdstud AS ;
SELECT ;
sdstud.st_name as Athletes, ;
sdstud.st_studid ;
FROM ;
Sdstud ;
WHERE ;
sdstud.st_house = ?choicehouse ;
AND sdstud.st_sex = ?choicesex ;
AND sdstud.st_athlete = .T. ;
AND (Sdstud.st_class = ?choiceclass OR upper(?choiceclass) = 'OPEN') ;
union ;
SELECT ;
'(No athlete)' as Athletes, ;
0 as st_studid ;
from sdstud ;
order by ;
1
When I browse the query from the data environment and feed it the parameters
it works fine. However, when the form is running it gives me an empty list.
What am I doing wrong?
Is there a better way of doing this?
Sincerely,
Jan Nordgreen Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190765
use run in xp?
can the FVP6 command RUN (used in a PRG) be used in Windows XP? Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190763
file is in use and used('tablename')
I use vfp8 and winxp.
When I run this code something strange happens.
IF USED('sdstud') then
USE IN 'sdstud'
endif
USE sdstud IN 0 exclusive && line 47
In line 47 I get 'file is in use' error message.
How come, when I closed it in the instructions above line 47?
When I run the code a step at a time, used('sdstud') is false so it goes
straight to line 47 and reports 'file is in use'.
Can anyone help me?
Sincerely,
Jan Nordgreen Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190754
Open DB Exclusively
I need to open the Database exclusively but I don't want to get an error
if someone else has the DB opened and has it shared. Is there a way to find
out if the Database is currently opened by anyone else?
VFP8 sp1 Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190743
Triggers
Hi
Q1. I have a small problem, actually I am looking for something we use in SQL server
Inserted.CustName or Deleted.CustNam
Q2. I have a table A. I have some triggers in this to update table
I am flocking table A before updation. Do I need to flock table B in the trigger ?
If I flock table B in the trigger, will the locking and unlocking will happen fo
every record ? because my updation is 'update where <condition>' for more that on
record. Will it execute the trigger and lock table B for all the record
separatly ? That is if the update condition is for 10 records, it will update
record in A and execute the trigger then update the 2nd record and execute th
trigger etc
Mike Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190740
Function argument value ... is invalid when buiding EXE
In VFP 8.0 (sp 1 installed), when i build the EXE of a project containing an
OLE public class, i get the following error message
"Function argument value, type, or count is invalid"
This error is displayed when the status bar has shown : "Creating type
library & registering Com component".
Any help will be appreciated,
Kind regards,
Guy Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190735
Future support for Visual Foxpro
Hi
Our company has a product written in Visual Foxpro. We have a potential customer who is worried about purchasing our product because they say "we have concerns that FoxPro will not be supported by Microsoft in a few years"
Can anyone suggest any papers and/or statements which I could show them to reassure them
Thanks in advance for any help
Pauline Pearc Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190732
to GURUs
Not exactly a VFP question
Is there a firing event that can be used
when someone opens a folder?
I would like to make an app that would start
when the user enters into a folder, in order, let us say,
to remind you something.
Demetrios, Greece Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190729
how to specify the directory where I want to get the file
Hi,
I have used GetFile('txt') to get file using browsing table. However, I
don't know how to specify the directory where I want to get the file.
Please Help.
Thanks a lot,
Ray Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190727
SQLProcedures equivalent for FoxPro
I'm writing a C++ tool that will list among other things, the stored
procedures in FoxPro dbc file. Is there an ODBC API for that? Has
anyone done that? SQLProcedures is not supported in FoxPro.
--Kobby Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190723
Newbie question
I am fairly new to programming/foxpro. I am rewriting an existing dos application using vfp 8. The application has the ability to setup new company files. Upon creating these company files, it creates a folder in the application directory (for example if I setup company 54, a folder called "Data54" will be created with all the dbf files in that folder). My question is, how can I make this happen? I want to create a folder for a company to work out of. Any help at all would be much, much appreciated!! Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190719
Microsoft MAPI Message control...
Hi, did someone knows how i can add attachment files (JPG, AVI etc...) to a
message with Microsoft MAPI Message Control ?
I try this but it dosn't work:
IF !this.parent.signon() && Use the custom method
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="My message ....bla bla bla"
SET STEP ON
this.parent.OleMMess.msgnotetext=lcMessageText
this.parent.OleMMess.msgsubject="subject.....bla bla bla"
this.parent.OleMMess.attachmentIndex=1
this.parent.OleMMess.attachmentName ="dsc0001.jpg"
this.parent.OleMMess.attachmentPathName="c:\temp\dsc0001.jpg"
this.parent.OleMMess.send(1)
IF this.parent.logsession
this.parent.OleMSess.signoff
ENDIF && Session Handle test
ENDIF
Thanks for your help ! Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190715
Running Fox Exe's from a local network, VFP5.0 vs VFP6 - 8
I have several small office applications written in Foxpro. Years ago I bought some of them up from Foxpro 2.6 & FPW 3.x into the what was then the newest 'Foxpro', 5.x, and then wrote a few more apps. When later on 6.0 had been out for a while I tried to move up to that version. To that point all I had to do when distributing an application was to put the exe, two Dlls, DBFs and a few other files in a directory on the local network protected by the appropriate NT security. Then put an shortcut on the users desktop pointing that exe. With lots of changes in our office responsibilties this is easy to connect new workstations to these apps. With 6.0 that all changed to have to setup the apps on each computer even though the exe and dbfs could be shared on the network. This is what I had to do with VB apps (which is one among other reasons I didn't use VB alot).
I tried to putting all the files the 6.0 setup wizard was putting on each computer on the network in the exe's directory but it didn't work. I guess this is because of the files not being registered properly in the setup. I was hoping that Foxpro would just look for these files in that directory first without checking the registry
The upshot of all this is that all the apps are still on 5.x . I suppose that I could set up one VFP 6.0 app on each workstation and then as long as the rest of the apps used the same componets they would not require an individual setup.
Before I go that route I'm wondering if there is a way to run 6.0 ( or actually I have 7.0 now) the way that I ran the 5.x apps on the network ?? Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190712
ADIR() Question
I have a directory with the file extensions of .LOG and .LOG_LIX. When I do
a
numberof = adir(testing,'*.log').
I get all the files, but what I want is just the files with the LOG
extension and not the ones with LOG_LIX. Is there something that I am
missing with the ADIR() command?
Any help is grateful,
Dale Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190709
Multiple detail band
Which of the third party report generator offering multiple detail band that
works well with VFP8?
sp Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190701
Intellisense manager
Can somebody help me
How can I switch off automaticly the Intellisense Manager
My config.fpw file contains the following line
_VFP.EditorOptions = "
But -sorry- this does not work. Every time when I start to use VFP8 I have to switch off Intellisense manager by hand
Many thanks
Sandor Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190691
Uploading Large files using XMLHTTP
Hi All,
I am using XMLHTTP object in VFP to upload files using VFP and having the
problem of string too long to fit when uploading files more than 16MB. The
error occurs when I try to concatenate the FILETOSTR data with the header
info. Temporarily I worked around it by using a memo field. But then it
gives the same error in the XMLHTTPObject.Send method. Any body knows any
workarounds?
* This is a pseudo code only
x = FILETOSTR(FileToUpload)
BuildPostData(x) && Builds the Header information etc
XMLHTTPObject.Send(x)
If the above cannot be fixed any other fox pro code that may work? I recall
Rick had a wwHTTP class, will it support files more than 16 MB? Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190689
sharing of data
HI i m using dos base foxpro i wnt to know wherether i can share data among few computers
if can ah how to do it Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190682
VFP email client
Hi,
I asked recently about accessing port 110 using VFP to be able to parse
email in a POP3 account before it was downloaded to a client. I got some
great help on the Winsock control which did the job well. Couple of
questions:
Any ideas how to cleanly disconnect? The POP3 server keeps the connection
open for a period of time if I use the Winsock Close() method, and VFP hangs
for a similar period of time if I issue a POP3 "QUIT" command. This is just
annoying, not important.
Now I can access POP3, and can send email in various ways (using BLAT for
this, but CDO and wwipstuff are other SMTP based options), I wanted to see
if I could write a basic email client using VFP. All works well so far
unless I want to reply to an HTML email. In OE or Outlook, you click "Reply"
and you can type your reply into what looks like an edit box, but with the
original HTML nicely rendered below. Can this be done in VFP? I can display
the original HTML using the Web Browser control, but I'm a bit stuck on
creating an interactively editable browser object.
I'm only doing this as an experiment. It's non-production, but would welcome
any help.
Neil Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190672
What is the SYS(1104)?
What is the SYS(1104)? I found no docs about it! (VFP 6.0sp5)
I test also the SYS(1101), SYS(1102), SYS(1103).
They also return numeric values, but no docs about these...
Have a nice day (or night),
Nick Pofiris,
ErmisPliroforiki
Athens-Greece
www.ermis-pliroforiki.com.gr Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190663
Subreport w/ External Foxpro DBF
I'm having a problem with a report.
I have a problem getting my subreport linked to my main report. I have a
primary file used for the main report, and a second (stand alone) file for
the subreport.
The subreport is not showing any information from the second file. I'm at a
loss, and could use some advise. I have included some details below.
I have a file that includes multiple fields that are used in the main
report:
customer name, customer number, job number, company number, and equipment
id.
I have a second file which is a list of equipment used on a given job:
(subreport)
job number, company number, equipment id, serial number, model #
These files are not joined in the report, I wish to use subreport links to
join the two together.
The second file will list the detail info for a given piece of equipment and
for a given job. I setup the links as follows:
?Pm-Customer_history.ncompany = cs_equip.nCompany
?Pm-Customer_history.nsite_equipid = cs_equip.nsite_equipID
?Pm-Customer_history.njobnumber = cs_equip.njobnumer
The selection formula (record) on the subreport was left as it was created
by the SubReport Links window.
--------------------------------
Thx in advance,
Dan Tallent Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190658
Unique Identifier for .MNX file
I need to grant access to a particular menu option depending on which user has logged in. I am planning to create a DBF file which will contain the menu options that accessible by each userid. Then at the time of running the MPR file, I can modify the SKIP FOR clause if the userid has access to that menu or not
To accomplish this task, I need to know if there is a unique identifier in the MNX file that is created by Menu Builder. I want to tie in the userid with the key for MNX file for the purpose of lookup. I browsed the MNX file but I am a little confused about the records in that file. For some reason it has two records for every menu option that I created. Can someone throw some more light on the structure and contents of MNX file and suggest how best I can do what I want to do
Thanks a lot....
Subhash. Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190655
Excell Automation
Hi ther
I am trying to use the insert command from foxpro but keep getting an error, the vb syntax is
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromRightOrBelo
it's the shift things such as xldown or before on other commands that i am struggling with
foxpro intelisence gives you insert([shit as variant] ....etc I'm not sure how to use this
thank
Ke Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190654
pls help me....
i need to finish my database project using the visual fox pro but our professor told us to use the version 6.0. my problem is our professor didnt told us on how to link two forms. we dont know the syntax... please help us to finish our project Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190648
Insert and update function!
Hi All
I have just created two database files with master and detail relationship. For now I'm getting trouble with writing "insert and save" function. Firstly I used VFP6.0 built in master detail relationship to create a form. It works fine.
My first question: Can I get into their built in "Insert" and "Update" function for my little modification purpose
Or if not, I wrote "Insert" and "save" by myself. As I clicked them the first time, it works fine. But after click "save" and it jumped back to "insert" mode, the old data were displayed on the screen, instead of creating a new record, or even my code was included "append blank"
Now I found that the problems were from "the cursor were still pointed at the last record after I hit "save and insert". What exactly should be the problem of my coding
Please help
Sam. Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190646
How to display integer value when there is no decimal part?
I am using vfp8 and winxp.
I have a grid column with recordsource a numeric field with width 5 and
decimal 2 in a table.
The value is calculated, never entered manually.
When the value is 12.25 I want 12.25 displayed, but when the value is 12.00
I want 12 displayed. That is, I want only the integer value to show when
there are no decimals.
What is the easy way to do this?
Regards,
Jan Nordgreen Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190645
The use of "Activate PopUp .... NoWait"
How can I use the option NoWait in a popup menu?
While typing in an edit box and after each typed letter a popup appears and
remains there.
I have to use NoWait option in order to be able to continue typing.
The same popup is activated if I right click on the textbox.
If I click an item on the popup that is activated with the NoWait option,
Bar() returns nothing.
Demetrios, Greece Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190644
the winsock control
I tried this and failed with "class mywinsock not found" at the
createobject() line. Can we subclass an ActiveX control?
oWinsock=createobject("mywinsock")
...
define window mywinsock as MSWinsock.Winsock.1
procedure DataArrival
lparameter m.length
? m.length
endproc
endefine
--
.~. Might, Courage, Vision. In Linux We Trust.
/ v \ http://www.linux-sxs.org
/( _ )\ Linux 2.4.22-xfs
^ ^ 8:26pm up 1 day 10:53 load average: 1.00 1.00 1.00 Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190641
erro 1113
Dear Group,
I have a free table that can not be openned from my pc (error : 1113 -->
file is not opened), it can be opened in other pc
we using win98 so no security is concerned
the only diffirent between mine and theirs is that my pc got sp5, they don't
(we are using vfp6)
Any way, i have tried the following:
go to diff pc
use the dbf
copy stru exte to test.dbf
copy that test.dbf to my pc
use test
sele test
copy to array myarray
create table mytable from array myarray
I got error 9: data type mismatch
So how can i fix this problem? The table has quite a lot of fields (240) so
i don't really want to manually create it by hand (i wasn't the one who
created it)
TIA
Peter Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190634
MessageBox function
Hi to all
Can I position the MessageBox function instead of it appearing at the center of the screen
ALC Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190630
toolbar and form
Other than creating a formset, is there a way to associate a toolbar
with a form visually? If there is no visual way, must I do it
programmatically?
I am using VFP 6.
--
.~. Might, Courage, Vision. In Linux We Trust.
/ v \ http://www.linux-sxs.org
/( _ )\ Linux 2.4.22-xfs
^ ^ 10:32am up 1 day 59 min load average: 1.05 0.99 0.99 Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190623
New offline FoxPro Wiki is available
For those of you that need access to the content of the FoxPro Wiki when you
don't have internet connection there is a new updated snapshot of the Wiki
available for download.
Check out this topic for more information:
http://fox.wikis.com/wc.dll?Wiki~WikiOfflineMirrorSites
And if you don't happen to know what a cool resource the Wiki is check it
out here: http://fox.wikis.com/
--
df - Microsoft MVP FoxPro http://www.geocities.com/df_foxpro Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190621
How to get a value back from a sql server udf...
I can get the return value of a SQL stored procedure back like so (in T-SQL)
declare @rc int
exec @rc = dupint 10
print @rc -- 20
define proc dupint @i int
as
return @i + @i
How can I do this using SQL pass through:
?sqlexec(1, "exec ?i = dupint 20")
Also, how do I get the return value from SQL user defined function:
?sqlexec(1, "exec ?i = dbo.dupint(20)")
Any help is appreciated.
Jacobus Terhorst Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190618
number to RGB ?
Hi, I know that we can convert an RGB value to a number, but is this
possible to do the inverse...
ex: ? RGB(255,255,255) = 16777215
but i want to have the 3 RGB number of 16777215
Thanks Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190615
treeview in a dbc R.I.
Hello,
I try to use a treeview (for its non-visual properties) in a R.I. stored
procedure of a dbc.
Is it possible ?
How can I create an instance of this object in a RI ?
Michel (in France) Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190599
report with a jpg or gif file
How can I personalize a clients reports to include there logo on it?
Is it necessary that I build the application with there logo included in the
other files or can I just use a generic file called logo.jpg and logo.gif
then simply have them copy there logo to the installation folder and rename
it logo.jpg or logo.gif?
R Gallo
OGES Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190592
Sending files to a web site folder
If my clients have DSL lines. Is there a way to send files directly to a web
folder using Visual Foxpro6 and creating a form to do so. At the same time
can they also download files from a web site through a form.
R Gallo Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190590
Internal consistency error - during appending
When i used "append from", displayed "Internal consistency error". Two tables are same but i can't "append", why
Somebody help me ? Tag: Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Tag: 190586