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!
-
Rid of duplicate records in one-to-many (recs 2-??)
Hi hughfreiden, There are so many options to do this. e.g. 1. U can put that record in group header and supress the details part . or 2. U can write a query in sql designer ( selecting rownum=1) and then create report from that query Hope it helps Raj28...- raj28
- Post #2
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Invalid SQL Statement what the!
Hi GDX, Just replace call in place of execute . i.e Dim oConn As New ADODB.Connection oConn.Open "Provider=OraOLEDB.Oracle;Data Source=xiacon.xiacon.com;User Id=intrak;Password=intrak;" LineRun = "call...- raj28
- Post #2
- Forum: Oracle: All versions
-
Trouble inserting number field with precision in Oracle 8.1.5 DB
Hi apawaskar , Convert the datatype ( i.e from number(10,2) to float ). It will definitely solve ur problem. raj28 rd2815@yahoo.com- raj28
- Post #3
- Forum: Visual Basic (Classic)
-
Alter table
Sorry friends, I want to reply for other question but i replied here by mistake. Raj28.....- raj28
- Post #4
- Forum: Oracle: All versions
-
Alter table
Hi scallums, Just go this site http://www.jlcomp.demon.co.uk/faq/debugplsql.html Hope this helps u Raj28.....- raj28
- Post #3
- Forum: Oracle: All versions
-
Syntax error ORA-00904 trying to do Update
Hi theryaster, Just try this - Update itemloc a set fifo_dt=(select lot_dt from fifochk b where a.location=b.location) where location in ( select location from fifochk ) Hope this helps ..- raj28
- Post #4
- Forum: Oracle: All versions
