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...
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.
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?
Chriss,
I would take any misidentification between Marco and me as a badge of honour, but you should edit your posts to refer to Marco appropriately :-)
Abe,
You may try two or three things to solve the issue or to gather more information:
Use a MariaDB ODBC connector instead (select Windows 32-bit as OS).
Try to connect with the database through ODBC but using another application, like Excel.
Use a database frontend administrator, such as...
herbstgy,
Once you export the Outlook calendar in iCalendar format, you can use the iCal4VFP library (at https://github.com/atlopes/iCal4VFP) to ingest the events dates into a cursor and work from there.
This is the basic code to export the calendar from Outlook and import it into a VFP...
Alastair,
Bear in mind that the Properties window treats null and .null. differently: a property initialized as .null. is set to .NULL., whereas a property initialized as null or NULL or Null is set to a string ("null", "NULL", or "Null", ...). To use the dotless notation, you have to prepend...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.