hiiiii baan members,, i hav problem in generating the code for displaying the records where emp status is active ( domain bool),,,
here is the code

claration:

table tzaoes902 | Employess
extern domain zabool zaoes902.stat


|****************************** program section **************
functions:
function check.active()
{
select zaoes902.stat
From zaoes902
where zaoes902.stat = zastat.active
endselect
}



kindly help me out.... getting 302 error.. unknown column

hiiiii baan members,, i hav problem in generating the code for displaying the records where emp status is active ( domain bool),,,
here is the code

claration:

table tzaoes902 | Employess
extern domain zabool zaoes902.stat


|****************************** program section **************
functions:
function check.active()
{
select zaoes902.stat
From zaoes902
where zaoes902.stat = zastat.active
endselect
}



kindly help me out.... getting 302 error.. unknown column

Hello,

do not open such an old thread, please.
Create a new one !

302 ESQLSYNTAX - XXXXXXXX
Description:
This error indicates that the SQL syntax is not correct.


Regards

In this case Bernd is correct. This was a complete new topic and would deserve a new thread. In some cases where your problem actually matches the old thread then adding on is okay, most cases a new thread is needed.

In this case I would have to assume that zaoes902.stat is the actual table field. In that case I would change the code to look like this:

declaration:

table tzaoes902 | Employess


|****************************** program section **************
functions:
function check.active()
{
select zaoes902.stat
From zaoes902
where zaoes902.stat = zastat.active
selectdo
endselect
}

You would not need to declare the table column. I also always like to include selectdo, even though I know it is not needed in some cases.