Lines Matching refs:sCreateStatement

450 …protected boolean implCreateTable( XConnection xConn, String sCreateStatement, String sTableName )…  in implCreateTable()  argument
452 if ( !implExecuteStatement( xConn, sCreateStatement ) ) in implCreateTable()
470 String sCreateStatement = "CREATE TABLE " + s_tableNameSalesmen + " "; in createTableSalesman() local
471 sCreateStatement += "(SNR INTEGER NOT NULL, "; in createTableSalesman()
472 sCreateStatement += "FIRSTNAME VARCHAR(50), "; in createTableSalesman()
473 sCreateStatement += "LASTNAME VARCHAR(100), "; in createTableSalesman()
474 sCreateStatement += "STREET VARCHAR(50), "; in createTableSalesman()
475 sCreateStatement += "STATE VARCHAR(50), "; in createTableSalesman()
476 sCreateStatement += "ZIP INTEGER, "; in createTableSalesman()
477 sCreateStatement += "BIRTHDATE DATE, "; in createTableSalesman()
478 sCreateStatement += "PRIMARY KEY(SNR))"; in createTableSalesman()
480 if ( implCreateTable( xConn, sCreateStatement, s_tableNameSalesmen) ) in createTableSalesman()
501 String sCreateStatement = "CREATE TABLE " + s_tableNameCustomers + " "; in createTableCustomer() local
502 sCreateStatement += "(COS_NR INTEGER NOT NULL, "; in createTableCustomer()
503 sCreateStatement += "LASTNAME VARCHAR(100), "; in createTableCustomer()
504 sCreateStatement += "STREET VARCHAR(50), "; in createTableCustomer()
505 sCreateStatement += "CITY VARCHAR(50), "; in createTableCustomer()
506 sCreateStatement += "STATE VARCHAR(50), "; in createTableCustomer()
507 sCreateStatement += "ZIP INTEGER, "; in createTableCustomer()
508 sCreateStatement += "PRIMARY KEY(COS_NR))"; in createTableCustomer()
510 if ( implCreateTable( xConn, sCreateStatement, s_tableNameCustomers ) ) in createTableCustomer()
531 String sCreateStatement = "CREATE TABLE " + s_tableNameSales + " "; in createTableSales() local
532 sCreateStatement += "(SALENR INTEGER NOT NULL, "; in createTableSales()
533 sCreateStatement += "COS_NR INTEGER NOT NULL, "; in createTableSales()
534 sCreateStatement += "SNR INTEGER NOT NULL, "; in createTableSales()
535 sCreateStatement += "NAME VARCHAR(50), "; in createTableSales()
536 sCreateStatement += "SALEDATE DATE, "; in createTableSales()
537 sCreateStatement += "PRICE DECIMAL(8,2), "; in createTableSales()
538 sCreateStatement += "PRIMARY KEY(SALENR))"; in createTableSales()
540 if ( implCreateTable( xConn, sCreateStatement, s_tableNameSales ) ) in createTableSales()