1. Scott
  2. as Valentina DB Server
  3. 月, 6月 28 2021, 01:09 PM
  4.  メールで購読
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.
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.
Scott 承諾済みの回答
Thanks - I just knew it was something that easy. I am embarrassed now...:o
コメント
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.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories