# SETRANGE non filter !!

**URL:** <https://www.dynamicsuser.net/t/setrange-non-filter/16955>\
**Category:** Developers Forum\
**Created:** [June 19, 2007, 4:04am UTC](https://www.dynamicsuser.net/t/setrange-non-filter/16955 "2007-06-19T04:04:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Carlos\_Cosme](https://avatars.discourse-cdn.com/v4/letter/c/4bbf92/32.png) [@Carlos\_Cosme](https://www.dynamicsuser.net/u/Carlos_Cosme)\
**Post date:** [June 19, 2007, 4:04am UTC](https://www.dynamicsuser.net/t/setrange-non-filter/16955/1 "2007-06-19T04:04:13Z")

</div>

Back again,

ITEMS USED:  
Table “Item Ledger Entry”(32), with the records:

| Document No. | Serial No. |
| --- | --- |
| A0001 | 0 |
| A0020 | SN0001 |

Record var (rec32)

CODE USED:  
rec32.SETRANGE(“Serial No.”, SN0001);  
message(‘value:%1’, rec32.“Documento No.”); //this prints “A0001” and don’t know why…

I’ve tried restarting the record with rec32.FIND(’-’) but nothing different appears. What am I doing wroong?, i used this function before and had no problem… [:’(]

---

<div class="post-metadata">

**Author:** ![nunomaia](https://avatars.discourse-cdn.com/v4/letter/n/f9ae1b/32.png) [@nunomaia](https://www.dynamicsuser.net/u/nunomaia)\
**Post date:** [June 19, 2007, 4:49am UTC](https://www.dynamicsuser.net/t/setrange-non-filter/16955/2 "2007-06-19T04:49:58Z")

</div>

you forgot to use FIND

---

<div class="post-metadata">

**Author:** ![phenomenon](https://avatars.discourse-cdn.com/v4/letter/p/9fc348/32.png) [@phenomenon](https://www.dynamicsuser.net/u/phenomenon)\
**Post date:** [June 19, 2007, 4:52am UTC](https://www.dynamicsuser.net/t/setrange-non-filter/16955/3 "2007-06-19T04:52:05Z")

</div>

You have to add rec32.FIND(’-’) AFTER SETRANGE line.

rec32.SETRANGE(“serial No.”, ‘SN0001’);  
rec32.FIND(’-’);  
MESSAGE(bla bla);

With some notices:  
First, you need single-quotes on SN0001  
Second, never execute FIND without error trapping IF FIND

---

<div class="post-metadata">

**Author:** ![Carlos\_Cosme](https://avatars.discourse-cdn.com/v4/letter/c/4bbf92/32.png) [@Carlos\_Cosme](https://www.dynamicsuser.net/u/Carlos_Cosme)\
**Post date:** [June 20, 2007, 12:42am UTC](https://www.dynamicsuser.net/t/setrange-non-filter/16955/4 "2007-06-20T00:42:41Z")

</div>

Oooohhhhh,

I didn’t forgot the FIND line but I put it before. I’ll start to use the error trapping too, thanks !!! [;)]