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

User login

Frontpage Sponsor


Google search

How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 4

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 23rd June 2003, 09:51
marselhober marselhober is offline
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
Old 23rd June 2003, 10:48
NikeNiek's Avatar
NikeNiek NikeNiek is offline
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.
Reply With Quote
Old 23rd June 2003, 12:34
rupertb's Avatar
rupertb rupertb is offline
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.

Attached Files
File Type: doc quick_search.doc (12.5 KB, 39 views)
Reply With Quote
Sponsored Links

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 09:42
Chinese character in BW Client ilipyc Tools Administration & Installation 2 9th September 2004 16:08
ISO-8889/1 Character table JosephA Tools Development 0 7th July 2004 20:49
Character in a string BaanTech Tools Development 4 4th March 2003 19:29
Selecting Specific Records. amarpreet Tools Development 5 8th January 2003 08:58

All times are GMT +2. The time now is 14:32.

©2001-2018 - -