RE: [development-axapta] variable in sql statement

[Holger K. Pedersen]

void funcWhatever(EmplId _emplId)
{
  EmplTable emplTable;
  ;
  while select emplTable where emplTable.EmplId == _emplId
  {
     // looping through table
     info(strfmt("%1",emplTable.EmplId));
  }
}

Try somthing like this.

:-)

From: "Agus Riyadi" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: <[EMAIL PROTECTED]>
Subject: [development-axapta] variable in sql statement
Date: Tue, 2 Dec 2003 16:22:40 +0700
Hi all,

Why can't I use variable when using where expression in select statement
?
It always display this error message :
"Container and unbound string (text) fields are not allowed here in  a
WHERE expression"
I did something like " select empltable where emplId == aVariable "
Anyone have suggestion ?
Regards,
agus
_________________________________________________________________
Få alle de nye og sjove ikoner med MSN Messenger http://messenger.msn.dk/


Yahoo! Groups Sponsor	 
ADVERTISEMENT
click here	
	

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.