Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Administration & Installation

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 22nd April 2012, 07:44
priyanka pawar's Avatar
priyanka pawar priyanka pawar is offline
Junior Member
 
Join Date: Feb 2012
Posts: 19
priyanka pawar is on a distinguished road
Baan: FP7 - DB: SQl Server R2 - OS: window
Question comparison enum value in query
Baan: ERP LN 6.1 FP7
DB: SQL Server 2008 R2
OS: Windows XP
C/S: Both

I want to write query in that i want to add condition on enum field.
How to compare enum value in query ?

Kindly provide syntax as soon as possible.
Reply With Quote
  #2  
Old 22nd April 2012, 10:55
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,639
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
use etol

Quote:
Originally Posted by priyanka pawar View Post
I want to write query in that i want to add condition on enum field.
How to compare enum value in query ?

Kindly provide syntax as soon as possible.
Hello,

etol()
Syntax:

function long etol (domain domain_value)

Description

This returns the numeric code corresponding to a specified value in an enumerated domain.

Arguments

domain domain_value The name of the domain. The domain must be of type enumerated.


Context

This function can be used in all script types.

Regards
__________________
//Bernd
Reply With Quote
  #3  
Old 23rd April 2012, 16:41
JaapJD's Avatar
JaapJD JaapJD is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 728
JaapJD will become famous soon enoughJaapJD will become famous soon enough
Baan: BaanIV, BaanERP, ERP LN 6.1 - DB: Oracle, SQL Server - OS: Unix, Windows
Example
Code:
where tablefield = tcyesno.yes
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Usen enum in Query Jordi.Tolra Tools Development 2 15th February 2007 13:45
enum related query REETA1967 Tools Development 2 15th February 2003 17:27


All times are GMT +2. The time now is 23:21.


©2001-2017 - Baanboard.com - Baanforums.com