Recent content by torturedmind

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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