# SQL String Fremdlager -\> Standard

**URL:** <https://forum.oxid-esales.com/t/sql-string-fremdlager-standard/96872>\
**Category:** Deutsches Forum\
**Tags:** development, datenbank, sql\
**Created:** [July 13, 2020, 7:45am UTC](https://forum.oxid-esales.com/t/sql-string-fremdlager-standard/96872 "2020-07-13T07:45:56Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![andoreen](https://forum.oxid-esales.com/user_avatar/forum.oxid-esales.com/andoreen/32/67_2.png) [@andoreen](https://forum.oxid-esales.com/u/andoreen)\
**Post date:** [July 13, 2020, 7:45am UTC](https://forum.oxid-esales.com/t/sql-string-fremdlager-standard/96872/1 "2020-07-13T07:45:56Z")

</div>

Hallo, hat jemand einen funktionierenden SQL String für die 6.1 CE mit dem ich global alle Artikel von Fremdlager auf Standard inklusive Varianten ändern kann? Bedanke mich im voraus.

---

<div class="post-metadata">

**Author:** ![patchwork.de](https://forum.oxid-esales.com/user_avatar/forum.oxid-esales.com/patchwork.de/32/324_2.png) [@patchwork.de](https://forum.oxid-esales.com/u/patchwork.de)\
**Post date:** [July 13, 2020, 8:32am UTC](https://forum.oxid-esales.com/t/sql-string-fremdlager-standard/96872/2 "2020-07-13T08:32:42Z")

</div>

update oxarticles set oxstockflag = 1 where oxstockflag = 4

PS: zum testen:  
select \* from oxarticles where oxstockflag = 4

---

<div class="post-metadata">

**Author:** ![andoreen](https://forum.oxid-esales.com/user_avatar/forum.oxid-esales.com/andoreen/32/67_2.png) [@andoreen](https://forum.oxid-esales.com/u/andoreen)\
**Post date:** [July 13, 2020, 1:43pm UTC](https://forum.oxid-esales.com/t/sql-string-fremdlager-standard/96872/3 "2020-07-13T13:43:56Z")

</div>

Super, danke! Hat geklappt.

---

<div class="post-metadata">

**Author:** ![system](https://forum.oxid-esales.com/user_avatar/forum.oxid-esales.com/system/32/4245_2.png) [@system](https://forum.oxid-esales.com/u/system)\
**Post date:** [July 13, 2021, 1:44pm UTC](https://forum.oxid-esales.com/t/sql-string-fremdlager-standard/96872/4 "2021-07-13T13:44:00Z")

</div>

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.