ıs there any tool for developping and usın VFP6 on Windows Pocket Pc 2000
I am developping programs in VFP 6.00 and I am using
Windows 98, Windows 2000 , Windows XP. Now I want to
develop programs to use on WINDOWS POCKET PC 2000. Is
there any tool pack for this. Or do you have any
suggestions.
I have found that there is tool packs for Vissual Basic
but I couldnt find any news abaout Vissual FoxPro.
Thank you. Tag: VFPOLEDB and updateable recordset Tag: 182566
[Urgent] - VFP7R.DLL is invalid or damaged... and other problem
Sorry for repost this title. Although last time some experts suggested some good way to
solve the problem, I had tried before they suggested.
May I re-posting the problem:
I use InstallShield which is packed with VFP7 to build the distributed application. But
some clients reported that they encountered the error, "VFP7R.DLL is invalid or damaged".
Mostly the problem is existed in Windows 95. I would like to know on which situation this
error will be generated? Besides releasing the client that FoxPro Library files, which
measures I should take to avoid this error again?
I don't know whether the main problem is and it makes me so headache.
Additional infomation: My distributed application has the previous version but is
developed in VFP3. I don't know if the two set of library files (VFP3 and VFP7) are
violated. Some clients can run the application, but every time there is the message box
appeared at start up: "Covert 3.0 database to 6.0 format?". The answer becomes not make
sense. Tag: VFPOLEDB and updateable recordset Tag: 182551
how can i import text file with"|"as compart singnal to vfp 6.0
if u answer this question on time i will sincerely thanks
u .u can tell me the detail method or information to my
email adress or on this clipboard. Tag: VFPOLEDB and updateable recordset Tag: 182547
how can i import text file with"|"as compart singnal to vfp 6.0
if u answer this question on time i will sincerely thanks
u .u can tell me the detail method or information to my
email adress or on this clipboard. Tag: VFPOLEDB and updateable recordset Tag: 182546
Misc Win dll's etc
Is there a good place to find information regarding misc Win dll's and other
components? (i.e. ABC32.dll contains functions X, Y, Z. Here is how to use
them and the results you will get back.)
I have done some searches but rarely get a full reference. I am not a very
good searcher though.
The main reason I want this, is that I know some things that I do in many
lines of code have already been written and I just don't know where or how
to use them. (i.e. I wrote an entire "Getfile()" function in VB before I
learned there was a common dialog component that I could plug into my app.)
Hope this makes sense.
Thanks,
Scott Tag: VFPOLEDB and updateable recordset Tag: 182537
Other forms
I have a program that has multiple forms and I need to be able to change
information on form2 while the user is doing stuff on form1.
How do I reference form2? When I say form2.height=670, it gives me an
error.
"Object FORM2 not found."
Thanks,
Scott Tag: VFPOLEDB and updateable recordset Tag: 182536
Reboot computer programatically
Hi! I'm interested in finding a generic way to reboot a computer on demand.
For instance, I would like to restart the pc on exit of our application. I
have played around with the user32.dll, but found that this only applies to
WindowsNT. Does anyone know how to generically do this so that it's not OS
specific. Our customers work with 98,NT,2000, and XP. Thanks, in advance,
for your help!
Sarah Tag: VFPOLEDB and updateable recordset Tag: 182532
InstallShield Setup
I am getting ready to try to create the setup portion of my app in
InstallShield. Does the "Express" version that is packaged with VFP 7/8
automatically pick up all of the VFP runtime files?
If not, which files do I need to include in my package?
Thanks,
Scott Tag: VFPOLEDB and updateable recordset Tag: 182529
OS Version
Hello All,
When I use the OS() function I get "Windows 5.01" from some computers
and "Windows NT 5.01" for others.
What is the reason for this behavior and where I can find the different
values returned by the function for the different Windows versions?
Thanks in advance for any help or advice
Carlos Jones Tag: VFPOLEDB and updateable recordset Tag: 182526
Form reference on shutdown
Hi All,
I have a simple(?) question.
I have a commonlib.prg that keeps the Procedure "Cleanup"
(Releases variables and exits)
When my program starts executes the command:
On Shutdown Do Cleanup
Proc Cleanup
**a simpler version of the real procedure
Release All
* i need the active form reference here
Close databases
Clear Gets
Clear Read
Clear events
on error
on shutdown
Close All
quit
EndProc
My problem comes up when the user presses the outer 'X'
while a form (that uses a table) is opened. I get the
error "tblname is not found".
If the user closes the form by cmd_close and then exits by
outer 'X' everything is ok.
Maybe i need a less stupid user, but what can i do with
him??
Does anybody know how can i release the opened form before
Close databases command ???
Thanks in advance for your time.
Vassilis Aggelakos
apsdev at themelio dot gr Tag: VFPOLEDB and updateable recordset Tag: 182508
how to find the SMTP server
I would find the SMTP server installed on a computer (to send a mail using
blat.dll)
How to do this ? API ?
Thanks
--
Olivier (enlever les 3X pour la réponse) Tag: VFPOLEDB and updateable recordset Tag: 182497
Oleboundcontrol, help needed
I developed a payroll system with a photo of the employee.
At the office I could see the picture perfectly well, but
when I installed the softwared I see the icon associated
with the extension of the file (in this case jpg), instead
of the photo. I dissociate the extension, and re-associate
to MS-Paint, and now I see the Icon of paint.
The oleboundcontrol was link to a dbf with a general
field, i think i do not have to install anything. At
least, when i first developed i did not install anything.
When the user click on the button to select the photo, i
make an append general.... But it is not working properly.
Help needed!!!!
Any suggestion will be welcome.
Thanks
Mariano Tag: VFPOLEDB and updateable recordset Tag: 182492
MSChart or MSGraph?
I need a tool for doing charts in forms and in reports.
What's the difference between MSChart and MSGraph?
--
Andrea Mariottini Tag: VFPOLEDB and updateable recordset Tag: 182488
How can I clear the class or such codes lingering.
Scenario..
1. Open a project
2. Open an existing class or form
Which uses the class already available in the project.
Now close the form or whatever opened.
3. Try to open the associated .VCX as if it is table
USE myVcx.VCX from Command window or in PRG code
a. File already in Use error comes up.
b. Try to select the area where it is open. I am unable
to identify the work area. CLOSE TABLES ALL, SET CLASSLIB
TO .. nothing provides an answer.
c. At this stage close the project and reopen it. Again
try to open the VCX.. no success. SOmewhere the
associated thing is lingering.
d. From the command window CLEAR ALL gives a success. But
I cannot use 'CLEAR ALL', since the code is run from a
custom toolbar object which I have developed to help me
in custom development. I use 'Application.Projects'
objects collection to manipulate for my requirements. And
I need to open the project components as tables at times.
CLEAR ALL from command window will also clear the toolbar
object and I have to reinstate the toolbar again. SO I
achieve what I want by doing CLEAR ALL and starting the
toolbar everytime.
But it may be something silly I am missing and I want to
sort this out.
Thank you very much for anyone trying it out or providing
me the hint straightaway.
Ramani (Subramanian.G) Tag: VFPOLEDB and updateable recordset Tag: 182487
Setup Error 827
Rebuilt my setup files to use different ocx's. Rerun of the setup.exe gives
message - Object 10 Your setup files may be damaged. Try restarting the
Setup program from where you originally ran it.
Do I need to delete some other files first?
tnx, Howard Tag: VFPOLEDB and updateable recordset Tag: 182482
Setting Internet explorer back to Online (if offline)
Hi,
Thanks to David Frankenbach's help I can download programmatically a file
from internet.
A problem that I faced is that, if Internet Explorer was set to offline, the
connection to the specified URL could not be established.
Is there a way to test if Internet Explorer is Online / Offline and how can
I set it back to online?
Demetrios, Greece Tag: VFPOLEDB and updateable recordset Tag: 182480
mscomm32.ocx
Have an app that uses mscomm32.ocx to pass data back and forth to a serial
device. Works great (mscomm32 version is 6.0.81.69.)
Users occasionally install a different app which overwrites the msccomm ocx
with a later version which bombs my app. The later version is smaller; has
a version of 1.0.0.18; written by Crescent Division of Progress Software
Corp.
If I read it right, both require the same version of comcat.dll.
Suspect the solution is to replace mscomm32 with the original? or is the
1.0.0.18 version truly a replacement for version 6.0.81.69? Where do I go
to find info?
tnx, Howard Tag: VFPOLEDB and updateable recordset Tag: 182477
Importing Excel Data
Is there any way of importing only the raw data values from an Excel
spreadsheet, rather than the formatted displayed values?
My problem is when I APPEND FROM mydata.xls TYPE XL8, the numeric data,
displayed like $99,888.77 is truncated at the comma, so I only get 99 as the
imported value. Maybe forcing all columns to import as character strings
would help, but how to do that?
Any ideas? This is going to be a regular monthly process with the XLS files
coming from a third-party, so manually reformatting the worksheets is out of
the question. It's supposed to be automated, after all.
Thanks. Tag: VFPOLEDB and updateable recordset Tag: 182476
Visual FoxPro 8.0 Service Pack 1 Released
Visual FoxPro 8.0 Service Pack 1 Released
http://msdn.microsoft.com/vfoxpro/
Download Visual FoxPro 8.0 Service Pack 1 (SP1). Discover the many
enhancements and stability improvements designed to improve the reliability
and performance of Visual FoxPro 8.0.
News for October from VS Data Product Manager Ken Levy
http://msdn.microsoft.com/vfoxpro/letters/
Get the latest updates from Ken Levy on Visual FoxPro 8.0 Service Pack 1,
Visual FoxPro MVPs, the RSS XML news feed for the Visual FoxPro Developer
Center, and more.
Visual FoxPro Survey and Prize Drawing
http://www.researchhq.com/softdev/default.asp?name=site4&password=
Take the brief Visual FoxPro team survey by November 2, 2003 to be eligible
for a valuable prize. Even if you participated in 2002, we encourage you to
take this new survey and update Microsoft about your Visual FoxPro
preferences and experiences.
--
Ken Levy
VS Data Product Manager
Microsoft
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org, www.cindywinegarden.com Tag: VFPOLEDB and updateable recordset Tag: 182464
error in app setup on XP
I am using VPF6 SP5 and have a distributed app. I use the
Setup Wizard to create a network distribution set and then
burn a master using Adaptec CD creator 4.0b. When the app
is installed on an XP box it sometimes trows this error
during the instalation process:
The copmressed file 'D:\Setup1.CAB' cannot be decompressed
and may be corrupted.
This only happens on XP boxes. Any ideas as to the
problem would be appreciated.
Cory Bonallo
Developer Tag: VFPOLEDB and updateable recordset Tag: 182463
Visual FoxPro 8.0 Service Pack 1 Released
Visual FoxPro 8.0 Service Pack 1 Released http://msdn.microsoft.com/vfoxpro/
Download Visual FoxPro 8.0 Service Pack 1 (SP1). Discover the many
enhancements and stability improvements designed to improve the reliability
and performance of Visual FoxPro 8.0.
News for October from VS Data Product Manager Ken Levy
http://msdn.microsoft.com/vfoxpro/letters/
Get the latest updates from Ken Levy on Visual FoxPro 8.0 Service Pack 1,
Visual FoxPro MVPs, the RSS XML news feed for the Visual FoxPro Developer
Center, and more.
Visual FoxPro Survey and Prize Drawing
http://www.researchhq.com/softdev/default.asp?name=site4&password=
Take the brief Visual FoxPro team survey by November 2, 2003 to be eligible
for a valuable prize. Even if you participated in 2002, we encourage you to
take this new survey and update Microsoft about your Visual FoxPro
preferences and experiences.
Good Luck,
Chris Tag: VFPOLEDB and updateable recordset Tag: 182462
- How to simplify reINSERTion of a deleted record while avoiding primary key violation error?
If a record is marked for deletion and now needs to be reinserted in a table
with primary key (pk) constraint, then I would usually do the following:
SELECT mytable
SET ORDER TO mytag_pk
IF SEEK(new_pk) && record with primary key new_pk already exists
* do something to inform the user that this record is already there
IF DELETED() && record with this key already exists but it's been deleted
RECALL && undelete
BLANK && clear all previously stored information
REPLACE pk_field WITH new_pk && restore key value
ENDIF
ELSE
INSERT INTO mytable (pk_field) VALUE (new_pk)
ENDIF
Can IF DELETED() part be skipped somehow?
So that to insert a record, I would only check whether it is in the table,
and insert it if not (keeping in mind primary key validation):
* something like this would work for me
IF !SEEK(new_pk,'mytable','mytag_pk') && all green, good to insert (unless
deleted)
INSERT INTO mytable (pk_field) VALUE (new_pk)
ENDIF Tag: VFPOLEDB and updateable recordset Tag: 182459
VFP on XP
I have a successfully running program orginally written
in VFP 5.0 running on Windows 98 computers. When running
the program from XP, I get the error "file in use" during
this code"
select custnote
mcutempnote = "tempfile\"+sys(3)+".dbf"
copy structure to (mcutempnote)
select 0
use (mcutempnote) excl alias tempnote
I have determined that it is an issue of the file still
being open after the copy structure and trying to open.
If I place a wait between the copy and use it works
100%. I have this pattern of code for about 10 times and
the error will move around - not always the same file.
Sometimes it will work maybe 5 times in a row - sometimes
not.
I have done fresh installs of XP, VFP 5.0, 6.0 and 8.0
with the same error. On a network or locally - doesn't
matter. No XP computer, here at work or at home will run
the application 100%, but all Window 98/95 do.
Anyone else have this issue? Have a suggestion?
Thanks Tag: VFPOLEDB and updateable recordset Tag: 182457
Spellchecker for RTF text?
Hi Everyone,
We use Foxspell for our spellchecking, but it doesn't work with the MS RTF
(rich text format) control. Has anyone successfully used a spellchecker with
this control?
Any recommendations?
Thanks.
--
William Fields
MCSD - Microsoft Visual FoxPro
MCP - Win2k Pro
US Bankruptcy Court
Phoenix, AZ
The secret to creativity is knowing how to hide your sources.
- Albert Einstein Tag: VFPOLEDB and updateable recordset Tag: 182456
CursorAdapter InsertCmd problem
We are having problems with InsertCmd constructed by
CursorAdapter. The cursor adapter is defined be the code
below. When we look at cInsertCmd in BeforeInsert method,
it is missing CID field, causing an insert error, since
CID is the priamry key field.
Any ideas why?
Text to This.Alias NoShow
V_ACNTGROUPID
EndText
Text to This.SelectCmd NoShow
SELECT
CID,CREATEDATE,CREATEUSER,MODDATE,MODUSER,NCODE_ID,CGROUP_I
D,CNAME,CDESCRIPTION FROM F099 WHERE F099.CGROUP_ID = ?
VP_GROUP_ID ORDER BY F099.CNAME
EndText
Text to This.KeyFieldList NoShow
CID
EndText
Text to This.UpdateNameList NoShow
CID F099.CID,CREATEDATE F099.CREATEDATE,CREATEUSER
F099.CREATEUSER,MODDATE F099.MODDATE,MODUSER
F099.MODUSER,NCODE_ID F099.NCODE_ID,CGROUP_ID
F099.CGROUP_ID,CNAME F099.CNAME,CDESCRIPTION
F099.CDESCRIPTION
EndText
Text to This.UpdatableFieldList NoShow
CID,CREATEDATE,CREATEUSER,MODDATE,MODUSER,NCODE_ID,CGROUP_I
D,CNAME,CDESCRIPTION
EndText
Text to This.CursorSchema NoShow
CID C(12),CREATEDATE T,CREATEUSER C(15),MODDATE T,MODUSER C
(15),NCODE_ID N(10,0),CGROUP_ID C(10),CNAME C
(20),CDESCRIPTION C(40)
EndText
This.Tables = [F099] Tag: VFPOLEDB and updateable recordset Tag: 182449
Report Group Break Does Not Reset Group Variable
I have a report that has one grouping and one variable that counts the
records in each group and gets reset when the group changes. I am
using this variable in the page header - if the count is over a
certain amount then I print something, else print something else.
Problem is that the variable does not get reset until the next groups
page header has already printed giving me the prior groups 'condition'
on the next group. Thus the variable does not actually get reset
until the first detail record of the next group gets printed even
though the header info has already printed and is obviously the next
grouping. Is there any way to reset the variable before the page
header prints since the record pointer is already pointing the the
next group?
I tried using a UDF that ran in the group footer that reset the
variable - that worked except in one case. If you had exactly the
number of detail group lines to fill one page exactly the UDF still
ran for the second page and caused the page to be blank and print the
group header and detail - no amount of supression worked. I even
removed the call to the UDF and put the word "help" in the field and
it still printed the second blank page even though it suppressed the
printing of 'help'. I have to remove everything from the group footer
for it not to print the blank page.
There has got to be someway to easily resolve all this.
Rick Tag: VFPOLEDB and updateable recordset Tag: 182447
Conflict between VFP 6 and Windows XP/2000/2003
I have an application that is running from several workstations that are all
using Windows XP. The data is stored on their server which is running either
Windows 2000 Server or 2003 Server. The application was written in Visual
FoxPro 6.0 with SP 3. The problem the client is having is that the program
locks up quite frequently. Sometimes it gives them the error message "Error
reading file". We have several clients running this program successfully but
are using Windows 98 or 2000. Does anybody know if VFP 6 has a problem with
Windows XP or 2000/3 Server? Is there a more recent service patch I need or
should I upgrade to a newer VFP?
Thanks.
Doug Tag: VFPOLEDB and updateable recordset Tag: 182438
FoxPro 6 bizarre behavior
In the following code:
IF POPUP("MyPopup")
mTotal = CNTBAR("MyPopup")
FOR mCount = 1 TO mTotal
mText = PRMBAR("MyPopup", mCount)
ENDFOR
ENDIF
Why would line 5 (the PRMBAR function call) generate error
1612 - menu or menu item not defined? Tag: VFPOLEDB and updateable recordset Tag: 182435