Tutorial by Examples: table

In order to access or alter an index on a table, you need to somehow place the table into the stack. Let's assume, for this examples that your table is a global variable named tbl. Getting the content at a particular index: int getkey_index(lua_State *L) { lua_getglobal(L, "tbl"); ...

//create a new ExcelPackage using (ExcelPackage excelPackage = new ExcelPackage()) { //create 2 WorkSheets. One for the source data and one for the Pivot table ExcelWorksheet worksheetPivot = excelPackage.Workbook.Worksheets.Add("Pivot"); ExcelWorksheet worksheetData = exc...

CREATE TABLE myschema.tableNew AS ( SELECT * FROM myschema.tableOld ) WITH DATA

CREATE TABLE myschema.tableNew AS ( SELECT * FROM myschema.tableOld ) WITHOUT DATA

CREATE TABLE myschema.tableNew AS ( SELECT * FROM myschema.tableOld WHERE column1 = 'myCriteria' ) WITH DATA

First, you need to prepare the environment by creating the SQL Server table and the CSV file. Run the script below in SQL Server to create the SQL table either on a new database or an existing one. For this example, I used my ‘TrainingDB’ database. /* Creates table for Students.csv */ CREATE TABL...

import SpriteKit import UIKit class GameRoomTableView: UITableView,UITableViewDelegate,UITableViewDataSource { var items: [String] = ["Player1", "Player2", "Player3"] override init(frame: CGRect, style: UITableViewStyle) { super.init(frame: frame, s...

The source code can be cloned or downloaded from GitHub to test it. node('iOS Node') { stage('Checkout/Build/Test') { // Checkout files. checkout([ $class: 'GitSCM', branches: [[name: 'master']], doGenerateSubmoduleConfigurations: fa...

UIRefreshControl *refreshControl = [[UIRefreshControl alloc] init]; [refreshControl addTarget:self action:@selector(pullToRefresh:) forControlEvents:UIControlEventValueChanged]; self.scrollView.alwaysBounceVertical = YES; [self.scrollView addSubview:refreshControl]; - (void)pullToRefresh:(UIRe...

Django 1.9 added the Field.disabled attribute: The disabled boolean argument, when set to True, disables a form field using the disabled HTML attribute so that it won’t be editable by users. Even if a user tampers with the field’s value submitted to the server, it will be ignored in favor of t...

Can be used in conjunction with the custom form example to create a table in the drupal database for a Mailing List feature. This example was made by creating the table directly in my development database, then created the data for hook_schema() using the Schema module. This allows for automatic t...

This is the definition of a TEMP-TABLE named ttTempTable with three fields. NO-UNDO indicates that no undo handling is needed (this is usually what you want to do unless you really need the opposite). DEFINE TEMP-TABLE ttTempTable NO-UNDO FIELD field1 AS INTEGER FIELD field2 AS CHARACTER ...

Temp-tables can (and should) be created with indices if you plan to run queries against them. This table has one index (index1) containing of one field (field1). This index is primary and unique (meaning not two records can have the same contents of field1). DEFINE TEMP-TABLE ttTempTable NO-UNDO ...

A Responsive Table(sap.m.Table) can be created as below XML View <mvc:View controllerName="com.sap.app.controller.Main" xmlns:mvc="sap.ui.core.mvc" xmlns:core="sap.ui.core" xmlns="sap.m"> <Page title="Table Example"> <conte...

This example is the same as WordCount, but uses the Table API. See WordCount for details about execution and results. Maven To use the Table API, add flink-table as a maven dependency: <dependency> <groupId>org.apache.flink</groupId> <artifactId>flink-table_2.11&...

In addition to peoples.csv (see simple aggregation from a CSV) we have two more CSVs representing products and sales. sales.csv (people_id, product_id): 19,5 6,4 10,4 2,4 8,1 19,2 8,4 5,5 13,5 4,4 6,1 3,3 8,3 17,2 6,2 1,2 3,5 15,5 3,3 6,3 13,2 20,4 20,2 products.csv (id, n...

You can add a button or another javafx component to Tableview using column setCellFactory(Callback value) method. Sample Application In this application we are going to add a button to TableView. When clicked to this column button, data on the same row as button is selected and its information pri...

public static DataTable ExcelPackageToDataTable(ExcelPackage excelPackage) { DataTable dt = new DataTable(); ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets[1]; //check if the worksheet is completely empty if (worksheet.Dimension == null) { return dt;...

New Java programmers often forget, or fail to fully comprehend, that the Java String class is immutable. This leads to problems like the one in the following example: public class Shout { public static void main(String[] args) { for (String s : args) { s.toUpperCase(); ...

It's very simple to pass temp-tables in and out of programs, procedures and functions. This can be handy if you want a procedure to process a bigger number of data than you can easily store in a string or similar. You can pass temp-tables as INPUT, OUTPUT and INPUT-OUTPUT data. Inputting one temp-...