SQLite Function that performs additional queries -


I have written a custom SQL function that changes a string because it is copied from one table to another. It's basic and its work has been good for a long time. The query looks like this: 

  Include in Table 2 (field 1) SELECT MYTRANSFORM (field2) to Table 2;

Now I need to modify the behavior of that function so that it can do a lookup on the second table and as a result, how the value can change. Is this possible? Has anyone done it successfully?

This is possible; You can execute other SQL queries from within your function, as long as you do not call your function repeatedly.


Comments

Post a Comment

Popular posts from this blog

c# - Reactive Extensions ControlScheduler -

Well, I'm using Reactive Extension Event Handler to handle my app events, I run the headlines on the Yuri thread. I also use ControlSubular for However, recently I am getting cross thread exception despite using control scheduler and I do not know what the problem is. Code: Observable.FromEventPattern & Lt; String & gt; (CC, "UiAlertMessage", New Control Session ()) Subscribe (_ = & gt; {Alert Control. (Show this language, title, _.EventArgs.UppercaseFirst ());}); The new control scheduler (this) is not to run the code on the UI control thread, so I do not get cross threading exceptions? you should do Observable.FromEventPattern & lt; String & gt; (CC, "UiAlertMessage"). AboveOption (this). Subscribe (_ = & gt; {Alert Control. (Show this language, Titles, _.EventArgs.UppercaseFirst ());}); This is the standard way of sending a scheduler related to specific controls. Passing control scheduler as you have got subsc...
Read more

ios - How to determine if NSLayoutConstraint is horizontal or vertical? -

It seems that this should be a simple task, but if a NSLayoutConstraint is a horizontal or vertical The obstacle? The only way to try to make this difference is by [constraint description]; Calling and then the resulting string "V:" or "H:" I want to find this information, because of I have around 2 similar restrictions which are prototype storyboard UITableViewCell , the only difference is that supervision is horizontal Describes the distance, and the second vertical. Any suggestion would be very helpful! Edit: I accepted the reply of Grimozoar because its interpretation is a great answer and the way I am working to parse the details, @ kongtomorrow I also want to give credit, answered me here! Thanks for the help! Here is the real code that I used to find the hindrance: NSArray * constraints = [bubble constraints]; (If ([[obstacle first item]], then e-mail: message labels] and [[barrier is second int.] Is aqual: bubble] and amp; a...
Read more

javascript - Enable/Disable form elements and changing the values of button at a time? -

requirement: text is a button with "disabled" when the page opens, then I want to disable it when the user clicks on button , I want to enable my form field and at the same time I want to change the value of my button to "enabled." I have an example of how the button's value, but how can I enable / disable it at the same time? & lt; H: form & gt; Please press this button & lt; H: command button id = "cb1" value = "# {ActionBean.buttonText}" instant = "true" functionalist = "# {ActionBean.processMyAction}" /> & Lt; / H: form & gt; My Bean class looks like this: / * action listener method * / public zeroes process my action (verb phenomenon) {disable =! Disable; System.out.println ("disable:" + disabled); If (buttonText.equals ("disable")) {buttonText = "enable"; System.out.println ("Button Type:" + Button); } Else {buttonText = "disable...
Read more