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: Current Issues Article Archive 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: Current Issues Article Archive 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: Current Issues Article Archive 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: Current Issues Article Archive 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: Current Issues Article Archive 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: Current Issues Article Archive 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: Current Issues Article Archive 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: Current Issues Article Archive 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: Current Issues Article Archive 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: Current Issues Article Archive 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: Current Issues Article Archive 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: Current Issues Article Archive 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: Current Issues Article Archive 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: Current Issues Article Archive 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: Current Issues Article Archive 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: Current Issues Article Archive 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: Current Issues Article Archive 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: Current Issues Article Archive 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: Current Issues Article Archive 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: Current Issues Article Archive 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: Current Issues Article Archive 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: Current Issues Article Archive 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: Current Issues Article Archive 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: Current Issues Article Archive 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 rath