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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by atlopes

  1. atlopes

    Generate a qr code on a report.

    Filip, You may have a look at https://github.com/atlopes/zintbarcode. The class is documented and includes various demo programs that cover your use cases.
  2. atlopes

    Insert data of Arduino on a plot

    Jacob, How is the data formatted?
  3. atlopes

    How to set font size and type in TXT file thru VFP6/9

    Piotr, You can define a window with all required settings and modify the report in that window when needed. DEFINE WINDOW EditorWindow FROM 1,1 TO 40,80 FONT "Arial", 14 TITLE "Editor Window" CLOSE FLOAT GROW * the definition is now available * first use MODIFY COMMAND report1.txt NOEDIT...
  4. atlopes

    append from tab delimited - intersting effect (or bug)

    Yes, that would be a ValueSeparator, defaulting to ",".
  5. atlopes

    append from tab delimited - intersting effect (or bug)

    Thank you for pointing that out, Chris. Setting the CSVProcessor ValueDelimiter property to an empty string will treat "X"Y as a single value. The "generally accepted" practice (something that will be open to discussion, of course) to insert double quotes into "-delimited values is to duplicate...
  6. atlopes

    append from tab delimited - intersting effect (or bug)

    This is the result of the import of Chris' sample by the CSVProcessor class (the contents of Col_1 is messageboxed because the browse window represents it as a single line):
  7. atlopes

    Plotting position of text in an image in visual foxpro

    Ravi, You can use a shape to highlight any form section by working with its DrawMode property. The following demo will get you started. The coordinates of the various fields are set over the original image, but the image itself can be resized. No error handling, of course. That will be up to...
  8. atlopes

    Naming Convention of Object

    Kyle, How is loObj2 created? Is the fields object a collection? Can it be iterated, or can its members be addressed individually? For instance, loObj2.fields(0) or loObj2.fields.item(0) (or 1, if one-based), instead of using the field name? Or as a reference in a FOR EACH loop, as in FOR EACH...
  9. atlopes

    FGETS() after reading a file line, is inserting a blank character after each valid character.

    Jose, The text file is in UNICODE. If possible, FILETOSTR() the file and STRCONV() afterwards. If you must use FGETS(), you'll have to deal with the fact that the CR+LF characters marking the end of a line are also in UNICODE, taking four bytes instead of the two bytes that FGETS() expects.
  10. atlopes

    Export Foxpro 9 DBF to Dbase 5 File

    The following code will produce 0x03 files: CREATE CURSOR tmp (pk N(5), abc c(10)) INSERT INTO tmp VALUES (1, 'www') INSERT INTO tmp VALUES (2, 'xyz') COPY TO test-foxplus.dbf TYPE FOXPLUS COPY TO test-fox2.dbf TYPE FOX2 MESSAGEBOX(CAST(LEFT(FILETOSTR(GETFILE("dbf")), 1) AS W)) Adding a memo...
  11. atlopes

    Export Foxpro 9 DBF to Dbase 5 File

    GBCPastor, Run the following command, select one of the dBase 5 files your client uses, and share the result. MESSAGEBOX(CAST(LEFT(FILETOSTR(GETFILE("dbf")), 1) AS W))
  12. atlopes

    WorkbookXLSX R30

    GBCPastor, In the Init method, you have: TRY this.oXDOM = CREATEOBJECT('MSXML2.DOMDocument') CATCH TO loException * this.oXDOM = .NULL. this.oXDOM.preserveWhiteSpace = .T. &&& ADDED by SK 082924 ENDTRY It must be: TRY...
  13. atlopes

    WorkbookXLSX R30

    Can you attach your patched version of Greg's library?
  14. atlopes

    WorkbookXLSX R30

    Put the class in scope by running the following: SET CLASSLIB TO vfpxworkbookxlsx.vcx ADDITIVE Or instantiate the class using NEWOBJECT() instead: Excel = NEWOBJECT("VFPxWorkbookXLSX", "vfpxworkbookxlsx.vcx")
  15. atlopes

    WorkbookXLSX R30

    GBCPastor (and Greg), The problem comes from how the XML DOM treats spaces in text nodes. First of all, apply the patches Greg mentioned in the thread. Then, in the method Init of the VFPxWorkbookXLSX class, add a line #39 with the following contents: this.oXDOM.preserveWhiteSpace = .T...

Part and Inventory Search

Back
Top