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 Rhinorhino 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: *

  • Users: dylim
  • Content: Threads
  • Order by date
  1. dylim

    Is there a FUNCTION or Property to Get the "Complete Address" of a Form Control

    Hi Guys, Is there some VFP function or Property that will return the "complete address" of a form control? This is what I mean: Suppose I have a textbox named txtFirstname, which is inside Page1 of pgfMain found in a form. How can I get its complete address...
  2. dylim

    Strange MariaDB behavior with Sequential GUIDs

    Hi Guys, I use sequential GUIDs for both my Invoice header and detail tables. Ever since I moved to MariaDb, it was only now that I noticed that if I do a select of the invoice detail rows of a particular header row, MariaDB shows the rows in REVERSE order! I have to explicitly add a "ORDER BY...
  3. dylim

    How to supply filename when doing SET PRINTER TO NAME "Microsoft Print to PDF"

    Hi Experts, Am trying to the do the following: Print to a PDF from a REPORT FORM (a receipt), then email this generated PDF file as an attachment to a customer's email address. My questions: 1. Can I do a SET PRINTER TO NAME "Microsoft Print to PDF" before running REPORT FORM TO PRINT? 2...
  4. dylim

    List Out Missing Numbers of a Number Range

    Hi Guys, Me again. I need to show the user which invoice numbers are missing given a number range. Suppose the following: Actual Invoice Numbers: 1,2,3,4,5,8,9,11,12,13,15 (each of these numbers are in their respective invoice records) Number Range: 1 to 15...
  5. dylim

    Variables: NULL vs RELEASE

    Hi Experts, It's me once again. I have a business object that opens certain cursoradapter (CA) objects. For example, boCustomer will open the Customer CA object and the Salesman CA object. oCustomer = NEWOBJECT( "boCustomer" ) && the Init does the creating of cursoradapters Customer and...
  6. dylim

    SQL Command to Show Monthly Sales Including Months with Zero Sales

    Hi Guys, I guess the thread title is pretty self explanatory. I need to show sales summary of a customer by monthly totals, including months when there are zero sales. Like so: January - P34,000 February - P44,500 March - P0.00 April - P123,500 May - P0.00 ...... etc.... Thanks in advance...
  7. dylim

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

    Hi Guys, With MySQL, I use "DO 1" to check for the server's online status. Works like a charm. But MySQL 8.x has caused me so much pain by way of unknown errors I cannot seem to understand and correct. So, I tried MariaDb, installed the latest GA todate, 11.7.2 and used the latest ODBC 3.2.5...
  8. dylim

    Latest VFP Version

    Hi Guys, This is the version of Visual Foxpro I have been using for the longest time: Visual FoxPro 09.00.0000.7423 for Windows Is this still the the latest? The reason I am asking this is because I came across this link from Microsoft...
  9. dylim

    Correct Connection String VFP to MariaDB

    Hi Guys, I am trying to use MariaDB as an alternative to MySQL. So, I got MariaDB Server 11.4 installed on a test PC, also MariaDB ODBC 3.2.5. I simply cannot seem to make it work! This is the string I used: lnHandle=SQLSTRINGCONNECT("Driver={MariaDB ODBC 3.2...
  10. dylim

    Send Email in VFP just using Windows native functions

    Hi Experts, I have come across several ways to send email in VFP using CDO, BLAT, Outlook or some 3rd party app. Which one basically uses native functions in Windows 10/11? I find CDO kinda iffy coz it needs to reference some URL like...
  11. dylim

    How to set Height, Width and Video Format in VFP using AVICAP32.DLL

    Hi Guys, I was able to fire up a webcam on a VFP form using this link: https://github.com/VFPX/Win32API/blob/master/samples/sample_437.md The problem is, every time the form shows, it will always show a Format Dialog (shown below) asking for Resolution, Pixel Depth and Size. Anyway I can...
  12. dylim

    How to write to a PDF

    Hi Experts, I would like to automate the tedious process of typing/encoding to a PDF (using free apps like FoxitReader or Adobe). The PDF is a government issued PDFs for filing Social Security, Withholding Tax returns, data of which are obtained from a payroll system I developed for them...
  13. dylim

    Webcam models that work with VFP

    Hi All, I would like to ask our community who has already worked with webcams using VFP for picture taking or capturing videos. Kindly suggest webcam models that work seamlessly with VFP. Thanks in advance. Long live the Fox!
  14. dylim

    MySQL 5.7 ODBC Error 1064

    Hi Experts, When I run the following query in MySQL Workbench, it works: select a.employeeid, a.leaveid, b.datefrom, b.dateto, b.approved from lvreqhdr a inner join lvreqdtl b on a.id=b.lvreqhdrid where a.posted=1 and a.cancelled=0 and b.approved>0 and...
  15. dylim

    Why MySQL 5.7 is still getting updates

    Hi All, Since MySQL has 8.0, I was with impression that 5.7 won't be getting new updates. As of October 2022, they still came up and released 5.7.40. Your insights as to why please.. Thanks
    • dylim
    • Thread
    • Replies: 3
    • Forum: MySQL
  16. dylim

    SQL_CALC_FOUND_ROWS still runs in MySQL 8.0.29

    Hi Guys, As per MySQL documentation, SQL_CALC_FOUND_ROWS and FOUND_ROWS() has been deprecated since MySQL 8.0.17. How come I can still use it in MySQL 8.0.29? Comments please? Or maybe I missed a newer memo on this?
    • dylim
    • Thread
    • Replies: 2
    • Forum: MySQL
  17. dylim

    VFP connecting to MySQL 8 hangs sometimes

    Hi Experts, There are times wherein I am trying to connect to MySQL 8 via ODBC 8 from VFP and it hangs indefinitely! I had to terminate VFP and try again for a couple of times before it finally goes through. Any known causes for this? Thanks in advance.
  18. dylim

    Clicked Control in Page in PageFrame Still 'Visible' when new page is activated

    Hi Experts, I have a pageframe with 2 pages. One containing a grid (pagGrid) and 3 commandbuttons for New, Edit and Delete. The second one (pagRecord) is a bunch of textboxes for data entry and commandbuttons for Save and Cancel. If user clicks on say New in pagGrid, it will do an APPEND BLANK...
  19. dylim

    MySQL ODBC 8 Error: the number of attributes is larger than the number of attribute values provide

    Hi VFP Experts, I have recently installed MySQL 8.0.28, in the hope of migrating to it from MySQL 5.7.27. I tried running my apps with the new version, but a lot of times I encounter this error caught via AERROR(): laError[ 1, 1 ] = 1526 laError[ 1, 2 ] = "Connectivity error: CCMD" laError[...
  20. dylim

    Unable to get/capture value from Digital Persona FingerPrint ActiveX

    Hi Everybody, I am tinkering with a fingerprint scanner ActiveX control (Digital Persona). Instantiating, dropping and working with it seems to go on smoothly... till the last event called Done() event, where it is supposed to return a "Fingerprint Template - FPTemplate" object variable...

Part and Inventory Search

Back
Top