Search results for query: *

Hi! It seems that convert function is your problem. I can only give you an Oracle example: SELECT reference,amount,decimals,round(amount/power(10,decimals),decimals) "display" from casetest; I hope this help you Eduard Stoleru e_stoleru@yahoo.com

Hi mjma, try this query: Select brokercompaby,max(statementdate) as statementdate ... Group By brokercompany; Eduard Stoleru e_stoleru@yahoo.com

Try keeping pressed F2 or F10 just after the power on. Eduard Stoleru e_stoleru@yahoo.com

"Flying windows" doesn't use any character. It's using a flying window, which is a picture. I think you're confusing screensavers. Maybe you're talking about "OpenGL text" screensaver ? Eduard Stoleru e_stoleru@yahoo.com

you're right, carp. Eduard Stoleru e_stoleru@yahoo.com

I'm using JDBC and I'm very pleased with it. With JDBC2 you can even implement strong security schemas, the old REF_CURSOR bug (in JDBC1) being fixed. All you have is to build stored functions and procedures in application owner schema, to define a GUI in Java (Swing or AWT) and (granting...

Hi, in Oracle PL/SQL you can use add_months function: in a variable assignment: new_date:= add_months(old_date,1); or in a select statement: SELECT add_months(old_date,1) new_date FROM your_table; Off course, this works for variable or column of date datatype. If you have columns which store...

I don't know mysql, but I know 2 ways of deleting duplicate rows. First (in Oracle), if you have allowed subqueries in mysql: DELETE FROM mytable a WHERE EXISTS(SELECT * FROM mytable b WHERE a.field1=b.field1 AND a.field2=b.field2 ............................. AND a.field57=b.field57 AND...

Could you describe more clearly your problem? I undestood that you want a query which should output rows like: CustomerID1,LicenceID1,ContactID1 CustomerID1,LicenceID1,ContactID2 CustomerID2,NULL,ContactID3 CustomerID2,NULL,ContactID4 CustomerID3,NULL,NULL CustomerID4,LicenceID2,ContactID5...

Let's say that column my_value is your criteria of ordering rows. Then: SELECT * FROM your_table a WHERE 10>(SELECT COUNT(*) FROM your_table b WHERE b.my_value>a.my_value); will retrieve the firsts 10 rows (i.e. the rows which have no more than 9 superiors). This should work for unique values of...

hi. I'm giving you an &quot;Oracle style&quot; solution, with more adjustment it will work on your situation:<br><br>select distinct BRITEM, BRDESC, BRPIC1, BRPHAS, BRLINK, BRDROP, BRSTCK,2 as criteria<br>from pwbits<br>where (<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(UCASE(BRITEM) like...

You should create a query like this:<br>SELECT speciality, seniority,COUNT(*)<br>FROM your_table<br>GROUP BY speciality,seniority;<br><br>This should work in Oracle, maybe using with heading columns preparation and other reporting stuff.<br>Regards, <p>Eduard Stoleru<br><a...

I will give you an Oracle solution:<br>SELECT DateField FROM your_table<br>WHERE DateField BETWEEN RefDate AND (ADD_MONTHS(RefDate,3)-1);<br>this query should retrieve date within the range starting with RefDate and ending after 3 months, except last date.<br>I hope this works for...

HI, is there a MOD operator (or something like this, returning the integer part of a DIVISION operation) in AS400 DB2 SQL? If it is, you can use an expresion like:<br>MOD((CURDATE-START_DATE),30). In other language there's an operator for MOD operation, the '%' symbol. You can use like this...

Hi, DougP. Try using a DELETE statement wich selects the rows with IS NULL operator. If you want to replace the so called index, you should to UPDATE these rows with a sequence. I hope this will help you!<br>Regards, <p>Eduard Stoleru<br><a...

In Oracle you can write like this:<br>SELECT * FROM you_table<br>CONNECT BY PRIOR HI=HP AND PRIOR LI=LP<br>START WITH HI=1 AND LI=1;<br>Good luck! <p>Eduard Stoleru<br><a href=mailto:e_stoleru@yahoo.com>e_stoleru@yahoo.com</a><br><a href= > </a><br>

In Oracle (version 7 or best) you can use DBMS_SQL package to construct dynamicaly any query or procedure you want.<br>example:<br>procedure my_proc(my_table VARCHAR2) IS<br>dummy NUMBER;<br>cid NUMBER;<br>counter NUMBER:= 0;<br><br>begin<br>cid:=...

Hi mixc! Querying a view, which was build on a table restricted with a WHERE clause, is the same thing like querying the source table with a SELECT containing the view restriction, i.e.:<br>CREATE OR REPLACE VIEW v_table AS SELECT * FROM my_table WHERE &lt;&lt;view_condition&gt;&gt;;<br>SELECT *...

Oracle uses MOD function, you can use this:<br>SELECT nvalue FROM your_table WHERE MOD(nvalue,6)=0;<br>Good luck! <p>Eduard Stoleru<br><a href=mailto:e_stoleru@yahoo.com>e_stoleru@yahoo.com</a><br><a href= > </a><br>

As far as I know, that's impossible without rebuilding the report. I suppose you have only the .REP file. Sorry! <p>Eduard Stoleru<br><a href=mailto:e_stoleru@yahoo.com>e_stoleru@yahoo.com</a><br><a href= > </a><br>