Re: Doing subfiles in Net.Data

[Peter Vidal <Peter_Vidal@xxxxxxxx>]

Matt:

I followed your advise and started to work with this example 
(http://www.ignite400.org/cgi-dta/bcbk_start_row.mac/start), however, 
after revising/changing file names and table headings and %row definition, 
I got this:

NET.DATA DTW_SQL Error: Function count: 
The statement failed. Qualified object name DUPITMWRKM not valid. 
(SQLSTATE 42833, SQLCODE -5016) 

The function called is:
@Query(table2)

Table1 and Table 2 are defined in the DEFINE% section as:
table1 = %TABLE
table2 = %TABLE

the function has the SQL and the file referenced is valid as well as the 
library:
%FUNCTION(DTW_SQL) Query(t2){
   select NITEM, TIM, DEL, SD, PBI, PPR, WH, DUPLICATES 
   from WHCON/DUPITMWRKM
   order by nitem

Any clues?


PETER VIDAL 
MAPICS IT TECHNICAL SUPPORT TEAM / SR SYSTEM ANALYST 
10540 Ridge Rd., Suite 203, New Port Richey, FL 34654-5111
Tel:727-849-9999, x2414 Fax:727-815-3120
WWW.PALL.COM 

"The wisest mind has something yet to learn."
George Santayana (1863 - 1952)

--------------------------------------------------------------------------------

Attention:

This communication may contain information that is confidential,
privileged and/or exempt from disclosure under applicable law.  
If you are not the intended recipient, please notify the sender 
immediately and delete the original, all attachments, and all 
copies of this communication.


--------------------------------------------------------------------------------