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!
-
Congratulations gkittelson 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: oliveng
- Order by date
-
Releasing Forms
You should not place do form in the form event. You should place do form in a program. e.g. In test1.prg do form forma <= execute form forma do form formb <= after execute form forma, then execute formb. :-)- oliveng
- Post #3
- Forum: Microsoft: FoxPro
-
Loops and Cursors
the syntax is create or replace procedure sample (pdate IN varchar2, pnum OUT number) is CURSOR cur1 IS SELECT * FROM table1 WHERE col1 = pdate; CURSOR cur2(vcol NUMBER) IS SELECT * from TABLE2 WHERE col3 = vcol; -- parameterized cursor BEGIN FOR rec1...- oliveng
- Post #4
- Forum: Oracle: All versions
-
Unable to query DATE type field correctly
In Oracle SQL (e.g. SQL plus, Oracle Form, Oracle report), 1. In Oracle default, it will date field in format 'DD-MON-YY' e.g. 01-JAN-99. You can change this statement (to get a max date) SELECT MAX(DATEFIELD) FROM MAINTABLE.EVENT to SELECT TO_CHAR(MAX(DATEFIELD),'DD-MON-YYYY HH24:MI:SS')...- oliveng
- Post #5
- Forum: Oracle: All versions
