Search results for query: *

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

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...

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):

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...

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...

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.

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...

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))

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...

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

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")

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...

David, You can use LTRIM() with distinct trim characters and even strings. So, simply ? LTRIM("FA144174000", 1, "FA", "0") ? LTRIM("FA007074000", 1, "FA", "0")

Frederico, Those will be the Watched Forums. I changed my Tek-Tips bookmark to https://www.tek-tips.com/watched/forums, and now my entry point in Tek-Tips is similar to what I was used to in the previous interface/system.

Chris, The VFP compiler only replaces whole defined words in [] delimited strings or regular code statements (I couldn't figure out if you were stating this or otherwise). CLEAR #DEFINE SEPCHAR - LOCAL TestDummy AS Dummy m.TestDummy = CREATEOBJECT("Dummy") ? m.TestDummy.SepCharacter ...

Most probably, SepChar is being #DEFINEd somewhere in your application. You can check this by issuing #UNDEFINE SEPCHAR just before the statement that is raising the error.

Chris, As long as the executable declares its DPI-Awareness, the standard VFP9 report engine produces a correct output. This can be demonstrated by the code posted in the https://www.tek-tips.com/threads/report-behavior-when-sending-to-pdf.1798781/post-7453555']thread [/URL]I mentioned above.

There are a few discussions on the issue here at TekTips and elsewhere. You may start here: https://www.tek-tips.com/viewthread.cfm?qid=1798781

TinyNinja, Is the Windows text scale setting higher than 100%? If so, try setting it to 100% and rerunning the report. If the report is okay, you'll have to signal your application as DPI-Aware.

1962dez, A different question, a different thread, please. But, in anticipation of your new thread, when you say that the website is "time synchronized to (something)", do you mean it's in a different time zone?