Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE » How To » LIST2 Pattern Problem
Re: LIST2 Pattern Problem [message #2148 is a reply to message #2120] Mon, 22 June 2009 11:35 Go to previous messageGo to previous message
ajwid01 is currently offline  ajwid01
Messages: 26
Registered: June 2009
Location: UK
Junior Member
Sad

This is exactly what I tried to follow previously.

I think what maybe sidetracked me, is I was maybe expecting to at least SEE a where clause in the generated SQL, but that it would likely generate an error when parsed - to suggest that the column_name in the where clause was invalid.

In actual fact, for a reason I'm not following right now, the 'where' clause just doesn't get to the parse stage, as presumably some code logic recognises it as being an 'invalid' column prior to that.

If I'd seen a parse error, I would have known what was happening and then looked to see where I needed to tranlate it.

As I didn't see a parse error, I wasn't sure, and presumed there was something going wrong somewhere else.

Sad


I've attempted, as per someone else's suggestion, that a call to _cm_pre_getData should be placed within the inner table's class file like:


require_once 'std.table.class.inc';
class olap_delivery_notes3 extends Default_Table
{
    // ****************************************************************************
    function olap_delivery_notes3 ()
    {
        // save directory name of current script
        $this->dirname   = dirname(__file__);

        $this->dbms_engine = $GLOBALS['dbms'];
        $this->dbname      = 'warehouse';
        $this->tablename   = 'olap_delivery_notes3';

        // call this method to get original field specifications
        // (note that they may be modified at runtime)
        $this->fieldspec = $this->getFieldSpec_original();

    } // olap_delivery_notes3

    function _cm_pre_getData ($where, $where_array, $fieldarray=null){
	
        $where = str_replace('line_no=', 'order_line_no=', $where);

	return $where;
    }




// ****************************************************************************
} // end class
// ****************************************************************************


This doesn't seem to work for me though. The additional field still isn't picked up.

I'm presuming I just don't know how to write this bit of code, or where exactly to put it!

Hmm!
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Question about the session page stack
Next Topic: AUTO_INCREMENT PK Column for Oracle Table
Goto Forum:
  


Current Time: Sat May 11 16:13:00 EDT 2024

Total time taken to generate the page: 0.01143 seconds