You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Use the following SQL queries to return values for the specified data types.\n
\n
Integer Data\n
\n
SELECT e.name,p.name,d.value,d.sampletime FROM erdc_int_data d, erdc_instance e, erdc_parameter p\n
where e.erdc_instance_id = d.erdc_instance_id\n
and p.erdc_parameter_id = d.erdc_parameter_id\n
and e.name like "INSTANCE_NAME";\n
\n
Decimal Data\n
\n
SELECT e.name,p.name,d.value,d.sampletime FROM erdc_decimal_data d, erdc_instance e, erdc_parameter p\n
where e.erdc_instance_id = d.erdc_instance_id\n
and p.erdc_parameter_id = d.erdc_parameter_id\n
and e.name like "INSTANCE_NAME";\n
\n
String Data\n
\n
SELECT e.name,p.name,d.value,d.sampletime FROM erdc_string_data d, erdc_instance e, erdc_parameter p\n
where e.erdc_instance_id = d.erdc_instance_id\n
and p.erdc_parameter_id = d.erdc_parameter_id\n
and e.name like "INSTANCE_NAME";
  • No labels