topic Re: VIEW Error in Application Development and Automation Discussions

VIEW Error

vallamuthu_madheswaran2 — Tue, 21 Aug 2007 09:18:13 GMT

Hi Friends,

I am creating a VIEW in combination of 3 HR Tables.

in selection condition i am using PAYGRUP GE '120' but it fetch all the data

PAYGRUP CHAR 8.

KINDLY HELP ME.

Thanks & Regards,

Vallamuthu.M

Former Member — Mon, 10 Sep 2007 13:54:05 GMT

The condition is okay since your operand is within quotes ( character handling).

you may have to check if there is a inner-join needed for the right data.

Thanks.

Former Member — Tue, 11 Sep 2007 03:56:35 GMT

Hi ,

for you creation you must be logically correct ,

example is

table1.

table2,

table 3, -> this table is having Paygroup .

then in the view .

table order should be

table3,
table1 or table2  based  on the  next  select  Condition , then 
table 1 or table2  which ever  is left .

so that in the join

first

table3-field1  =  table1-field1.
table3-paygroup = table1-paygroup. 
table3-paygroup = table2-paygroup.

try this ,

Reward points if it is usefull .....

Girish