1. Scott
  2. as Valentina DB Server
  3. Montag, Juni 28 2021, 01:09 PM
  4.  Abonnieren via E-Mail
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.
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort

CREATE TYPE mood AS ENUM8 ('sad', 'ok', 'happy');
SELECT fld_specific_info FROM (SHOW TYPES) WHERE fld_name = 'mood';
Kommentar
There are no comments made yet.
Scott Akzeptierte Antwort
Thanks - I just knew it was something that easy. I am embarrassed now...:o
Kommentar
There are no comments made yet.
  • Seite :
  • 1


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