Tutorial by Examples: l

update <SCHEMA_NAME>.<TABLE_NAME_1> AS A SET <COLUMN_1> = True FROM <SCHEMA_NAME>.<TABLE_NAME_2> AS B WHERE A.<COLUMN_2> = B.<COLUMN_2> AND A.<COLUMN_3> = B.<COLUMN_3>

To check the list of loaded packages search() OR (.packages())

Model With EF Core, data access is performed using a model. A model is made up of entity classes and a derived context that represents a session with the database, allowing you to query and save data. You can generate a model from an existing database, hand code a model to match your database, or ...

Standard Version To install the standard version, go to the Plugin section of your WordPress installation. Search for "Advanced Custom Fields" and install/activate. You will now have access to a new area in the WordPress administrative area labeled "Custom Fields" where you can ...

<?php echo get_field('my_field_name'); ?> This will echo the value of the field "my_field_name" from the current post.

<?php echo get_field('my_field_name', 123); ?> This will echo the value of "my_field_name" from the post with 123 as its ID.

<?php echo get_field('my_field_name', 'option'); ?> This will echo the value of "my_field_name" from the options page created via ACF.

<?php if( get_field('my_field_name') ){ ?> <?php echo get_field('my_field_name'); ?> <?php }; ?> This will only show the field if content exists depending on content type (i.e., an image is uploaded to the field, text is entered, it is selected, etc.).

Fabric.js is just like any other JS library just specific to canvas. Easy to setup and get started. All you need to do is download the fabric.js from HERE and include it in your project just like any other JS library for example the way you do it for jQuery. Then create the html file suppose index.h...

First of all we need to add MEDIA_ROOT and MEDIA_URL to our settings.py file MEDIA_ROOT = os.path.join(BASE_DIR, 'media') MEDIA_URL = '/media/' Also here you will work with ImageField, so remember in such cases install Pillow library (pip install pillow). Otherwise, you will have such error: I...

The setCustomTitle() method of AlertDialog.Builder lets you specify an arbitrary view to be used for the dialog title. One common use for this method is to build an alert dialog that has a long title. AlertDialog.Builder builder = new AlertDialog.Builder(context, Theme_Material_Light_Dialog); buil...

To read an atom's value, simply put the name of the atom, with a @ before it: @counter ; => 0 A bigger example: (def number (atom 3)) (println (inc @number)) ;; This should output 4

There are two commands to change an atom, swap! and reset!. swap! is given commands, and changes the atom based on its current state. reset! changes the atom's value completely, regardless of what the original atom's value was: (swap! counter inc) ; => 1 (reset! counter 0) ; => 0 This e...

import javax.swing.JFrame; import javax.swing.SwingUtilities; import javax.swing.WindowConstants; public class Main { public static void main(String[] args) { SwingUtilities.invokeLater(() -> { JFrame frame = new JFrame("Hello World!"); frame...

Using java.lang.Runnable we make our "Hello World!" example available to Java users with versions dating all the way back to the 1.2 release: import javax.swing.JFrame; import javax.swing.SwingUtilities; import javax.swing.WindowConstants; public class Main { public static void ...

Dim cars Dim filefullname : filefullname = "C:\testenv\test.txt" 'If you can, create an instaneous read for text file data for better memory handling. 'Unless it's a large file and that's impossible. cars = Split(CreateObject("Scripting.FileSystemObject").OpenTextFile(filefu...

You cannot alter the array's contents through the loop variable because it's a temporary each element is being assigned to. Dim cars(2) 'collection of different cars Dim trace 'track iteration details cars(0) = "Ford" cars(1) = "Audi" cars(2) = "Prius" For Each ca...

Dim i, cars(2) cars(0) = "Ford" cars(1) = "Audi" cars(2) = "Prius" For i=0 to ubound(cars) If cars(i) = "Audi" Then Exit For Next

Dim x, cars x = 0 cars = Split(CreateObject("Scripting.FileSystemObject").OpenTextFile("C:\testenv\example.txt", 1).ReadAll, vbcrlf) Do While x < ubound(cars) If cars(x) = "Audi" Then Exit Loop x = x + 1 Loop

Dim copycars(), cars(2), x Redim copycars(0) x = 0 cars(0) = "Ford" cars(1) = "Audi" cars(2) = "Prius" Do Until x = ubound(cars) copycars(ubound(copycars)) = cars(x) redim preserve copycars(ubound(copycars)+1) x = x + 1 Loop redim preserve copycar...