Import from Excel
I need to import a file from excel (office 2000) to fpw26. Yes I know get
with the program and upgrade. However the user is unable to do so at this
time. The excel file is in a day; time; name format with day being Tuesday,
October 7 and time being 24 hour clock and name being last, first. Append
from type xls results in time as .833 not 20:00
Any suggestions would be appreciated as usual. Thanks! Tag: MSCal.ocx problem with XP Tag: 182627
Fatal Error: Exception Code=C0000005
My worry about the compatability VFP7 and NTSC Windows are raised now. My client runs the
application in Chinese Windows XP and in a certain time this Fatal Error dialog box
appears.
This Fatal Error makes me so headache for many years and I don't know why it often
appears in Windows NT or XP. I don't know whether it can be appeared in Chinese version
of Windows.
However, it has no such problem in Windows 95 and Windows 98. Can anyone help me how to
solve it? Tag: MSCal.ocx problem with XP Tag: 182625
Text field justification in FRX report
This is a multi-part message in MIME format.
------=_NextPart_000_0010_01C38E95.3B7E9A90
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
All,
Is there a way to "justify" a text field? I.e., justified left and =
right margins? The basic properties are left, right and center, but =
nothing for full justification.
Thanks
John.
------=_NextPart_000_0010_01C38E95.3B7E9A90
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DVerdana size=3D2>All,</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2></FONT> </DIV>
<DIV><FONT face=3DVerdana size=3D2>Is there a way to "justify" a text =
field? =20
I.e., justified left and right margins? The basic properties are =
left,=20
right and center, but nothing for full justification.</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2></FONT> </DIV>
<DIV><FONT face=3DVerdana size=3D2>Thanks</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2>John.</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2></FONT> </DIV></BODY></HTML>
------=_NextPart_000_0010_01C38E95.3B7E9A90-- Tag: MSCal.ocx problem with XP Tag: 182622
XP Search tool
Anybody having problems getting accurate searches with XP
when searching for text in *.prg, *.sct files?
Windows 2000 was very accurate - XP is lousy at same
searches of the same network folders. XP SP1 supposedly
fixed a couple of problems in the search tool, but I
already have SP1. Tag: MSCal.ocx problem with XP Tag: 182607
Max index key length
Hi,
I'm trying to map the contents of the Windows registry to a table, which
isn't a problem in itself thanks to Rick Strahl and his registry class. The
problem I get is looking up a value in the table, which contains the full
registry key and value, e.g.
HKLM\SYSTEM\CurrentControlSet\Services\Dhcp\ImagePath. If I read the VFP
help correctly, these values can go a long way over the max index key length
of 240 bytes. Is there a good way to optimise a seek here without too much
linear search overhead?
My aim is to map the registry, make a change within Device Manager, then map
again and compare the two tables, so I know what's changed and can switch
states programatically from then on.
Alternately, does anyone know how to enable/disable all the USB ports on a
(remote) computer programatically?
Thanks
---
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.524 / Virus Database: 321 - Release Date: 06/10/2003 Tag: MSCal.ocx problem with XP Tag: 182606
VFP8 and .NET? What is a good resource for bringing myself up to speed?
I've been using foxpro for years, but I'm very unclear on what .NET can do
for me. Does anyone know of good books, websites, or articles that would be
helpful?
Thx,
Dan Tallent Tag: MSCal.ocx problem with XP Tag: 182604
GMT offset DateTime calculation
I have an imported VFP table of event start times where
the DateTime field is stored as GMT, including the offset
for Central Daylight Time or Central Standard Time.
What I need to do is to reconvert the DateTime back to
local time, including the offset for daylight savings time.
Any idea of a function that will automate this calculation
so that the return value will be correct for CDT or CST?
Here are a couple examples:
Input (GMT) Output Desired Zone Offset
10/15/2003 12:30 AM 10/14/2003 07:30 PM CDT -5 hr
11/05/2003 02:15 AM 11/04/2003 08:15 PM CST -6 hr
The trick lies in automatically calculating if the date
falls within Central Daylight Time (offset is -5 hours) or
Central Standard Time (offset is -6 hours). Dates will be
calculated on start times in multiple years - through 2006
right now.
Thanks! Tag: MSCal.ocx problem with XP Tag: 182601
VFP8 grid problems
I just applied SP1 and have noticed a problem - not sure if it existed
before SP1 however since I saw this immediately , I would assume this
problem is new.
I have a table that contains just under 9 million records , when i BROWSE
this table or bind it to a grid and drag the thumb down it gets to a point
where the thumb disappears. this seems to happen somewhere around the 5
millionth record. moving the invisible thumb back up a little brings it
back. This should not be an issue for production as I can't see ever
wanting to display this amount of data , but in the IDE I can see this being
a major hassle.
The problem of grids using the actual record count rather than the visible
record count ( ie. when a filter is a applied ) to determine the scroll bar
thumb position is still there and still as confusing / annoying / stupid
looking as ever. Tag: MSCal.ocx problem with XP Tag: 182599
VFP8 Connection Designer bug
FYI - the connection string field in the connection designer truncates
connection strings longer than 254 characters. I used the builder button
next to the connection string field, went through the DSN creation dialogs,
came back to the connection designer with what looked like a proper
connection string, clicked on the "verify connection" button and got
"connection succeeded".
But every time I tried to use the connection in a remote view, I kept
getting the following error:
==============
Program Error
Connectivity error: [Informix][Informix ODBC Driver][Informix]A syntax error
has occurred.
==============
Took me all morning to determine that my connection string was being
truncated - there are no errors thrown by the connection designer, the "test
connection" succeeds and the connection can even be saved.
Ugh.
--
William Fields
MCSD - Microsoft Visual FoxPro
MCP - Win2k Pro
US Bankruptcy Court
Phoenix, AZ
"While the complexity of this project is
several orders of magnitude less than
modeling heat flux in a fossil-fuel fired
electric utility plant using the Hottel Zone
technique, the context of each project
evolves in a remarkably similar fashion."
- Author Unknown Tag: MSCal.ocx problem with XP Tag: 182598
Report Field Q.
When writing report I have used a single field that I concatenate the
address on so it removes the blank lines and separates the line returns as
semi-colons, example:
c_Name;
c_address;
c_city+c_state+c_zip
My questions is why when seperating the same way with a combination of IIF
statements, why does that give you a syntax error and is there a way to over
come this? Do you use one long IIF and embed the semi-colons in the IIF
statement?
IIF(dr_apduelist.l_pmsign,'PM Signed Off '+DTOC(dr_apduelist.d_pmsign),'');
IIF(dr_apduelist.l_acsign,'AC Signed Off
'+DTOC(dr_apduelist.d_acsign),'ACCOUNTING MUST Sign Off Before Paid')
Jonathan Morningstar
----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Tag: MSCal.ocx problem with XP Tag: 182584
VFP8 and Combo boxes, drop down problem
We are currently using VFP6. One of our users is
experimenting with VFP8. We have a form with a drop down
box with name (60ch), address (30ch), city (25ch), state
(2ch). In VFP6, it runs fine when the user drops down the
combo box, resizes the column to fit on the screen.
In VFP8, it cuts off the first column so only the right-
most characters are displayed. It's running on a Win2k
machine. We tried changing fonts, recreating it, but it
still cuts it off.
Here are URLs to the screen shots:
Good VFP6: http://www.bittar.org/vfoxpro/VFP6CBO.jpg
Bad VFP8: http://www.bittar.org/vfoxpro/VFP8CBO.jpg
Not sure if we want to move to VFP8 yet, not sure what
else might be affected. Thanks for the help. Tag: MSCal.ocx problem with XP Tag: 182575
Application written in Vfp6.0sp5 when prints to a net printer hungs the Windows...
Application written in Vfp6.0sp5 when prints to any shared printer hangs the
Windows...(Only RESET to restart!!)
This happens in two different LANs and with different printers.
One LAN Peer-to-Peer with 3PCs under Win98SE and HPprintserver with HP g95
printer.
The other LAN Peer-to-Peer with 3PCs under WinME and HP3325 shared printer
connected locally to one station
No problem when the stations print from the same Vfp Aplication on local
printers!!
No problem when the stations print from other Applications (i.e. Word) on
shared printers!!
Any idea?
TIA
Nick Pofiris,
ErmisPliroforiki
Athens-Greece
www.ermis-pliroforiki.com.gr Tag: MSCal.ocx problem with XP Tag: 182574
VFPOLEDB and updateable recordset
I'm not able to create an updateable recordset using the VFPOLEDB provider.
If I use OLEDB for ODBC the recordset is updateable.
What am I doing wrong?
My code is like this:
oConn=CREATEOBJECT("ADODB.Connection")
oConn.ConnectionString = 'Provider=VFPOLEDB.1;Data
Source=M:\rml50\RML.DBC;Mode=ReadWrite;Password="";Collating
Sequence=NORDAN'
oConn.Mode = 3
oConn.Open
oRs = CREATEOBJECT("adodb.recordset")
oRs.CursorType = 3
oRs.LockType = 3
oRs.CursorLocation = 2
oRs.Open("select * from lager.dbf" , oConn ) Tag: MSCal.ocx problem with XP Tag: 182570
ı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: MSCal.ocx problem with XP 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: MSCal.ocx problem with XP 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: MSCal.ocx problem with XP 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: MSCal.ocx problem with XP 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: MSCal.ocx problem with XP 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: MSCal.ocx problem with XP 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: MSCal.ocx problem with XP 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: MSCal.ocx problem with XP 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: MSCal.ocx problem with XP 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: MSCal.ocx problem with XP 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: MSCal.ocx problem with XP 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: MSCal.ocx problem with XP 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: MSCal.ocx problem with XP 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: MSCal.ocx problem with XP 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: MSCal.ocx problem with XP 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: MSCal.ocx problem with XP 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: MSCal.ocx problem with XP 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: MSCal.ocx problem with XP Tag: 182476