الـجـروب الـخـاص بـالـمـنـتـدي Silkroad4arab Facebook | Official Group

**loaymoataz123** · 28-03-2017, 12:32 AM

دلوقتي انا شغال علي vsro dg 11 و كنت عاوز اضيف dg 12 مثلا
ازاي اخد الملفات من client تاني و احطها ف client vsro
و ازاي اعدل علي ال داتا وكل حاجه تتعلق ب ال dg اللي هضيفه

لو سمحتوا عاوز شرح كامل لاضافه اي Dg

ويريت لو ترفعولي الملفات الي اضيفها

جزاكم الله خير

**pop2009** · 28-03-2017, 04:54 AM

ديه كويري هتساعدك انك تفتح ال Items D12 & D13 في داتا بيز

كود:

UPDATE [dbo].[_RefObjCommon]
 SET Service = 1
 WHERE CodeName128 like '%ITEM_EU%'

 UPDATE [dbo].[_RefObjCommon]
 SET Service = 1
 WHERE CodeName128 like '%ITEM_CH%'

 UPDATE dbo._RefObjCommon
 SET Service = 0
 WHERE ID BETWEEN 8994 AND 9005

 UPDATE dbo._RefObjCommon
 SET Service = 0
 WHERE ID BETWEEN 9008 AND 9025

 UPDATE dbo._RefObjCommon
 SET Service = 0
 WHERE ID BETWEEN 9028 AND 9045

 UPDATE dbo._RefObjCommon
 SET Service = 0
 WHERE ID BETWEEN 9048 AND 9065

 UPDATE dbo._RefObjCommon
 SET Service = 0
 WHERE ID BETWEEN 9068 AND 9085

 UPDATE dbo._RefObjCommon
 SET Service = 0
 WHERE ID BETWEEN 9088 AND 9105

 UPDATE dbo._RefObjCommon
 SET Service = 0
 WHERE ID BETWEEN 9114 AND 9125

 UPDATE dbo._RefObjCommon
 SET Service = 0
 WHERE ID BETWEEN 9134 AND 9145

 UPDATE dbo._RefObjCommon
 SET Service = 0
 WHERE ID BETWEEN 9154 AND 9225

 UPDATE dbo._RefObjCommon
 SET Service = 0
 WHERE ID = 38620

**loaymoataz123** · 28-03-2017, 05:24 AM

تمام طيب الملفات بقي اللي هحطها ف ال media وdatabase

وطريقه بعد ازنك

**Dev.Klito** · 28-03-2017, 10:29 AM

اقتباس:

المشاركة الأصلية كتبت بواسطة pop2009

ديه كويري هتساعدك انك تفتح ال Items D12 & D13 في داتا بيز

كود:

UPDATE [dbo].[_RefObjCommon]
 SET Service = 1
 WHERE CodeName128 like '%ITEM_EU%'

 UPDATE [dbo].[_RefObjCommon]
 SET Service = 1
 WHERE CodeName128 like '%ITEM_CH%'

 UPDATE dbo._RefObjCommon
 SET Service = 0
 WHERE ID BETWEEN 8994 AND 9005

 UPDATE dbo._RefObjCommon
 SET Service = 0
 WHERE ID BETWEEN 9008 AND 9025

 UPDATE dbo._RefObjCommon
 SET Service = 0
 WHERE ID BETWEEN 9028 AND 9045

 UPDATE dbo._RefObjCommon
 SET Service = 0
 WHERE ID BETWEEN 9048 AND 9065

 UPDATE dbo._RefObjCommon
 SET Service = 0
 WHERE ID BETWEEN 9068 AND 9085

 UPDATE dbo._RefObjCommon
 SET Service = 0
 WHERE ID BETWEEN 9088 AND 9105

 UPDATE dbo._RefObjCommon
 SET Service = 0
 WHERE ID BETWEEN 9114 AND 9125

 UPDATE dbo._RefObjCommon
 SET Service = 0
 WHERE ID BETWEEN 9134 AND 9145

 UPDATE dbo._RefObjCommon
 SET Service = 0
 WHERE ID BETWEEN 9154 AND 9225

 UPDATE dbo._RefObjCommon
 SET Service = 0
 WHERE ID = 38620

اقتباس:

المشاركة الأصلية كتبت بواسطة loaymoataz123

تمام طيب الملفات بقي اللي هحطها ف ال media وdatabase

وطريقه بعد ازنك

استخدم الــ query اللى فوق دى هتظبط الداتا و البرنامج دا هيجبلك سطور كل حاجة للمديا

https://mega.nz/#!SF8wDCYA!NjawmNo0m...CXN1KljFukpwfk

يغلق بسبب وجود موضوع اخر غير مجاب ...

##

يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)

	تسجيل الدخول دائمآ