Recent content by Exie

Hi Folks, I know this isnt the right forum, I searched, but couldnt find the right spot, so hopefully powershell is close enough. My need is, to have a basic CMD script run a command, that pops out a flat XML file, but within some of the elements is the & symbol. This needs to be changed to...

Thanks folks. Not quite sure how to do that though. Perhaps the attached screen shot would help ? My current code refers directly to a control on the form like: [Forms]![ForecastForm]![SKU].Value There is a query, which is bound to the form. I tried to access it, but dont really know where...

Sorry MajP, To try and clarify.... I have 1 linked table (ODBC) to Oracle. I have this connected to my form and it lists the records correctly. In the header of my form, I have some combo boxes which control filters on the data. The extra information has to come from a COM object which is...

Hi Folks, I have a table, bound to a continuous form. This works fine. However when I load the form, I want to execute code in a module and put the result in a control on that row. Eg. My table/result set might have 5 rows, each row has a part number. For the first row, product 021055 I want...

Sorry, to clarify the above question... this is the error I get: org.apache.jasper.JasperException: /list.jsp(40,38) PWC6228: #{...} not allowed in a template text body. I'm not sure what this means....

Hi, I have a small app and would like to use Rich Faces to boost up the UI a bit. I found this component here: http://www.jboss.org/file-access/default/members/jbossrichfaces/freezone/docs/devguide/en/html/extendedDataTable.html And used this code here: <f:view> <ui:composition...

Hi, Before anyone jumps up and down about not trying to search for an answer, I HAVE! I found alot of talk about going from multiple rows into a single row with multiple columns, but cant find anything about going the other way. I basically have a wide table with 12 columns (JAN, FEB, MAR...

Hi Folks, This one is driving me nuts! I create a materialized view like so... CREATE MATERIALIZED VIEW DWH.MERGESALESFIGURES_JS_MV TABLESPACE USERS CACHE LOGGING NOCOMPRESS PARALLEL ( DEGREE 2 INSTANCES 2 ) BUILD IMMEDIATE REFRESH COMPLETE ON DEMAND WITH PRIMARY KEY AS SELECT blah, blah...

ho-hum... thanks Dagon I see what your getting at.. my problem is my subquery needs to sumarize WITH a filter from another table... so theres sort of 3 tables involved... table1 = table2 where (sumarized table1 = table3) By making it an outer join ... what I'm aiming for is ... table1 may or...

Hi, I've got a long query which needs a difficult table that is structured like so: UB,1,000123,1,"99973245" ... in order to get the correct row, I need to use a subselect and a crap conversion to get the number into a valid date format. The problem is ... some records will not have an entry...

Yep, the SQL runs fine as user "dwh" or "sys" ... I think I might have found the problem though... the SQL query was extract data across the DB Link from a view I created in the remote DB. I sucked the guts out of the view definition, and put that into the MView query so that it runs against...

I created a DB link to another server, and developed an SQL which queries a view through the DB Link. This works ok, but when I try to create a materialized view with the query, I always get: ORA-00942: table or view does not exist ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 960 ORA-06512: at...

Hi, I have 2 tables with dates like so: TableA ------- ProductID Date Value TRUCK 16/10/08 $5 TRUCK 10/10/08 $4.5 TRUCK 03/10/08 $4 CAR 15/10/08 $4.25 TableB ------- SaleId Customer ProductID SaleDate 1010 Customer1 TRUCK 11/10/08 1011 Customer2...

Hi Folks, I'm trying to genrate a date string like so: [Time].[All Times].[FY2009].[Q2].[OCT].[10] ... so I'm trying to use the simple date formatter like so: String formatter = new SimpleDateFormat("'[Time].[All Times].[FY'yyyy'].[Q1].['MMM'].['dd']'").format(new Date()); Here's my problem...

Hi, Trying to run some code like this: --/ CREATE OR REPLACE PROCEDURE UTDELETE is DECLARE mystr varchar2(20); BEGIN for c1 IN ( select table_name as tb from sys.all_tables where owner = 'MTMS' order by table_name ) LOOP...