1. Scott
  2. as Valentina DB Server
  3. Понедельник, Июнь 28 2021, 01:09 PM
  4.  Подписаться через email
I am having a senior moment - I cannot for the life of me, remember how to pull Enum types from the DB in order to display in a GUI. For example, how to pull types and list them in Xojo or PHP listbox/dropdowns.
Комментарий
There are no comments made yet.
Scott Ответ принят
Thanks - I just knew it was something that easy. I am embarrassed now...:o
Комментарий
There are no comments made yet.
Ivan Smahin Ответ принят

CREATE TYPE mood AS ENUM8 ('sad', 'ok', 'happy');
SELECT fld_specific_info FROM (SHOW TYPES) WHERE fld_name = 'mood';
Комментарий
There are no comments made yet.
  • Страница :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.