Search results for query: *

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

Please disregard this query. It turned out the newer compiled app is stored somewhere and am still using the older version. Sorry for causing some commotion. I think I need to call it a day. [banghead] kilroy [knight] philippines "Once a king, always a king. But being a knight is more than...

I forgot to mention, my dev PC is Win 10 Pro with VFP9 SP2, if that matters. kilroy [knight] philippines "Once a king, always a king. But being a knight is more than enough."

Dear All, I encountered this just now. Here's the scenario. I have two forms - one being the parent which fills the entire screen and where the encoding takes place, and the other, a smaller one, where a grid resides to show the user some reference data. I set the smaller form's AlwaysOnTop...

Hello all. Well, I just had to make this happen myself. What I did is I modified the "SendEmailUsingCDO" procedure by making an additional parameter "lConfirmOff" which receives a logical value of .T. (silent) or .F. (with confirmation message). See the very small modifications below in blue...

Hello all. Using FoxyPreviewer, I've already made a sample program that sends a PDF file encrypted with password. The original purpose of this project is to make an unattended sending of different versions of a report to different key persons. My question is, is there a way to supress the...