Development Tools Forum

Re: Table issue coming up while compilation

Posted By: Ravi Pasupuleti
Date: Friday, 15 January 2010, at 10:21 a.m.

In Response To: Re: Table issue coming up while compilation (Keith Simmons)

Yes....the pcp_no column does not throw an error.
the output of 'dbschema -d clientbenaso -t codes' shows the two columns
char_value and code_834. Yet the compiler is flagging that column code_834
is not present.
and 'dbschema -d clientbenaso -t emp_hlth_ben' does show the column pcp_no
and it is not an issue.

For a change when the first statement in the sample code is changed to
'Database clientbenaso", that is pointing to the database there the 'codes'
table is, there is no compiler error. But we want to use the statement '
database client' as we want to access the 'client' database too.

Thank you,
Ravi P

On Fri, Jan 15, 2010 at 6:28 PM, Keith Simmons <smiley73@googlemail.com>wrote:

> 2010/1/15 K CHANDRA <chandra.kala00@gmail.com>:
> > There is a table clientbenaso:codes it does have the columns char_value
> and
> > code_834. But the compiler is not recognizing the columns and flagging
> them
> as
> > not present. To explain the problem I wrote a small piece of code.
> >
> > database client
> > main
> > define
> >
> > pcp_no like clientbenaso:emp_hlth_ben.pcp_no,
> >
> > dtp01_0 like clientbenaso:codes.code_834,
> >
> > dtp01_1 like clientbenaso:codes.code_834
> > end main
> >
> > The compiler is flagging that code_834 is not a column in the database.
> >
> > Thank you,
> > Chandra Kala.
> >
> >
> >
>
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> Chandra
>
> I assume the pcp_no column does not throw an error.
> What does the output of 'dbschema -d clientbenaso -t codes'
> and 'dbschema -d clientbenaso -t emp_hlth_ben' show?
>
> Keith
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--
Ravi P
bayLogic Technologies

--00163649918b6e9c6e047d358d99

Messages In This Thread

• Table issue coming up while compilation
  K CHANDRA -- Friday, 15 January 2010, at 7:30 a.m.
  • Re: Table issue coming up while compilation
    Keith Simmons -- Friday, 15 January 2010, at 7:58 a.m.
    • Re: Table issue coming up while compilation
      Ravi Pasupuleti -- Friday, 15 January 2010, at 10:21 a.m.
      • Re: Table issue coming up while compilation
        Keith Simmons -- Friday, 15 January 2010, at 10:45 a.m.
        • Re: Table issue coming up while compilation
          Ravi Pasupuleti -- Friday, 15 January 2010, at 11:29 a.m.
          • Re: Table issue coming up while compilation
            Keith Simmons -- Friday, 15 January 2010, at 11:45 a.m.
          • Re: Table issue coming up while compilation
            Art Kagel -- Friday, 15 January 2010, at 12:47 p.m.
            • Re: Table issue coming up while compilation
              Ravi Pasupuleti -- Friday, 15 January 2010, at 1:09 p.m.
      • Re: Table issue coming up while compilation
        Art Kagel -- Friday, 15 January 2010, at 10:51 a.m.
        • Re: Table issue coming up while compilation
          Ravi Pasupuleti -- Friday, 15 January 2010, at 11:36 a.m.

Development Tools Forum is maintained by Administrator with WebBBS 5.12.