WS - Dataset
Hi,
converting Dataset returned from Web service into cursor i get MEMO field
instaed of string.
Can i correct this?
Thanks,
Shalva Tag: Watch these critical update Tag: 182707
Printer emulations to correct paper tray
I'd like to be able to specify which paper tray on a laser
printer to send the print job to. How is this done? Is
it related to SET PRINTER TO with more code?
Thanks much! Tag: Watch these critical update Tag: 182701
Formatting dates in FRX report.
This is a multi-part message in MIME format.
------=_NextPart_000_000C_01C38FF3.DA63E2F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
How can I take this date "10/10/2003" and format to this "10-Oct-2003?"
Thanks for the help.
John
------=_NextPart_000_000C_01C38FF3.DA63E2F0
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>How can I take this date "10/10/2003" =
and format=20
to this "10-Oct-2003?"</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2></FONT> </DIV>
<DIV><FONT face=3DVerdana size=3D2>Thanks for the help.</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2>John</FONT></DIV></BODY></HTML>
------=_NextPart_000_000C_01C38FF3.DA63E2F0-- Tag: Watch these critical update Tag: 182693
How to change Path of the Base Classes ?
Unfortunateley have almost completed a project with Base Classes - Though
their Name is Same - from an other Folder instead of from the Project
Folder.
Need your help to change the path of the Class Library from the existing
Paths to some other Path for the Form Classes along with all the Controls on
it ?
Tanveer H. Malik
Cell: +923334227099 Tag: Watch these critical update Tag: 182681
Sorting by a specific column in Outlook from VFP
Hello, does any one how to sort on a specific column (i.e.
Subject, from, to etc) from VFP.
Thank you Tag: Watch these critical update Tag: 182680
Contemplating the unnatural
I am considering something so unusual that I feel bound to solicit other
opinions. I am building a webapp which will (hopefully) have many different
clients. Instead of, as usual, have a client id column as a key field in most
tables I'm thinking of a Windows folder named after the client id (which may be
numeric or alpha).
My reason for doing so is that, if a table becomes corrupted or I need to pack
tables, doing so will only affect one client at a time rather than all. This is
especially important because the system will need to be available all the time
(although, for each client, there might be a "no service" time, typically at the
client's local midnight time.
tia
regards - anthony shipley
look, ma - no .sig Tag: Watch these critical update Tag: 182678
ADO and OLD DB driver for Fox Pro 8
I am trying to insert a record with a fields that is of a
DBTimeStamp type through VB 6 ADO interface using OLE DB
DRiver for Fox Pro 8. However, only the date part is
inserted and the time part is 00:00:00.
CODE:
=====================
cmd.CommandText = "INSERT INTO EXCHANGELIST
(PRODUCTID, EXCHVALUE, UNIT, SYNCDT) VALUES(?,?,?,?)"
cmd.CommandType = adCmdText
cmd.CommandTimeout = 60
param.Type = adDBTimeStamp
param.Direction = adParamInput
param.Value = eff_date_in
cmd.Parameters.Append param
cmd.Execute (records)
==================================
- eff_date_in os of a type date
Is there any way to insert a datetime value into the Fox
Pro database from VB6 ? Tag: Watch these critical update Tag: 182674
Using enter key on a text box
Is there a way to allow the user to press enter in a text box, have it not
exit the box, and record the crlf into the field? The field is a memo field
and part of a grid. I know the obvious thing to do is make it an editbox,
but then it only shows 'memo' and not the actual data of the field.
So, I guess I'm asking is if there is a way to allow enter keys with a text
box or if there is a way to use an edit box and have it display the contents
of the field?
Thanks for the help.
Boyd Tag: Watch these critical update Tag: 182673
Winsock error codes don't match documentation
I am using the winsock control in an application. The error event will fire
with an error number, but the error number (12 or 232) does not match the
documentation on the error codes. Is this something to do with numeric types
from winsock to foxpro? I have searched everywhere and I can't find anything
on why they would be different, I did find some issues to do with the
function declaration if it is being run from vb.
Any ideas? Tag: Watch these critical update Tag: 182672
picture viewer
Hi sly foxes
Just wondering if there is a jpg viewer which can zoom by
clicking and dragging on a section of the picture and
doesn't end up distorted or fuzzy.
Paint has the almost similar characteristics if you have a
picture of a map with numbers on it and you crop a certain
section of the map and then stretch that section, it ends
up distorted.
Ultimately just click and drag a section of map and it
zooms at that selected section.
If there is an activeX component which does this would be
xcellent but any advice would be appreciative.
Thanks in advance
Patrick
Running FP 7 and XP Tag: Watch these critical update Tag: 182670
Do VFP ver 7.xx or 8.xx have ODBC drivers?
I am trying to find the latest VFP ODBC driver. The
latest I have is ver 6.1xxxxx
Was there a ver 7 ODBC driver?
Was there a ver 8 ODBC driver?
Thanks in advance Tag: Watch these critical update Tag: 182665
VFPOLEDB - what is working?
Now I've found out that the maxrecords property doesn't work with VFPOLEDB.
Where can I find documentation on what is working/not working with VFPOLEDB? Tag: Watch these critical update Tag: 182663
Exception: c0000006
I ran into this the other day, and could not find much on it. I happens when
a timer fires, and the only thing of interest in the timer code is a
reccount() that might be occurring when a user is adding/editing a table.
Anyone have any info on this? I've not seen a c0000006 before, and I think
it's rather rare. Tag: Watch these critical update Tag: 182655
Automation Word 97 & Word 2000
I have been using the following code to open up and exiting file that
has been working OK when the user has Word 2000 on his computer. One
user is using Word 97 and although the code starts up Word 97 it comes
up with a blank gray screen and does not load the file. Is there a
different way to call Word 97 to open an existing file??
Thanks for any help.
Tony
BINGO = M.C_FILE_NUM+'.DOC' ** Name of file to open is in this
field
CD REPORTS
GOODAPP = .T.
ON ERROR GOODAPP = .F.
oWORD = GetObject("&BINGO")
IF GOODAPP = .T.
WITH oWORD
.WindowState = 1
.APPLICATION.VISIBLE = .T.
ENDWITH
ELSE
WAIT 'COULD NOT OPEN YOUR WORD APPLICATION' WINDOW
ENDIF
CD .. Tag: Watch these critical update Tag: 182649
Easy Question about variables
Hello, I am returning to Foxpro after a 3 year hiatus(and
even before that I only used it part of the time). Anyway
I have a question that should be really simple to answer,
I just can't figure it out.
How do I declare a variable that will stay in scope
through out the life of a form(ie I want to set it in the
init procedure and check it in other procedures like on a
button click and in the release procedure.
Please help! Using VFP7.0
Thanks
Brian Tag: Watch these critical update Tag: 182640
InstallShield Express (2)
I am creating the setup with InstallShield Express.
In "Configure the Target System\Registry" I didn't select
any of HKEY values.
The problem is :
1. when the user is logged-on as administrator the
installation
finished correctly and he can work with application as
administrator, BUT NOT as ordinary user. The Win2000 or
WinNT report a message :
"Cannot locate the Microsoft Visual FoxPro support
library"
2. if the user is logged-on as user, the installation
crashes
with message that setup could not write to registry
Q: what action in ISE have I done that the user run setup
as
administrator and all other folks will work with
application
TIA
Mitja Tag: Watch these critical update Tag: 182638
MSCal.ocx problem with XP
Is anyone else out there having problems with the MSCal.ocx control with
VFP6.0 (SP5), if you run a form with this control I get a "OLE exception
error: Exception code c0000005. OLE object may be corrupt..." at the point
where we try and set the year property.
Just in the GUI, right click on this control, calendar properties, get a OLE
error and booted out of VFP. Sounds like it really is corrupt, how do I get
a clean copy installed.
Thanks in advance Grant Tag: Watch these critical update Tag: 182629
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: Watch these critical update 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: Watch these critical update 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: Watch these critical update 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: Watch these critical update 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: Watch these critical update 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: Watch these critical update 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: Watch these critical update 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: Watch these critical update 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: Watch these critical update 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: Watch these critical update 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: Watch these critical update 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: Watch these critical update Tag: 182574