set status [ SclFunction "BLAST OPEN DATABASE" {
frm10010={
{
_action=display
dbname="blast"
}
}
frm10011={
{
_action="apply"
}
}
frm10020={
{
_action=display
dbtyp="access2000"
xyzcal="CALCULATED"
}
}
frm10021={
{
scroll_1=table { table_name table_type time_dependent } {
{ "charge" "interval" "N" }
{ "sample" "interval" "N" }
}
}
}
frmcreateDatabase={
{
mand_fields1={
{
mand_nulls_for_table1="N"
mand_index_for_table1=null
mand_length_for_table1="50"
mand_decimals_for_table1=null
mand_lo_bound_for_table1=null
mand_hi_bound_for_table1=null
}
{
mand_nulls_for_table1="N"
mand_index_for_table1=null
mand_length_for_table1="11"
mand_decimals_for_table1="3"
mand_lo_bound_for_table1="-999999"
mand_hi_bound_for_table1="9999999"
}
{
mand_nulls_for_table1="N"
mand_index_for_table1=null
mand_length_for_table1="11"
mand_decimals_for_table1="3"
mand_lo_bound_for_table1="-999999"
mand_hi_bound_for_table1="9999999"
}
{
mand_nulls_for_table1="N"
mand_index_for_table1=null
mand_length_for_table1="11"
mand_decimals_for_table1="3"
mand_lo_bound_for_table1="-999999"
mand_hi_bound_for_table1="9999999"
}
{
mand_nulls_for_table1="N"
mand_index_for_table1=null
mand_length_for_table1="11"
mand_decimals_for_table1="3"
mand_lo_bound_for_table1="0"
mand_hi_bound_for_table1="9999"
}
{
mand_index_for_table1=null
mand_length_for_table1="8"
mand_decimals_for_table1=null
mand_lo_bound_for_table1=null
mand_hi_bound_for_table1=null
}
}
opt_fields1=table { opt_field_for_table1 opt_type_for_table1 opt_nulls_for_table1 opt_length_for_table1 opt_decimals_for_table1 opt_case_for_table1 opt_lo_bound_for_table1 opt_hi_bound_for_table1 valid_entries_for_table1 phys_or_virt_for_table1 reference_field_for_table1 } {
{ "blast_pattern" "character" "Y" "30" null "mixed" null null "" "physical" null }
{ "rock_class" "character" "Y" "30" null "mixed" null null "" "physical" null }
{ "drill_rig" "character" "Y" "30" null "mixed" null null "" "physical" null }
{ "subdrill" "real" "Y" "10" "2" null "0" "999" null "physical" null }
{ "hole_diameter" "real" "Y" "10" "2" null "0" "999" null "physical" null }
{ "blasting_method" "character" "Y" "30" null "mixed" null null "" "physical" null }
{ "ground_water_level" "real" "Y" "10" "2" null "-9999" "9999" null "physical" null }
{ "delay" "character" "Y" "50" null "mixed" null null "" "physical" null }
{ "surface_delay" "real" "Y" "10" "2" null "0" "9999" null "physical" null }
}
mand_fields2={
{
mand_nulls_for_table2="N"
mand_index_for_table2=null
mand_length_for_table2="50"
mand_decimals_for_table2=null
mand_lo_bound_for_table2=null
mand_hi_bound_for_table2=null
}
{
mand_nulls_for_table2="N"
mand_index_for_table2=null
mand_length_for_table2="7"
mand_decimals_for_table2="2"
mand_lo_bound_for_table2="0"
mand_hi_bound_for_table2="9999"
}
{
mand_nulls_for_table2="N"
mand_index_for_table2=null
mand_length_for_table2="11"
mand_decimals_for_table2="3"
mand_lo_bound_for_table2="-999999"
mand_hi_bound_for_table2="9999999"
}
{
mand_nulls_for_table2="N"
mand_index_for_table2=null
mand_length_for_table2="11"
mand_decimals_for_table2="3"
mand_lo_bound_for_table2="-999999"
mand_hi_bound_for_table2="9999999"
}
{
mand_nulls_for_table2="N"
mand_index_for_table2=null
mand_length_for_table2="11"
mand_decimals_for_table2="3"
mand_lo_bound_for_table2="-999999"
mand_hi_bound_for_table2="9999999"
}
{
mand_index_for_table2=null
mand_length_for_table2="6"
mand_decimals_for_table2="2"
mand_lo_bound_for_table2="-90"
mand_hi_bound_for_table2="90"
}
{
mand_index_for_table2=null
mand_length_for_table2="6"
mand_decimals_for_table2="2"
mand_lo_bound_for_table2="0"
mand_hi_bound_for_table2="360"
}
}
opt_fields2={
{
opt_field_for_table2=""
opt_type_for_table2="character"
opt_nulls_for_table2="Y"
opt_length_for_table2="10"
opt_decimals_for_table2=null
opt_case_for_table2="mixed"
opt_lo_bound_for_table2=null
opt_hi_bound_for_table2=null
valid_entries_for_table2=""
phys_or_virt_for_table2="physical"
reference_field_for_table2=null
}
}
mand_fields3={
{
mand_nulls_for_table3="N"
mand_index_for_table3=null
mand_length_for_table3="18"
mand_decimals_for_table3=null
mand_lo_bound_for_table3=null
mand_hi_bound_for_table3=null
}
{
mand_nulls_for_table3="Y"
mand_index_for_table3=null
mand_length_for_table3="18"
mand_decimals_for_table3=null
mand_lo_bound_for_table3=null
mand_hi_bound_for_table3=null
}
{
mand_index_for_table3=null
mand_length_for_table3="6"
mand_decimals_for_table3=null
mand_lo_bound_for_table3=null
mand_hi_bound_for_table3=null
}
{
mand_index_for_table3=null
mand_length_for_table3="8"
mand_decimals_for_table3="2"
mand_lo_bound_for_table3="-999999"
mand_hi_bound_for_table3="9999999"
}
{
mand_index_for_table3=null
mand_length_for_table3="32"
mand_decimals_for_table3=null
mand_lo_bound_for_table3=null
mand_hi_bound_for_table3=null
}
}
opt_fields3={
{
opt_field_for_table3=""
opt_type_for_table3="character"
opt_nulls_for_table3="Y"
opt_length_for_table3="10"
opt_decimals_for_table3=null
opt_case_for_table3="mixed"
opt_lo_bound_for_table3=null
opt_hi_bound_for_table3=null
valid_entries_for_table3=""
phys_or_virt_for_table3="physical"
reference_field_for_table3=null
}
}
mand_fields4=table { mand_nulls_for_table4 mand_index_for_table4 mand_length_for_table4 mand_decimals_for_table4 mand_lo_bound_for_table4 mand_hi_bound_for_table4 } {
{ "N" null "18" null null null }
{ "N" null "18" null null null }
{ "N" null "1" null null null }
{ "Y" null "20" null null null }
{ "Y" null "23" null null null }
{ "Y" null "23" null null null }
{ "N" null "32" null null null }
{ "N" null "32" null null null }
{ "N" null "5" null null null }
{ "N" null "16" null null null }
{ "N" null "32" null null null }
{ "N" null "32" null null null }
{ "N" null "4" null "1" "9" }
{ "N" null "16" null null null }
{ "N" null "4" "2" "0.01" "9" }
}
opt_fields4={
{
opt_field_for_table4=""
opt_type_for_table4="character"
opt_nulls_for_table4="Y"
opt_length_for_table4="10"
opt_decimals_for_table4=null
opt_case_for_table4="mixed"
opt_lo_bound_for_table4=null
opt_hi_bound_for_table4=null
valid_entries_for_table4=""
phys_or_virt_for_table4="physical"
reference_field_for_table4=null
}
}
mand_fields5={
{
mand_nulls_for_table5="Y"
mand_index_for_table5=null
mand_length_for_table5="50"
mand_decimals_for_table5=null
mand_lo_bound_for_table5=null
mand_hi_bound_for_table5=null
}
{
mand_nulls_for_table5="N"
mand_index_for_table5="none"
mand_length_for_table5="50"
mand_decimals_for_table5=null
mand_lo_bound_for_table5=null
mand_hi_bound_for_table5=null
}
{
mand_nulls_for_table5="N"
mand_index_for_table5=null
mand_length_for_table5="7"
mand_decimals_for_table5="2"
mand_lo_bound_for_table5="0"
mand_hi_bound_for_table5="9999"
}
{
mand_nulls_for_table5="N"
mand_index_for_table5=null
mand_length_for_table5="11"
mand_decimals_for_table5="3"
mand_lo_bound_for_table5="-999999"
mand_hi_bound_for_table5="9999999"
}
{
mand_nulls_for_table5=null
mand_index_for_table5=null
mand_length_for_table5="11"
mand_decimals_for_table5="3"
mand_lo_bound_for_table5="-999999"
mand_hi_bound_for_table5="9999999"
}
{
mand_nulls_for_table5="N"
mand_index_for_table5=null
mand_length_for_table5="11"
mand_decimals_for_table5="3"
mand_lo_bound_for_table5="-999999"
mand_hi_bound_for_table5="9999999"
}
{
mand_nulls_for_table5="N"
mand_index_for_table5=null
mand_length_for_table5="7"
mand_decimals_for_table5="2"
mand_lo_bound_for_table5="0"
mand_hi_bound_for_table5="9999"
}
{
mand_nulls_for_table5="N"
mand_index_for_table5=null
mand_length_for_table5="11"
mand_decimals_for_table5="3"
mand_lo_bound_for_table5="-999999"
mand_hi_bound_for_table5="9999999"
}
{
mand_index_for_table5=null
mand_length_for_table5="11"
mand_decimals_for_table5="3"
mand_lo_bound_for_table5="-999999"
mand_hi_bound_for_table5="9999999"
}
{
mand_index_for_table5=null
mand_length_for_table5="11"
mand_decimals_for_table5="3"
mand_lo_bound_for_table5="-999999"
mand_hi_bound_for_table5="9999999"
}
}
opt_fields5=table { opt_field_for_table5 opt_type_for_table5 opt_nulls_for_table5 opt_length_for_table5 opt_decimals_for_table5 opt_case_for_table5 opt_lo_bound_for_table5 opt_hi_bound_for_table5 valid_entries_for_table5 phys_or_virt_for_table5 reference_field_for_table5 } {
{ "explosive" "character" "Y" "30" null "mixed" null null "" "physical" null }
{ "detonator" "character" "Y" "30" null "mixed" null null "" "physical" null }
{ "num_of_dets" "integer" "N" "10" null null "0" "999" null "physical" null }
{ "det_position" "character" "Y" "30" null "mixed" null null "" "physical" null }
{ "booster" "character" "Y" "30" null "mixed" null null "" "physical" null }
{ "num_of_boosters" "real" "N" "10" "2" null "0" "999" null "physical" null }
{ "delay" "character" "Y" "30" null "mixed" null null "" "physical" null }
}
mand_fields6={
{
mand_nulls_for_table6="Y"
mand_index_for_table6=null
mand_length_for_table6="50"
mand_decimals_for_table6=null
mand_lo_bound_for_table6=null
mand_hi_bound_for_table6=null
}
{
mand_nulls_for_table6="N"
mand_index_for_table6="none"
mand_length_for_table6="50"
mand_decimals_for_table6=null
mand_lo_bound_for_table6=null
mand_hi_bound_for_table6=null
}
{
mand_nulls_for_table6="N"
mand_index_for_table6=null
mand_length_for_table6="7"
mand_decimals_for_table6="2"
mand_lo_bound_for_table6="0"
mand_hi_bound_for_table6="9999"
}
{
mand_nulls_for_table6="N"
mand_index_for_table6=null
mand_length_for_table6="11"
mand_decimals_for_table6="3"
mand_lo_bound_for_table6="-999999"
mand_hi_bound_for_table6="9999999"
}
{
mand_nulls_for_table6=null
mand_index_for_table6=null
mand_length_for_table6="11"
mand_decimals_for_table6="3"
mand_lo_bound_for_table6="-999999"
mand_hi_bound_for_table6="9999999"
}
{
mand_nulls_for_table6="N"
mand_index_for_table6=null
mand_length_for_table6="11"
mand_decimals_for_table6="3"
mand_lo_bound_for_table6="-999999"
mand_hi_bound_for_table6="9999999"
}
{
mand_nulls_for_table6="N"
mand_index_for_table6=null
mand_length_for_table6="7"
mand_decimals_for_table6="2"
mand_lo_bound_for_table6="0"
mand_hi_bound_for_table6="9999"
}
{
mand_nulls_for_table6="N"
mand_index_for_table6=null
mand_length_for_table6="11"
mand_decimals_for_table6="3"
mand_lo_bound_for_table6="-999999"
mand_hi_bound_for_table6="9999999"
}
{
mand_index_for_table6=null
mand_length_for_table6="11"
mand_decimals_for_table6="3"
mand_lo_bound_for_table6="-999999"
mand_hi_bound_for_table6="9999999"
}
{
mand_index_for_table6=null
mand_length_for_table6="11"
mand_decimals_for_table6="3"
mand_lo_bound_for_table6="-999999"
mand_hi_bound_for_table6="9999999"
}
}
opt_fields6={
{
opt_field_for_table6=""
opt_type_for_table6="character"
opt_nulls_for_table6="Y"
opt_length_for_table6="10"
opt_decimals_for_table6=null
opt_case_for_table6="mixed"
opt_lo_bound_for_table6=null
opt_hi_bound_for_table6=null
valid_entries_for_table6=""
phys_or_virt_for_table6="physical"
reference_field_for_table6=null
}
}
}
}
}]
