mibuso.com

Microsoft Business Solutions online community
It is currently Sat Oct 25, 2014 8:17 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Search/replace a boolean field
PostPosted: Tue Apr 24, 2012 12:20 pm 
Offline

Joined: Tue Jun 21, 2011 1:39 pm
Posts: 570
Country: Netherlands (nl)
I've found this by accident while renaming,renumbering fields

You can't search and replace on a Checkbox

> Export the form with the checkbox to .txt
> Edit the .txt and change ;CheckBox; to ;TextBox;
> Import the .txt and compile

and now you have a Yes/No field and .. search/replace works

ps.
I have seen this done without a .txt file too. Please let me know how?


Top
 Profile E-mail  
 
 Post subject: Re: Search/replace a boolean field
PostPosted: Wed Apr 25, 2012 2:26 pm 
Offline

Joined: Tue Jun 21, 2011 1:39 pm
Posts: 570
Country: Netherlands (nl)
hehumm :)

> in CA/L just add a text field to a form
> change the source expression to a boolan field


Top
 Profile E-mail  
 
 Post subject: Re: Search/replace a boolean field
PostPosted: Fri Jun 22, 2012 2:33 pm 
Offline

Joined: Fri Jun 22, 2012 1:13 pm
Posts: 1
Country: Germany (de)
In this case i would create a report with the record as the dataitem and set a tableview to change only selected records. After it, you can easily write two line code in OnAfterGetRecord:

BooleanField := TRUE/FALSE;
MODIFY;

Press Strg+r and run the report. This ist much more effectiv.


Top
 Profile E-mail  
 
 Post subject: Re: Search/replace a boolean field
PostPosted: Fri Jun 22, 2012 4:06 pm 
Offline

Joined: Tue Jun 21, 2011 1:39 pm
Posts: 570
Country: Netherlands (nl)
Yesterday I spend 15 minutes explaning the customer to use ctrl+Home key. Not realising in German this is called Strg+Home. :)


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: