Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 23rd June 2003, 10:51
marselhober marselhober is offline
Member
 
Join Date: Jul 2002
Location: Indonesia
Posts: 32
marselhober is on a distinguished road
Question searching by a specific character

I want to search some data in a table that contains specific characters, for example :

in General Item Data, I want to search for Item Data that contains "EXP" characters.
The query results might be : "POT-0245-EXP", or "POT-7EXP-LCL" or "TEXP-0428-LCL"

Anybody knows what is the query/SQL syntax in BaaN to perform this searching ?
Reply With Quote
Sponsored Links
  #2  
Old 23rd June 2003, 11:48
NikeNiek's Avatar
NikeNiek NikeNiek is offline
Member
 
Join Date: Oct 2002
Posts: 31
NikeNiek is on a distinguished road
LIKE statement

You can use the LIKE statement in the query:

<field> like ".*EXP.*"

The .* means any character, zero or more times.
__________________
Niek
Reply With Quote
  #3  
Old 23rd June 2003, 13:34
rupertb's Avatar
rupertb rupertb is online now
Senior Member
 
Join Date: Jun 2002
Location: NY, USA
Posts: 192
rupertb is on a distinguished road
Baan: T2.2, BIVb2, BIVc4, Vc - DB: Oracle, INFORMIX, DB2, SQL - OS: AIX, WIN
Depending on the available keys and the number of records in the table you'd like to search you may have to choose the best path yourself. My solution is in the attached file. The document contains the source for two scripts one is a type 4 the other is a 3gl. In order to speed up the search (like didn't seem to work very well in our environment) I used the multiple server options - multithreading the tasks). This may not work on your system but it's worth a try - it really flies...
Note a custom table is required, if you need the definition gimme a shout.

Regards,
Rupert
Attached Files
File Type: doc quick_search.doc (12.5 KB, 38 views)
Reply With Quote
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
TSS problem - can't convert character karlovac Tools Administration & Installation 31 25th March 2008 10:42
Chinese character in BW Client ilipyc Tools Administration & Installation 2 9th September 2004 17:08
ISO-8889/1 Character table JosephA Tools Development 0 7th July 2004 21:49
Character in a string BaanTech Tools Development 4 4th March 2003 20:29
Selecting Specific Records. amarpreet Tools Development 5 8th January 2003 09:58


All times are GMT +2. The time now is 00:50.


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