Jump to content

Searching this query...


Recommended Posts

12 minutes ago, iMerv3 said:

The error is clearly understable. But whatever run this

  Hide contents

update item_proto_translated set locale_name="noname" where locale_name='';

 

I removed NOT NULL from item_proto and your first query worked.

This error , i think it was because some vnums from item_proto , does not exist on item_proto translated.

 

How can i fix it with query to go to next vnum that exists? i mean, to search ONLY the vnums which exist on both table. If the vnum does not exist on one or other table, move to other vnum

Link to comment
Share on other sites

12 minutes ago, iMerv3 said:

ah okay

  Hide contents

update item_proto set locale_name=coalesce((select locale_name from item_proto_translated where vnum=item_proto .vnum), 'noname');


 

this put "noname" at the vnums which not exist. how can i leave them like they are ? i mean not translated and without noname? sorry...

Link to comment
Share on other sites

16 minutes ago, iMerv3 said:

😀

  Hide contents

update item_proto set locale_name=coalesce((select locale_name from item_proto_translated where vnum=item_proto .vnum), item_proto.locale_name);

 

Thats it... thanks a lot for your time man. Appreciate it.

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.