Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. stirfry

    Making Tax Digital - VAT returns from VFP, anyone looking at it yet.

    My understanding is that you need to make the transaction between accounts program and the sending software seamless. So you can export to a spreadsheet, create the required totals, do any adjustments, then MAP the figures you want from the spreadsheet into the sending software, ie do NOT copy &...
  2. stirfry

    Compression Syntax

    My understanding is that Craig is aware of this. There has been no comment as to when or whether it is to be fixed. When I had previously downloaded it, there was a txt file with details. If you do not have it then please ask for specific info.
  3. stirfry

    reading XML differences between MSXML2.XMLHTTP.6.0 and 3.0

    Thanks Olaf I think you have cracked it. ? ResponseXML.validate.errorCode = -1.0728E+9 & ? ResponseXML.validate.reason "The node is neither valid nor invalid because no DTD/Schema declaration was found" So either use lQualifier=STREXTRACT(lResponseText,"Qualifier","/Qualifier") or go and...
  4. stirfry

    "MSXML2.XMLHTTP.6.0" v "MSXML2.XMLHTTP.3.0"

    I'm trying to use "MSXML2.XMLHTTP.6.0" to send and receive an XML I have been using "MSXML2.XMLHTTP.3.0" for over 10 years but suspect some of my clients are having problems with the ActiveX security I use Try oHttp = CreateObject("MSXML2.XMLHTTP.6.0") Catch oHttp =...
  5. stirfry

    reading XML differences between MSXML2.XMLHTTP.6.0 and 3.0

    Thanks Olaf I check for the TRANSFORM(ohttp.status) is '200' The xml that is sent back is always the same format. It is quite small, only about 10 elements. The routine has worked well for me for over 10 years, however a client had a problem with it at the beginning of this year, I suspect it...
  6. stirfry

    reading XML differences between MSXML2.XMLHTTP.6.0 and 3.0

    Olaf was very helpful with a good description on using MSXML2.XMLHTTP.6.0 & MSXML2.XMLHTTP.3.0 in thread http://www.tek-tips.com/viewthread.cfm?qid=1715949 Try oXML = CreateObject("MSXML2.XMLHTTP.6.0") Catch oXML = CreateObject("MSXML2.XMLHTTP.3.0") Endtry however when I have tried to...
  7. stirfry

    Get only numbers before decimal point

    Yanx The solution is quite simple. You use the INT function. ? INT(expense) will give the Dollar amount. ? expense - INT(expense) will give the Cents. However I totally disagree with your desire to create a field each for them. Could you explain why you wish to do this. Are you displaying the...
  8. stirfry

    Checkboxes wont stay where I put them.

    Jim Yes I have seen this. I now do not put a caption on the checkbox but add a label along side.
  9. stirfry

    How to create a "patcheable" application

    Daniel I rolled my own. Your main exe should be able to read a file off the web to see if there is an update. I compare the version of the exe to a text file on the web. If there is an update it comes out of the main exe & fires a second exe, your updater. This can now download your new exe...
  10. stirfry

    how can i use text file as a database

    create a cursor, then append. create cursor 'curtemp' ; (; line1 C(20),; line2 C(20),; line3 n(10),; line4 N(10); ) APPEND FROM 'fullpath\MODEM1.TXT' delimited
  11. stirfry

    distribute a project

    Howard You can get the VFP6 runtime files from Woodys site: ftp://ftp.prolib.de/public/ The exe will install the runtime files automatically.
  12. stirfry

    Open Office Automation from VFP

    Thanks ronald777. star for you. Thats the best conversion I have ever seen! You should write it up as a FAQ Andrew
  13. stirfry

    printing tax forms

    Hi Micheleb Prior to calling the report I have a form that allows you to enter both height & width changes. Just 2 spinners. I find you have to multiply by 400 to get 1mm change (approx) lUpDown=ThisForm.SpinUpDown.Value*400 lLeftRight=ThisForm.spinLeftRight.Value*400 When they have been...
  14. stirfry

    GOOGLE/MAPQUEST Question

    Wiremesh Here is a link which might do what you want. http://maps.forum.nu/gm_driving_directions2.html You would have to abstract the info from the source. Andrew
  15. stirfry

    Converting Foxpro to use SQL

    Paul You might want to read 'MySQL Client-Server Applications with Visual FoxPro' which has just been published from http://www.hentzenwerke.com/catalog/mysqlvfp.htm Andrew (30 miles north of Edinburgh)
  16. stirfry

    INT function - VFP6

    Olaf Thanks for that detailed information. Andrew
  17. stirfry

    INT function - VFP6

    dbMark Sorry, disagree with your assessment. With VFP9 SP1 I did this in the command window ? int(1333365.8900*100) &&-> 133336589 ? int(1333365.89000*100) &&-> 133336588 Still gives dif values Andrew
  18. stirfry

    Free VFP Compression Library

    Olaf I was using the version of dfpug that came with Foxtalk2. There is a form which allows you to choose the folder to zip & save the zip. I timed the 'oarchive.createarchive' method. I have now dived into that class & can now time the 'createziparchive' method. This does indeed bring the time...
  19. stirfry

    Free VFP Compression Library

    Craig I have rerun the tests on folder with 60 files, size is 1.7MEG. Files were dbf & cdx with one of dbc,dct,dcx. The zip size is 198KB. Saving to another folder on the same drive. Times were dfpug 9.6 seconds vfpcompression 0.312 exceed (old version) 0.359 dropping to dos window & running...
  20. stirfry

    Free VFP Compression Library

    Just run vfpcompression.fll & dfpug back to back. dfpug took over 7 seconds compared to vfpcompression.fll's 0.3 sec I did notice that vfpcompression.fll will skip a used file & still return .T. in its 'Folder' methods. I had to write my own routine ( heavily borrowed from faq184-3830 ) to add...

Part and Inventory Search

Back
Top