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!

Register Log in
  • 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!

Search results for query: *

  1. atlopes

    website URL validation in a text box

    Two VFP alternatives to resorting to VBScript RegExp: SF RegExp, by Lutz Scheffler, at https://github.com/lscheffler/sf_regexp, works as a wrapper to the .NET Regular Expression engine; VFP_RegExp, by me, at https://github.com/atlopes/VFP_RegExp, uses the PCRE engine, with the benefit of being...
  2. atlopes

    outlook 365 OAuth2

    Trial03, My single advice to you is to acquire the Chilkat API. Examples regarding the use of OAuth2 with VFP: https://www.example-code.com/foxpro/oauth2.asp.
  3. atlopes

    Reading registry in VFP

    Jureczek13, This goes untested, since I don't have that software on my machine: #DEFINE HKEY_LOCAL_MACHINE 0x80000002 #DEFINE INSTRUMENTS "SOFTWARE\Native Instruments" SET CLASSLIB TO (HOME(1) + "FFC\registry") ADDITIVE LOCAL Reg AS registry m.Reg = CREATEOBJECT("registry")...
  4. atlopes

    Alternative to SELECT 1 to check MariaDB Server online status ( using DO 1 generates an error )

    Dylim, Just SQLEXEC() it. If there is an active connection with the server, the function will return 1 without generating a cursor. If it returns -1, you'll know the connection is broken and your application must reconnect. m.ActiveConnection = SQLEXEC(m.ConnectionHandle, "-- " + 0h0d0a) == 1...
  5. atlopes

    Alternative to SELECT 1 to check MariaDB Server online status ( using DO 1 generates an error )

    You're right, Chriss, MariaDB is a bit more restrictive regarding comment syntax and minimal SQL statements, and I should have tested before. Your proposal /* */ or a more precise -- based comment -- (hard to see, but equivalent to "-- " + 0h0d0a) will check ODBC connectivity with the...
  6. atlopes

    Alternative to SELECT 1 to check MariaDB Server online status ( using DO 1 generates an error )

    Dylim, A simple SQL comment, even an empty string, will do. Both do not return any cursor: --
  7. atlopes

    FoxCharts help needed

    Great to hear. Notice that you can also populate the field in some of the records (for instance, every half hour in your case).
  8. atlopes

    FoxCharts help needed

    Herbstgy, Try to set the contents of the field referenced in fieldaxis2 property to an empty value.
  9. 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.
  10. atlopes

    Insert data of Arduino on a plot

    Jacob, How is the data formatted?
  11. 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...
  12. atlopes

    append from tab delimited - intersting effect (or bug)

    Yes, that would be a ValueSeparator, defaulting to ",".
  13. 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...
  14. 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):
  15. 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...
  16. 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...
  17. 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.
  18. 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...
  19. 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))
  20. 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...

Part and Inventory Search

Back
Top