- Where Developers Learn, Share, & Build Careers


I can choose which fields in my table are updated by the stored procedure based on the value of the input parameters has gone. If the input field is equal to 'draft', then it should update id_draft , otherwise it should update id . Is this possible?

This is one of my failed attempts which can explain what I want to do: 

  Create or change process SP_test (input_field VARCHAR defaults NULL) Issue of the IS BEGIN update table set when input_field = 'draft' then the id_draft ELSE id = 'X'    
 
 
 You can not use the CASE statement to change the query structure itself, it only gives first, this is a function.  
 You must have either <<>> id_draft ELSE id END ) in   value   if the input_field = 'draft' Code> id  field or  id_draft  field. It is like doing this ...  
  Update your Tables STT case when 'abc' = 'draft' then 123 ELSE 789 END = 'x'   
 Instead, you have to enter the CAS statement from the right hand side ...  
  Update your own ATT ID = case when input_field = 'draft' then idE 'ELSE' end, id_draft = Enter Input_field = 'draft' THEN 'x' ELSE id_draft END   
 But, in fact, you can be better off doing this ...  
  if (input_field = 'draft Update your TABEt id_draft = 'x' ELSE Update your table SET id = 'x'   
  Edit: *   
 To use a value from another table instead of just  'x' , you can use something like this ...  
  your Table SET ID = Update the case when input_field = 'draft' then yourTable.id ELSE otherTable.x END, id_draft = case when input_file = 'draft' then other. Table.x ELSE yourTable.id_draft other than ENDTable where otherTable.a =? And otherTable.b =?

Comments

Post a Comment

Popular posts from this blog

Python SQLAlchemy：AttributeError: Neither 'Column' object nor 'Comparator' object has an attribute 'schema' -

I tried to create a new database in my project, but when I run the script, I get this error, I have another project, this type of definition worked before, but now it gets a single error. I am using Python 2.7.8 and the version of SQLAlchemy module is 0.9.8. By the way, using a project flask- SQLAlchemy, it works well, I'm confused. Traceback information is as follows: Traceback (most recent call final): File "D: / Projects / IOM / db_create.py", line 4, & lt; Module & gt; From the models the base file "D: \ Projects \ OO-IM \ models.py", in line 15, in the & lt; Module & gt; Column ( 'followed_id', int (), ForeignKey ( 'user.id')) file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ schema.py", line 369, __new__ schema = metadata. Schema file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ elements.py", line 662, AttributeError in __getattr__ key): Neither 'column' object nor ...
Read more

java - How not to audit a join table and related entities using Hibernate Envers? -

I use Eners to be hibernate to audit my institutions. I have an audit entity, Foo , which includes a list & lt; Bars & gt; However, I do not want to audit the bar institutions, in the form of properties, I have written that: @inti @edicated public class Foo {@JoinTable (name = "T_FOO_BAR", joinColumns = @JoinColumn (name = "FOO_ID"), inverseJoinColumns = @JoinColumn (Name = "BAR_ID")) @ManyToMany (Cascade = Persist) @ Indited (targetAuditMode = RelationTargetAuditMode.NOT_AUDITED ) Public listing & lt; Bars & gt; GetBars () {Return bars; }} Now, I want to retrieve an amendment of foo : AuditReader reader = AuditReaderFactory.get (GetEntityManager ()); FU modification = (FU) reader.CreativeTeA () .entensEtrevision (Foo Class, 42) .getSingleResult (); Unfortunately, when I want to retrieve all the data (i.e. when it loads lazy times ), error me ORA-00942: table or view is not present , because Tried to query this: Sel...
Read more

mongodb - CakePHP paginator ignoring order, but only for certain values -

While pagging my user model in kppp, I can sort with some values, but not others. For example, I can order results from created or email , for example, but username or reputation seems to come back order by arbitrary command for example with a list of users: $ this-> paginate = array ('condition' => array ( 'User.is_active' = & gt; true), 'border' => 24, 'order' => array ('User.created' => DESC)); Works as expected, but $ this - & gt; Paged = array ('conditions' = & gt; array (' user.isIactive '= & gt; true),' border '= & gt; 24,' command '= & gt; array (' user repeats' = ' & Gt; DESC ')); No, no. I first thought that this could be a database issue, but when I search the database directly, sorted as expected. Note: I am using Mangodebi with the Mongo DB plugin of Ichikawa for the KPPHP; Pagnetizing users are used to work properl...
Read more