Quote from
thecrow on 07/18/2025, 3:24 pm
"{" & "\"Category\":\"" & Equipment::Category & "\"," &
"\"Type\":\"" & Equipment::Type & "\"," &
"\"Manufacturer\":\"" & Equipment::Manufacturer & "\"," &
"\"Model\":\"" & Equipment::Model & "\"" &
If ( ExecuteSQL ( "SELECT COUNT (*) FROM BuildSpecs WHERE Description IS NOT NULL AND id_inventory = ? " ; "" ; "" ; EquipmentInventory::ID ) = 0 ; "}" ; "," & ExecuteSQL ( "SELECT '\"' + Specification + '\"', '\"' + Description + '\"' FROM BuildSpecs WHERE Description IS NOT NULL AND id_inventory = ? " ; ":" ; "," ; EquipmentInventory::ID ) & "}" )
"{" & "\"Category\":\"" & Equipment::Category & "\"," &
"\"Type\":\"" & Equipment::Type & "\"," &
"\"Manufacturer\":\"" & Equipment::Manufacturer & "\"," &
"\"Model\":\"" & Equipment::Model & "\"" &
If ( ExecuteSQL ( "SELECT COUNT (*) FROM BuildSpecs WHERE Description IS NOT NULL AND id_inventory = ? " ; "" ; "" ; EquipmentInventory::ID ) = 0 ; "}" ; "," & ExecuteSQL ( "SELECT '\"' + Specification + '\"', '\"' + Description + '\"' FROM BuildSpecs WHERE Description IS NOT NULL AND id_inventory = ? " ; ":" ; "," ; EquipmentInventory::ID ) & "}" )