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 |
ajwid01
Messages: 26 Registered: June 2009 Location: UK
|
Junior Member |
|
|
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.
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!
|
|
|
|
|
LIST2 Pattern Problem
By: ajwid01 on Thu, 18 June 2009 04:52
|
|
|
Re: LINK2 Pattern Problem
By: AJM on Thu, 18 June 2009 05:25
|
|
|
Re: LINK2 Pattern Problem
By: ajwid01 on Thu, 18 June 2009 05:58
|
|
|
Re: LINK2 Pattern Problem
By: AJM on Thu, 18 June 2009 06:17
|
|
|
Re: LINK2 Pattern Problem
By: ajwid01 on Thu, 18 June 2009 06:24
|
|
|
Re: LINK2 Pattern Problem
By: ajwid01 on Thu, 18 June 2009 07:19
|
|
|
Re: LINK2 Pattern Problem
By: AJM on Thu, 18 June 2009 09:36
|
|
|
Re: LINK2 Pattern Problem
By: ajwid01 on Thu, 18 June 2009 09:40
|
|
|
Re: LINK2 Pattern Problem
By: AJM on Thu, 18 June 2009 10:10
|
|
|
Re: LINK2 Pattern Problem
By: AJM on Mon, 22 June 2009 11:19
|
|
|
Re: LINK2 Pattern Problem
By: ajwid01 on Thu, 18 June 2009 09:52
|
|
|
Re: LINK2 Pattern Problem
By: AJM on Thu, 18 June 2009 10:19
|
|
|
Re: LINK2 Pattern Problem
By: ajwid01 on Thu, 18 June 2009 09:54
|
|
|
Re: LINK2 Pattern Problem
By: ajwid01 on Thu, 18 June 2009 10:30
|
|
|
Re: LINK2 Pattern Problem
By: ajwid01 on Thu, 18 June 2009 10:36
|
|
|
Re: LINK2 Pattern Problem
By: AJM on Thu, 18 June 2009 10:47
|
|
|
Re: LINK2 Pattern Problem
By: ajwid01 on Thu, 18 June 2009 11:01
|
|
|
Re: LINK2 Pattern Problem
By: AJM on Thu, 18 June 2009 11:44
|
|
|
Re: LINK2 Pattern Problem
By: ajwid01 on Thu, 18 June 2009 12:02
|
|
|
Re: LINK2 Pattern Problem
By: AJM on Thu, 18 June 2009 12:52
|
|
|
Re: LINK2 Pattern Problem
By: ajwid01 on Fri, 19 June 2009 08:40
|
|
|
Re: LIST2 Pattern Problem
By: AJM on Fri, 19 June 2009 09:11
|
|
|
Re: LIST2 Pattern Problem
By: ajwid01 on Fri, 19 June 2009 09:58
|
|
|
Re: LIST2 Pattern Problem
By: AJM on Fri, 19 June 2009 10:55
|
|
|
Re: LIST2 Pattern Problem
By: ajwid01 on Mon, 22 June 2009 09:30
|
|
|
Re: LIST2 Pattern Problem
By: AJM on Mon, 22 June 2009 09:51
|
|
|
Re: LIST2 Pattern Problem
By: ajwid01 on Mon, 22 June 2009 11:10
|
|
|
Re: LIST2 Pattern Problem
By: ajwid01 on Mon, 22 June 2009 11:35
|
|
|
Re: LIST2 Pattern Problem
By: ajwid01 on Mon, 22 June 2009 11:38
|
|
|
Re: LIST2 Pattern Problem
By: AJM on Mon, 22 June 2009 11:48
|
Goto Forum:
Current Time: Wed Nov 27 20:05:47 EST 2024
Total time taken to generate the page: 0.01383 seconds
|