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
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 20th July 2010, 08:27
ian_j_albert ian_j_albert is offline
Member
 
Join Date: Jun 2010
Posts: 32
ian_j_albert is on a distinguished road
Baan: BAAN 6.1 - DB: MSSQL - OS: MS Server
Writing Export Conditions
Baan: ERP LN 6.1 FP5
C/S: Both

Hi Guys,

I've been testing out Exchange with Export Conditions. I'm having some issues and I'm not sure what is going on. this is with LN 6.1

I am trying to export out stuff from Activities (tdsmi200) table.
I can use the following script

IF
tdsmi200.bpid > "BPG000000"
AND
tdsmi200.bpid < "BPG999999"
THEN
test = true
ELSE
test=false
ENDIF
return(test)

Now this works fine. What I am actually need to do is to pull data of the tdsmi200.cact field which is the activity name. Basically the script below is used. I get no output. I am not able to retrieve data from any fields that is a string type. the activity table has a field that uses UTC (numeric) and I am able to pull out data from here... It seems that strings are giving an odd problem.

IF
tdsmi200.cact = "DEMO"
THEN
test = true
ELSE
test=false
ENDIF
return(test)

Would appreciate any help on this on how to create conditions for string fields.

Last edited by ian_j_albert : 20th July 2010 at 08:36.
Reply With Quote
Sponsored Links
  #2  
Old 20th July 2010, 08:41
ian_j_albert ian_j_albert is offline
Member
 
Join Date: Jun 2010
Posts: 32
ian_j_albert is on a distinguished road
Baan: BAAN 6.1 - DB: MSSQL - OS: MS Server
Found out the issue...

the tdsmi200.cact field has a lenght of 8 characters. I had to use "DEMO " which must have a total 8 characters . Now is there any other way to do this because I would find it weird having to always ensure that my condition for strings must always be the entire lenght of the field inclusive of spaces.

Last edited by ian_j_albert : 20th July 2010 at 08:53.
Reply With Quote
  #3  
Old 20th July 2010, 10:20
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 a string operation

Quote:
Originally Posted by ian_j_albert View Post
Found out the issue...

the tdsmi200.cact field has a lenght of 8 characters. I had to use "DEMO " which must have a total 8 characters . Now is there any other way to do this because I would find it weird having to always ensure that my condition for strings must always be the entire lenght of the field inclusive of spaces.
Hello,

use a string operation like:

IF
strip$(tdsmi200.cact) = "DEMO"
THEN
test = true
ELSE
test=false
ENDIF
return(test)

From LN prog guide :

String operations synopsis
string concat$() ( string separator, expr, ... )
boolean isdigit() ( string_expr )
boolean isspace() ( string_expr )
long len() ( string_expr )
long len.in.bytes() ( string_expr )
long load.byte() ( string record(long spos) )
double load.double() ( string record(long spos) [, long endian] )
double load.float() ( string record(long spos) [, long endian] )
long load.long() ( string record(long spos) [, long endian] )
long load.short() ( string record(long spos) [, long endian] )
long lval ( string_expr )
void not.fixed() ( string string_var(.) )
long pos(), rpos() ( string source(.), string pattern(.) )
long pos(), rpos() ( string source(.), string pattern(.) )
long set.strip.mode ( long table_id, long mode )
long set.symbol.strip.mode ( ref string str, long mode )
string shiftc$(), shiftl$(), shiftr$() ( string strg(.) )
string shiftc$(), shiftl$(), shiftr$() ( string strg(.) )
string shiftc$(), shiftl$(), shiftr$() ( string strg(.) )
void store.byte() ( long lng, ref string rec )
void store.double() ( double dbl, ref string rec )
void store.float() ( double dbl, ref string rec )
void store.long() ( long lng, ref string rec )
void store.short() ( long lng, ref string rec )
string str$() ( num_expr )
string string.set$() ( string_expr, num_expr )
string strip$() ( string strg(.) )
string tolower$(), toupper$() ( string_expr )
string tolower$(), toupper$() ( string_expr )
string trim$() ( string_expr )
string quoted.string() ( string_expr )

long tt.align.according.domain() ( string string_in(.), ref string string_out(), string domain_name )
double val ( string_expr )


Regards
__________________
//Bernd

Last edited by bdittmar : 20th July 2010 at 13:27. Reason: Mark's hint
Reply With Quote
  #4  
Old 20th July 2010, 13:15
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,905
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
I think he meant strip$(tdsmi200.cact) = "DEMO", but did not think I should edit his post.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #5  
Old 22nd July 2010, 07:30
ian_j_albert ian_j_albert is offline
Member
 
Join Date: Jun 2010
Posts: 32
ian_j_albert is on a distinguished road
Baan: BAAN 6.1 - DB: MSSQL - OS: MS Server
Thanks for the information Mark.

I'll give this ago.. I got sidetrack from this for a bit.
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
Exchange Export von Projekten(Cust. Admin.) und Patches mit Audit Baanie Deutsches Forum 4 9th March 2005 11:09
Export Schema condition moadel Tools Administration & Installation 1 6th September 2004 06:23
writing a log file from a Unix script pjohns Operating Systems & Databases 8 11th April 2003 21:52


All times are GMT +2. The time now is 03:13.


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