Please or Register to create posts and topics.

Using a JSON array to create records

"{" & "\"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 ) & "}" )