Need help on CURSORTOXML method
Hi
I have used the CURSORTOXML method to convert the cursor to XML file.
However all the tags are in lower case.
Anyone knows how to set the tags to UPPER CASE?
Appreciate your help.
Tham Tag: Re: Tag: 225936
Appending from file delimiter
I have a flat file with delimiter with char ~
it has date field also with format as dd-mmm-yyyy
i changed the date setting as short or long in vfp
in regional setting of windows control panel also i have kept the setting as
dd-mmm-yyyy .
But while appending the data i am getting the blank field in the all the
date fileds ,
Pleae let us help.
Bankim Tag: Re: Tag: 225935
Can I get some help with VFP9 in Installshield?
I have an app - using vfp9 - and Installshield 5. I need to have
installshield install some barcode fonts on the users system. Anyone faced
this problem before.
My apologies. I can't seem to get any help from Installshield and I know it
ships with VFP products. Been using foxpro since it was dbase IV.
I have installshield put the fonts in the c:\windows\fonts directory but my
app does not see them.
Any help would be greatly appreciated.
Thanks Tag: Re: Tag: 225933
Need Help with Search
Hi everyone. I have a search menu that works if I select "ALL", with
tells me "ALIAS NOT FOUND" if I try to search by typing in the first
few letters of the patient's last name. Here is the code I am using:
#DEFINE DELKEY 127
LPARAMETERS nKeyCode, nShiftAltCtrl
LOCAL cDisplayValue
IF nKeyCode = DELKEY
cDisplayValue = ALLTRIM(THIS.DisplayValue)
IF LEN(m.cDisplayValue)=1
cDisplayValue = ""
ELSE
cDisplayValue = LEFT(cDisplayValue,LEN(cDisplayValue)-1)
ENDIF
ELSE
cDisplayValue = ALLTRIM(THIS.DisplayValue)+CHR(nKeyCode)
ENDIF
THISFORM.LockScreen = .T.
DO CASE
CASE EMPTY(m.cDisplayValue)
THISFORM.grdcust.recordsource = " "
CASE THIS.Value = "(All)"
SELECT l_name AS lname,* FROM patients;
INTO CURSOR Custs
thisform.grdcust.recordsource = "Custs"
OTHERWISE
SELECT l_name AS lname,* FROM patients ;
WHERE UPPER(ALLTRIM(l_name.patients)) = UPPER(m.cDisplayValue);
INTO CURSOR Custs
thisform.grdcust.recordsource = "Custs"
ENDCASE
THISFORM.ResetCombos(THIS)
THISFORM.LockScreen = .F.
_____________________________________________________________________________
In my other search field, I have the search set up so that all of the
patients last name's appear in the drop down menu in alphabetical
order, but if I select a last name to display, I get the error "ALIAS
L_NAME IS NOT FOUND". Here is the code I am using here:
LOCAL cDisplayValue
THISFORM.LockScreen = .T.
IF THIS.Value = "(All)"
SELECT l_name AS Location,* FROM patients INTO CURSOR pats ORDER BY
l_name
thisform.grdcust.recordsource = "pats"
ELSE
SELECT l_name AS Location,* FROM patients ;
WHERE UPPER(ALLTRIM(l_name.patients)) = UPPER(ALLTRIM(THIS.Value));
INTO CURSOR pats
thisform.grdcust.recordsource = "pats"
ENDIF
THISFORM.ResetCombos(THIS)
THISFORM.LockScreen = .F.
------------------------------------------------------------------------------------------------------------------------------------
I have both of these codes in the Interactive Change of each combobox.
Can someone please point me in the right direction?
Thanks in advance.
Arvin Tag: Re: Tag: 225919
Change file reference on OLE object
Hi,
I have an Excel file that I'm displaying in a VFP form using an OLE control,
linking it to a local file.
Problem is, sometimes that local file gets locked up, and I can't overwrite
it with new data in order to display it in my form. Either the user has it
open in Excel, or in some cases, just having Excel open locks it up (can't
figure that one out...)
I would like to be able to dynamically change the file name that I'm
displaying, so that I can control it from within the program and not have it
hard-coded. But the OLE control's DocumentFile property is read-only at run
time.
Any ideas on this? Am I using the control wrong, or the wrong control?
Thanks,
Cathy Tag: Re: Tag: 225916
Is it possible to use Foxpro forms as a backbone to generate PHP+MySQL+AJAX
--
.~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Ubuntu 6.06) Linux 2.6.17.8
^ ^ 21:55:01 up 10 days 2:51 0 users load average: 1.00 1.00 1.00
news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: Re: Tag: 225905
macro substitution in a report
I am generating a cursor with field names produced on the fly, depending on
the month that the routine is run.
I want to design a report and display these fields and wondered whether I
could do it via macro substitution, along the lines of
lcVariable = <fieldname>
and then in the report detail band put
&lcVariable
but it failed. I tried making the variable private or public but this had no
effect. Is there a way of doing this?
Sincerely
Stephen Tag: Re: Tag: 225902
[MSDE] What is the command to truncate the logs?
The size of my database is growing. There is no need to backup anything
and I could stop the server anytime.
--
.~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Ubuntu 6.06) Linux 2.6.17.8
^ ^ 19:04:01 up 10 days 0 min 0 users load average: 1.02 1.02 1.00
news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: Re: Tag: 225901
Upgrade Time
I am finally going to get a shiny, new computer; one that was
built in this millennium.
The same goes with VFP. I will shortly be using VFP 9. (If you
are thinking of joking that this is a sure sign that VFP 10 and 11
will be released RSN, I thought of it first. Neener, neener!)
My question, which is not answered by the Microsoft Website as
far as I could see, is is VFP 6 sufficient in order to order the VFP 9
upgrade?
Lee Mitchell, I might have gone with VFP 9 sooner if there were a
clear statement that VFP 9 development works on a Windows 98 machine.
(Tying software upgrades to hardware upgrades can delay the software
upgrade, something a software company should think about not doing.)
Sincerely,
Gene Wirchenko Tag: Re: Tag: 225890
VFP 9 Reports v's Crystal
I have a series of reports in VFP 7 that have a large number of fields
in the cursor they are based upon. Segments of these fields are printed
in specific detail bands on the report.
They are a little difficult to maintain and also present some paging
issues.
I am considering moving them to use either Crystal Reports or the VFP 9
report writer.
The typical format of these reports are:
report header
detail band 1
detail band 2
detail band 3
report footer
The data in the detail bands all have a key field that references the
data in the report header and are simply linked so a query like select *
from table where linknumber = header.linknumber would get the data
required.
Are reports like this easily implemented in VFP 9? Will I be able to
get rid of my monolithic cursors?
thanks Tag: Re: Tag: 225889
Mixed databases
I have a free tables database in my application (currently in VFP 7). I
need to integrate the application with another application that uses an
SQL/Server database. I will need to execute some queries and stored
procedures on the SQL database.
Can I do that from VFP 7 or do I need to move to VFP 9?
thanks
pete Tag: Re: Tag: 225888
VFP 6 (and ?): Lazy Parsing
I just corrected a bug where VFP could have parsed better. I had
a do case. Somehow, I left off the case keyword on the two cases.
There were no compilation or run-time errors. Here is the corrected
code with the correction in caps:
do case
CASE cwhoshad.stnbusy="L"
busymsg="Station is busy (Local use)."
CASE cwhoshad.stnbusy="R"
busymsg="Station is busy (Remote use)."
otherwise
busymsg=;
"Station is busy. The access type is unknown ("+cwhoshad.stnbusy+")."
endcase
Shades of
* This is a comment;
? "and so is this."
Sincerely,
Gene Wirchenko Tag: Re: Tag: 225887
Searching for a good ARJ and PAR compression activex or dll
Hi,
I would like to add ARJ and PAR to our VFP based backup software. All the
stuff I've found on google so far has been C++ libraries or stuff for
Borland Delphi etc.
Thanks
Tristan
BackPack Product Manager
www.backpackpro.com Tag: Re: Tag: 225886
DBSETPROP - IdleTimeout documentation error?
Hi there,
I'm comparing the MSDN for DBSETPROP "IdleTimeOut" to the tooltip that
comes up in the IDE.
MSDN says that the value is in minutes, but the tooltip says the value
is in seconds. Tag: Re: Tag: 225881
strange behaviour - MODIFY FILE
VFP8 SP1
I have an error handling routine I would like to popup a box that the user
can type into to say what they were doing at the time of the error. The file
is then emailed to us.
When the MODIFY FILE command finishes I get this message "Session number is
invalid" repeated many times CANCEL IGNORE & HELP buttons are available,
cancel fixes the problem and the email is generated.
cReasonFile = TRANSFORM( INT(rand()*10^8) ) + ".txt"
STRTOFILE(CRLF + CRLF + CRLF + "[Please include a brief description of
how the error occurred]", cReasonFile)
MODIFY FILE (cReasonFile)
*** Seems to occur here after the Modify completes but before the
fileToStr() executes.
cReason = FILETOSTR(cReasonFile)
ERASE (cReasonFile)
If I use the debugger to step through the code the problem doesn't occur.
The only way I have been able to determine where the error occurs is through
"wait window ..."
Any ideas - I am stumped, it could be the error being reported is wrong. Tag: Re: Tag: 225867
Using Setup Wizard 6.0
Using Setup Wizard (VFp 6.0) how do i create a Desktop icon to run my
application and also to place it on the Start Menu (i.e
Start...>Programs...> MyApp). plz help. Tag: Re: Tag: 225863
Add money to your Paypal account with OPRAH Hlt8*
Read this message until the end, and you will find out how the money flows in easy !!!!.
Follow the steps and it WILL work. Trust me !!!!!.
It's NOT illegal and it is NOT a scam !!!!!.
PROVEN ON OPRAH! Reported in the Wall Street Journal!!!!
The only thing you need is : - E-MAIL ACCOUNT
- PREMIER (FREE) or BUSINESS PAYPAL ACCOUNT
- $6 on this account (The only investment)
- 30 minutes of your time
There is no limit on how much money you can recieve, and you haven't got anything to lose with this Business program. I will explain how it works !!!!!.
Follow these 4 easy steps and it WILL work !!!!!.
STEP 1 : SIGN UP FOR A FREE PAYPAL ACCOUNT !!!!!.
Paypal is a free and safe way to pay and receive money on the Internet.
Creating a account is as easy as creating a MSN account.
Copy and paste the next line in your Internet browser and sign up.
HTTP://WWW.PAYPAL.COM
Be sure to sign up for a FREE Premier or Business account and not for a Personal account.
You cannot receive CREDITCARD payments with a Personal account and we can't have that. Do we !!!!!.
STEP 2 : SENT $6 TO YOUR PAYPAL ACCOUNT
This is your only investment to receive the money with ease.
With your Paypal account, send $1 to each e-mailadres listed below.
!!!!! IMPORTANT !!!!! Be sure to use this SUBJECT : *PLEASE PUT ME ON YOUR EMAIL LIST* when you send the money.
1) martine@pilote.net
2) dexxatol@netcourrier.com
3) armygirl8568@hotmail.com
4) comjii@starband.net
5) sinnek@bellsouth.net
6) nsi@nelasat.com
STEP 3 : PUT YOUR E-MAIL ADDRESS ON THE BOTTOM OF THE LIST
After you have send $1 to each e-mail address, put your e-mail address on the 6th place.
Remove e-mail address number 1, and move each e-mail address 1 step up the ladder.
!!!!! IMPORTANT !!!!! BE SURE THAT THE E-MAIL ADDRESS YOU USE IS THE SAME AS YOU USED TO SIGN UP AT PAYPAL.
Remember that this is LEGAL. You are creating a service : an e-mail servicelist.
STEP 4 : UPLOAD OR COPY THIS MESSAGE TO NEWSGROUPS, FORUMS ETC AND EMAIL IT TO ALL YOUR FRIENDS!
There are 32,000 newsgroups. Upload or copy this message to at least 200 newsgroups or forums etc, but ........ remember that the more your upload the more people will see your message and the MORE MONEY WILL FLOW IN.
How to upload to newsgroups and forums? :
After you have followed step 1,2,3 and 4, save this message (and copy so you can use it again).
Use your Internet browser and Outlook Express or another newsreader and try to find FORUMS, NEWSGROUPS,
BULLETIN BOARDS, DISCUSSION GROUPS, CHAT SITES and ONLINE COMMUNITIES. Use GOOGLE or use a NEWSERVER.
Use every option to post this message. Download PostXpert to send 1 message to more NEWSGROUPS at the
same time.
!!!!! REMEMBER !!!!! The more you post this message the more MONEY WILL FLOW IN.
Why does this Business program work so well !!!!!.
Lets asume that from the 200 (or more) messages that you have posted, only 5 people respond, you will have your
$6 back that you have invested. Those 5 people will each send at least 200 messages with your e-mailadres on
number 4. That's 6 x 6 x $1 = $36. The next 25 people will also send 200 messages with your adres on number 3. That's 36 x 6 x $1 = $216. The next 216 people also send 200 messages with your name on number 2. That's 216 x 6
x $1 = $1296!. Those 1296 people again also send 200 messages with your name on number 1. That will give us a total of 1296 x 6 x $1 = $7,776.
Now the last tier! 7776 x 6 x $1 = $46,656!!!!!!
This is only a EXAMPLE with 6 reactions. You WILL get MORE responses than that.
Remember that most newsservers will leave the posted messages on there servers for about 2 weeks. If you will post your message again, it WILL again start from the beginning. So you can repeat this over and over again.
Everyday MILLIONS of people are ONLINE and reading these messages, JUST LIKE YOU RIGHT NOW.
I also was sceptical in the beginning and have read a lot of these messages. I also thought that it was bullshit.
Until I thought : What the hell!, only $6. What's $6 and a couple of minutes of my time to solve my money problems.
!!!!! REMEMBER !!!!! Follow every step, and IT WILL WORK, TRUST ME. !!!!!
!!!!! BEST WISHES AND GOOD LUCK !!!!!
w)O>+;)<9UVS;F>qaGL<Uq#v`V6(F]- rM;$g+!4IIQ*827?H4 Tag: Re: Tag: 225860
Who has file open in Netware
Hi,
I need to know who as a particular file open. The file is on a Netware
server and it's possible that several users have the file open at the same
time (not exclusively of course).
Gplib used to be great for this but AFAICS there is no version of gplib for
VFP.
Any ideas how to do this?
Thanks,
Frank Tag: Re: Tag: 225855
Usability question?
Hi,
I'm developing multiple projects in VFP 9.0 and I'm wondering if it is
possible to have a shortcut on my desktop that launches a specific project
in the development environment? That way I could have a shortcut to each
project that would have the correct startup folder and all. Does that make
sense? Is it possible? How do you handle developing multiple projects on
the same system?
Thanks in advanced,
Linn Tag: Re: Tag: 225851
print with word97
I have an exe I think was originally created in vfp 5 , has been upgraded to
8 and then to 9. It creates a word document and populates it with variables
created in same exe. The problem is it will only print correctly if word 97
is the only version of word on the computer running it. The part that
doesn't print properly is a variable that uses chr(13)+chr(10). The newer
versions of word do not have the carriage return . Only a space.
I don't know what to look for ?
thanks
sherry Tag: Re: Tag: 225843
Connection Handle Disconnect?
This is a multi-part message in MIME format.
------=_NextPart_000_0006_01C6BFE4.B675A5D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi All,
I am creating a connection to MySQL with the code below and using it in =
my CursorAdapter classes.
lnConnectionHandle =3D SQLSTRINGCONNECT(lcConnectionString,.T.)
Testing the application, I noticed that if I left one of my forms open =
without any user activity for some period of time the connection gets =
lost.
What am I missing here?
--=20
Edhy
------=_NextPart_000_0006_01C6BFE4.B675A5D0
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.2900.2963" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi All,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I am creating a connection to MySQL =
with the code=20
below and using it in my CursorAdapter classes.</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>
<P>lnConnectionHandle =3D </FONT><FONT face=3D"Courier New" =
color=3D#0000ff=20
size=3D2>SQLSTRINGCONNECT</FONT><FONT face=3D"Courier New"=20
size=3D2>(lcConnectionString,.T.)</P></FONT></DIV><FONT face=3DArial =
size=3D2>
<DIV>Testing the application, I noticed that if I left one of my forms =
open=20
without any user activity for some period of time the connection gets=20
lost.</DIV>
<DIV> </DIV>
<DIV>What am I missing here?</DIV>
<DIV><BR>-- <BR>Edhy</DIV>
<DIV></FONT> </DIV></BODY></HTML>
------=_NextPart_000_0006_01C6BFE4.B675A5D0-- Tag: Re: Tag: 225825
VFP How do I determine table buffering setting.
I want to be able to determine if cursorsetprop has been used to set
buffering to something besides 1 for a free table.
How do I do that? Help says you can find out by using cursorsetprop
but doesn't tell how. Tag: Re: Tag: 225812
Case studies in VFP
Trying to submit a case study to MS, The Case study is for a 80GB 100% pure
VFP 9 application. The site is not very helpful. Anybody know the procedure?
Thanks
Mohammed Tag: Re: Tag: 225799
Clipper to VFP
Anybody done this? What should I be aware of? Is it easy?
Used to use Clipper as a compiler for dBase, did some programming in it when
they broke away, Lost track of it over the years.
Any and all information, Tips etc would be greatly appreciated.
Thanks
Mohammed Tag: Re: Tag: 225798
The buffer overrun problem I encounted.
It's the projecthook class. If I unhooked it, nothing would go wrong. If
I ever tried to hook it up again, it would keep crashing even if you
unhooked it after a failed compile. It seemed that the project builder
would remember something that could bring about the crash.
I believe my codes in projecthook.beforebuild and projecthook.afterbuild
are clean and simple (mainly about hacking the report forms). Even if I
just added some comments into these 2 events, the compile would still crash.
--
.~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Ubuntu 6.06) Linux 2.6.17.8
^ ^ 12:22:01 up 5 days 17:18 0 users load average: 1.11 1.10 1.07
news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: Re: Tag: 225794
Indexing a table on multiple fields with a date field in descending order
I have a table with the following fields: id, date, testrecord. What I want
to do is to order the table so that the records are ordered as follows: id
by date by testrecord. I want id to be in ascending order, but date and
testrecord in descending order. I created an index file called testdata with
the expression: id+dtoc(date,1)+testrecord. Id and testrecord are character
fields.This index file will sort in ascending order. My question is: what do
I need to do to get the table sorted as I want it - that is id in ascending
order, but date and testrecord in descending order? Tag: Re: Tag: 225790
If I was to submit the test case
Could I request M$ to sign an Non-Disclosure Agreemnt? :)
Ok, I knew our stuffs aren't that mission-critical, but ....it's still
my company's property.
--
.~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Ubuntu 6.06) Linux 2.6.17.8
^ ^ 22:12:01 up 5 days 3:08 0 users load average: 1.02 1.03 1.00
news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: Re: Tag: 225786
Winsock Control Help
Thanks in advance for the help.
I'm trying to build messaging into my app using the Winsock control and
there is something that I don't quite understand.
I need each instance of the app to act as both a client and a server so that
it can receive messages from anywhere and so that it can send messages to
anywhere. Do I need two controls? Do I listen and send on different ports?
Has anyone ever built this type of app using this control?
Thanks,
Jeff Tag: Re: Tag: 225769
Confused by sample code
Hello and thanks for the help.
I am looking at some sample code which works but there is an element of the
syntax which is confusing. The code is:
ThisForm.tcpServer.Object.LocalPort = 1001
ThisForm.tcpServer.Object.Listen
where tcpServer refers to an instance of the Winsock control. Why is the
.Object in this code? What is the difference between
Thisform.tcpServer.Object.LocalPort and Thisform.TcpServer.LocalPort?
Thanks again,
Jeff Tag: Re: Tag: 225764
Append general error
Just trying to append a .jpg file and get an error I haven't had before.
When using
Append general photofield from temp.jpg
I get
"OLE error code 0x80070002. The system cannot find the file specified"
Is there something wrong with my VFP9 installation?
-----------------------------------------------------------------
Paul Lee ........ Abri Technologies ........ http://www.abri.com/
'Recover' - top rated FoxPro file repair utility.
----------------------------------------------------------------- Tag: Re: Tag: 225758
Sending Control G to serial port
In the code below I want to send CTRL G as the output. How do I do it or
what is the code I need to enter.
***Program code***
PUBLIC ComForm
ComForm = CREATEOBJECT('Form')
ComForm.AddObject("Testcom","Olecontrol","MSCOMMLib.MSComm")
ComForm.Testcom.CommPort = 2 && Use Comm2, The second Serial Port.
ComForm.Testcom.Settings = "14400,N,8,1" && 14.4 Kbaud, No Parity,
&& 8 data Bits, 1 Stop Bit
ComForm.Testcom.PortOpen = .T.
ComForm.Testcom.Output = "ATDT555-1234" + chr(13) && Dialing the number
* The chr(13) is needed to complete the modem command sequence
ComForm.Testcom.PortOpen = .F.
***** End Code *****
Rusty Tag: Re: Tag: 225751
TIF Files
I have been using the kodak image viewer to open TIF files from my foxpro
applications and it has been giving me memory errors since the last patch to
Windows XP. Kodak image viewer is no longer supported.
I was wondering if anyone else had another view they were working with.
I have Adobe 7 but have not figured out how to initiate the program from
within Foxpro.
Any ideas? Tag: Re: Tag: 225745
Converting Tabs to Spaces
Does anyone know of command to convert Tabs into Spaces?
of course a STRT will do the trick, except for the tabs that are less than
the characters specified in the STRT.
There is a VB command which I've seen referenced although I don't know if it
will address the problem above.
Edit.ConvertTabsToSpaces
--
Thank You,
Louis Tag: Re: Tag: 225744
Need URGENT help with interactivechange with 2 combo boxes
I am unable to change selection in 1st combo box when I try to clear
the value of the 2nd combo box in the interactivechange area. Here is
a little better explanation:
I have 2 combo boxes on my form. Both combo boxes get populated using
a select statement. Everything worked fine until I decided that I want
to clear the value of the second combo box if the first one changes to
force the user to make a new selection so I put this in the first combo
box in the interactivechange event:
thisform.cmbBox2.value = ""
Now when you try to change the selection in the 1st combo box, the 2nd
combo box does get cleared, but the first combo box doesn't change like
it is supposed to. When I remove this line from the interactivechange
event you can change the 1st combo box and the new selection appears.
What am I missing? Is there another way to force them to make new
selections in corresponding comboboxes when one changes the primary
one?
Thanks in advance for any help you can give me. Tag: Re: Tag: 225741
Damaged/Corrupted DBF
I have a corrupted .dbf file that can not be opened. What are my best
options for getting this file repaired? The file does not have a .fpt
associated with it.
I know there are many utilities that can be purchased, but which one. I
can't believe Microsoft hasn't included a utility to repair damaged files
within VFP. I don't like the thought of paying $199 for a utility that I
almost never need.
I have this one client that seems to come up with a damaged file every six
months or so. Any clues of why this is happening? They are running the
application off of a Citrix server, meaning it is accessed via Citrix and
actually loaded on the Citrix server.
I have many apps that have been running for years and years without any
corruption? All my apps are running on file servers?
VFP9 / Windows XP Tag: Re: Tag: 225738
Speaking of code generator using Foxpro...
Mr. Ed Leafe didn't use Foxpro to generate python codes for his Dabo
Framwork as well.. :)
I wondered whether Dabo could generate PHP code....
--
.~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Ubuntu 6.06) Linux 2.6.17.8
^ ^ 21:18:01 up 3 days 2:14 0 users load average: 1.01 1.02 1.00
news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: Re: Tag: 225734
How to get the complextype data return from a web services?
Hi
I am actually testing how to use web services using VFP8.
I have written a sample code (see below) to consume the web service on the
link below:
http://www.webservicex.net/WS/WSDetails.aspx?CATID=12&WSID=64
---------------------------------------------------------------------------------------------------------
LOCAL oWS AS "XML Web Service"
LOCAL loGeoIP
TRY
oWS = CREATEOBJECT("MSSOAP.SoapClient")
oWS.MSSoapInit("http://www.webservicex.net/geoipservice.asmx?WSDL")
loGeoIP = oWS.GetGeoIPContext()
CATCH TO oErr
MESSAGEBOX(oErr.Message)
ENDTRY
IF VARTYPE(oWS) = "O"
RELEASE oWS
ENDIF
---------------------------------------------------------------------------------------------------------
The method GetGeoIPContext() return a complextype GeoIP.
Below is the GeoIP extract portion from the WSDL file.
- <s:complexType name="GeoIP">
- <s:sequence>
<s:element minOccurs="1" maxOccurs="1" name="ReturnCode" type="s:int" />
<s:element minOccurs="0" maxOccurs="1" name="IP" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="ReturnCodeDetails"
type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="CountryName" type="s:string"
/>
<s:element minOccurs="0" maxOccurs="1" name="CountryCode" type="s:string"
/>
</s:sequence>
</s:complexType>
Does anyone know how to extract the complextype data in VFP8?
Appreciate your help.
Tham Tag: Re: Tag: 225720
How to determine the input method for the textbox control?
Hi
I have a PC with a barcode scanner and keyboard attached to its PS/2 plug
using the Y cable.
In my VFP8 application, I want to control the type of input method for a
textbox control in a form.
That means that I want the data to be input to a textbox control ONLY from
the barcode scanner, NOT from the keyboard.
Is there a way to determine or control the input method for textbox control?
Appreciate your help.
Tham Tag: Re: Tag: 225718
License
If I bought Visual Foxpro via Amazon.com from Hong Kong, is the license
valid? Not many shops in Hong Kong sell VFP...
--
SoftMedia Technology Co., Ltd.
Website: http://www.softmedia.hk Tel: (852)2743 4228
* TryEasy Accounting/POS/Trading/ERP solutions Tag: Re: Tag: 225717
project file
The project that I have been working on for some months loads fine in
the vfp 9 ide. It looks like all the forms and code are present.
When I try to build the project it says the memo file, name.pjt, is
missing or invalid. I see that yes, the file is present where it
should be. Is there some way that I can regenerate this file? Tag: Re: Tag: 225711
Need help with combobox
Hi everyone. I need some help with using a drop down combobox. I have a
table (physicians) that contains physician's names and phone numbers. I
want to be able to create a drop down menu where users can click on the
drop down menu and select the physician. Once the usr selects the
physician, I want a text box to display the physician's phone number
automatically. How would I go about doing this? I am using VFP 8 with
SP2.
Thank you in advance.
Arvin Tag: Re: Tag: 225710
VFP 9 Local Drag and Drop
Is there a way to drag the contents of a control on a form to another
control?
IE. drag contents of a textbox to another textbox.
My specific need is to drag the contents of a cursor cell to a cell in
another cursor.
I have gotten it to work using a right click to copy and then paste but
would like it to be a little more elegant.
Jim Tag: Re: Tag: 225705
SBT/Vision Point 10 with VFP 6.0
Anyone out there using SBT/Vision Point 10 in Windows XP, along with
Visual FoxPro 6.0 (actually, any version of VFP)? My client has source,
and I'm doing extensive revisions to non-Laser printing output,
bypassing the Report Generator code and the .FRM/.FRX files, and getting
FoxPro "C0000005" error. Researched that on Google, found only one guy
who seemed to really know anything about it, and he suggested
downloading the latest Service Pack (SP5) which I did. Still, no joy.
Wondering if anyone else is doing something similar.
Many thanks for your input. Tag: Re: Tag: 225702
VFP build version
Hi,
Is there a way to find what version of VFP I used to build an executable?
I'm sure I've seen an (MSDN?) article on it before, but can't seem to find
it anywhere.
Any help much appreciated. Tag: Re: Tag: 225700
VFP 9: Help with sending/receiving XML via FTP
Hello,
Looking for resources which will help me understand XML via FTP. The same
application is used by both the sender and recipient.
Here is what I do (sender):
Insurance claim is created (single record).
The record is converted to XML.
The XML file is uploaded to specific FTP directory for the specific
insurance company.
At the other end (recipient):
Recipient checks FTP folder for contents.
Recipient is prompted to download the claims.
The claims are downloaded and exported to table.
Confirmation is returned to sender.
I have the concept of how it will work, but I need a good book or
suggestions from you on how to actualy deploy the idea.
Thanks for the input.
JD Tag: Re: Tag: 225698
Running BAT file via ShellExecute
I kick off a BAT file from within my VFP7 app with something like this...
lcPath = "C:\MyPath"
lcFile = "MyFile.BAT"
CD (lcPath)
ShellExecute( 0, "open", lcFile, "", "", 2 )
All works OK.
However, if lcPath has a value of [\\MyPC\c\MyPath] the ShellExecute doesn't
seem to work.
SYS(5) + SYS(2003) return the expected value of [\\MyPC\c\MyPath] at that
point.
FILE(lcPath + "\" + lcFile) returns .t.
Any ideas?
Brian Tag: Re: Tag: 225684