Search results for query: *

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

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

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

One of our clients need to have a copy of a very simple report in PDF format. The report contains sensitive information so it needs to be password-protected. In reference to faq184-7355, how can I automate the process of adding a password to the PDF version of the report? TIA kilroy [knight]...

Hello Sirs/Ma'ams, If the 1st SQL statement is faster than the 2nd one, then why do people keep using the 1st? Statement 1 SELECT * FROM (SELECT * FROM anytable) datsub1 ORDER BY 1 DESC Statement 2 SELECT * FROM anytable ORDER BY 1 DESC kilroy [knight] philippines "Once a king, always a...

Good morning to all. I have this "regular" method of updating an Oracle table. Let's just call it Method 1: 1. SET MULTI LOCKS ON 2. Connect to DB using SQLCONNECT() 3. Open the table using SQLEXEC() 4. Set buffering to table buffering optimistic using CURSORSETPROP() 5. Update several...

Good day good Sirs/Ma'ams. It is my first time to try a DSN-less connection to our Oracle server using the connection string from www.connectionstrings.com and from the help file. It was said that no TNSNAMES.ORA file is needed as long as the Oracle ODBC driver is installed, the code below...

Good day to all. So we have this report that we submit to our government for update purposes. For illustration only, let's say... +-------------------------------------------------------------+ | fld1 | fld2 | fld3 | fld4 |...

Hello all, Can a record containing a beginning covered date of say, 2015-06-01 and an ending covered date of 2015-06-05 be generated to become five (5) separate records having individual date of the covered dates using pure SELECT - SQL only? If so, how? TIA kilroy [knight] philippines...

Hello all, Can a record containing a beginning covered date of 2015-06-01 and an ending covered date of 2015-06-05 be generated to become fifteen (15) separate records having individual date of the covered dates using SELECT - SQL only? If so, how? TIA kilroy [knight] philippines "Once a...

Good day to all. We have a problem with one of our tables. It contains millions of records because it acts as a form of audit trail. We already have a back-up of some of the old records and now we want them to be deleted to free up space. The problem is we can't delete these records because one...

Good day to all. What will I include in the config part of this FAQ to log-in to our SMTP server using a different user and/or password? TIA kilroy [knight] philippines "Once a king, always a king. But being a knight is more than enough."

Good day (or night) to all. So here's the scenario: User X defaults to tablespace TBS_A. There are other objects in tablespace TBS_B that user X are able to do stuffs with (update, insert, query, etc.). My question is - what tablespace is used when user X do say, an update on MyTable1 in TBS_B...

Tho I already managed to manually type the missing ones, I just wanted to know - why are most of these not included when I do this? TIA kilroy [knight] philippines "Once a king, always a king. But being a knight is more than enough."

I have the following as part of the code in my main calling program: DO dat_mgr [i]<Do something...>[i] dat_mgr is an .app file that is also called somewhere else in the program. My question is, how will I tell the main calling program to pause until the called .app is finished? TIA kilroy...

Hi, We had a very large amount of data that were transferred from a simple Novell file server to Oracle DB. In the Oracle side, we have a permanent tablespace and a temporary tablespace. This temporary tablespace is NOT the default TS. In it, there are 2 data files called CIM_TMP1.DBF and...

Hello all, I'm stumped on this particular MS Excel automation wherein I was trying to put a formula in a cell whose formula range varies depending on the user's input. oSheet.Range("C13").Formula = [=IFERROR(ROUND(AVERAGE(C10:AG10),0),"-")] That is, the "AVERAGE(C10:AG10)" part may be...

Good day to all. I just wanted to share my experience with a shutdown timer. The app was running smoothly until I dropped a timer (shutdown) on the main form in the main app. The problem was two of the combo boxes, both used to select names of initial approval and final approval respectively)...

Good day to all. I have this small problem with Craig Boyd's Gridextras and the grid's LockColumn property. One of the columns places itself randomly across the grid after calling the SETUP method of the said class. Anyhow, here's a straight-forward procedure of what I did so maybe someone can...