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!

Recent content by torturedmind

  1. torturedmind

    Is it possible to have time out in VFP?

    Vernpace Its a FAQ from this forum. FYI Thank you. kilroy [knight] philippines "Once a king, always a king. But being a knight is more than enough."
  2. torturedmind

    Is it possible to have time out in VFP?

    Take a look at this. But instead of shutting your app down, make it do what you needed it to do. kilroy [knight] philippines "Once a king, always a king. But being a knight is more than enough."
  3. torturedmind

    SELECT Selects Old Data From Somewhere

    Steve, May I also suggest you use bind variables/parameterized query? Your statement cmd = 'SELECT * FROM Clients' + IIF(EMPTY(m.cYr), '', ; " WHERE Entered>='"+m.cYr+"-01-01'" + IIF(.InclUnpaids, ' OR Pmt1Amt=0', '')) could be cmd = 'SELECT * FROM Clients' + IIF(EMPTY(m.cYr), '', ; " WHERE...
  4. torturedmind

    Week of the year

    Here is a small SQL showing that week 1 of the year starts with Jan. 1 and Sunday is day 1 of a week. SELECT a.d dDate, TO_CHAR(a.d, 'Dy') cDay, TO_NUMBER(TO_CHAR(a.d, 'd')) nDay, TO_NUMBER(TO_CHAR(a.d, 'ww')) nWeek, TO_NUMBER(TO_CHAR(a.d, 'ww')) + CASE WHEN...
  5. torturedmind

    Blank instead of zero in numeric column right justify issue

    Hello Sir, In the format of the TRANSFORM you're using, the remaining numeric placements (10 thousandth and above) are being converted to spaces. This could be what is being displayed in the control which makes it to look like the value is right-aligned. Try using ALLTRIM(TRANSFORM(...))...
  6. torturedmind

    FoxBarCode's 128 symbology problem

    Thanks Sir Olaf for another hint. The barcode app on my mobile phone also scanned with the output having the "0". So after reading again the basics of code 128 symbology and reviewed my code, I decided to change this line .cSet128 = "*" && * - Auto, A - Set A, B- Set B, C - Set C to this...
  7. torturedmind

    FoxBarCode's 128 symbology problem

    Hello good Sirs. Thanks for all your responses. Sir Griff, The end-user did not explicitly specified the need for the comma. But based on the format they submitted, a comma was there. Tried also STR() (<number exceeding 9,999 + " EA">) and the result was the same. If anyone was wondering, "EA"...
  8. torturedmind

    FoxBarCode's 128 symbology problem

    Thanks Griff for a very quick response. The control doesn't need to be formatted past 99,999 as the out quantity barely reaches 50k. And yes, the space is required by the end-user. kilroy [knight] philippines "Once a king, always a king. But being a knight is more than enough."
  9. torturedmind

    FoxBarCode's 128 symbology problem

    Hi All, It's been a while since my last visit here. Anyways, I have this: SET PROCEDURE TO FoxBarCode ADDITIVE SET PROCEDURE TO FoxBarcodeQR ADDITIVE SET PROCEDURE TO gpImage2 ADDITIVE PRIVATE poFbc, loFbc poFbc = CREATEOBJECT("FoxBarcodeQR") loFbc = CREATEOBJECT("FoxBarcode") WITH loFbc...
  10. torturedmind

    Instance #2 is waiting for what?

    On our 2-node Oracle 10g RAC database, we noticed that the user SYS in node 2 is waiting. But upon checking the SID, nothing shows. What's it waiting for? kilroy [knight] philippines "Once a king, always a king. But being a knight is more than enough."
  11. torturedmind

    How can clear the value in a textbox where i input date

    Hi, Also, make the this.txtdate.dateformat = 1 to this.dateformat = 1 because "this" already refers to the object "txtdate". kilroy [knight] philippines "Once a king, always a king. But being a knight is more than enough."
  12. torturedmind

    Updating Underlying SQL Table from a Grid and a Form

    I dunno if this could help but I made this function to open an Oracle table/view. The other functions came from the FAQ section of this generous forum. You may want to change some things to suit your environment/back-end DB. Usage: OpenRemoteDat( ; nConnHandle, ; "SomeSchema", ; "SomeTable"...
  13. torturedmind

    Filters and Grids

    What I meant was if "THIS" is used on the right side of the filter expression. kilroy [knight] philippines "Once a king, always a king. But being a knight is more than enough."
  14. torturedmind

    Filters and Grids

    Another possible cause is the use of "THIS" in the filter expression which makes the filtering out of scope when an object in the grid loses or gets the focus. kilroy [knight] philippines "Once a king, always a king. But being a knight is more than enough."
  15. torturedmind

    Export functions and procedures DBF to OpenOffice Writer (odt) and Calc (ods)

    Nice tools you have there, good sir. Thanks for sharing them. kilroy [knight] philippines "Once a king, always a king. But being a knight is more than enough."
See more

Part and Inventory Search

Back
Top