Cool! I'm using 4.6.0. Will soon try 4.7.0. Thank you, James!
On Thu, Feb 25, 2016 at 2:55 PM, James Taylor
wrote:
> This worked for me in the latest 4.7.0 RC3:
>
> Connected to: Phoenix (version 4.7)
> Driver: PhoenixEmbeddedDriver (version 4.7)
> Autocommit status: true
> Transaction isolat
This worked for me in the latest 4.7.0 RC3:
Connected to: Phoenix (version 4.7)
Driver: PhoenixEmbeddedDriver (version 4.7)
Autocommit status: true
Transaction isolation: TRANSACTION_READ_COMMITTED
Building list of tables and columns for tab-completion (set fastconnect to
true to skip)...
83/83 (1
Sorry, no worky.
I have a table named TMP_SNACKS. TMP_SNACKS has a few static fields and
many dynamic fields. Usually there are only a few dynamic columns (5 or
less) that I am interested in.
One of the dynamic fields in TMP_SNACKS is "page_title". I tried this:
create view MY_VIEW("page_titl
Hi Steve,
You can do what you want with a view today, but the syntax is just a bit
different than what you tried. You declare your dynamic columns after the
view name, like this:
create MY_VIEW("dynamic_field" varchar) as select * from MY_TABLE
You can also alter a view and dynamically add/r
+1 for a view that has dynamic columns. This would make life easier with
dynamic columns.
On Tue, Feb 23, 2016 at 4:00 PM, Steve Terrell
wrote:
> I have a table with many dynamic fields. Works great. However, it's a
> bit of a nuisance to have to supply each dynamic field's type in every
> que
I have a table with many dynamic fields. Works great. However, it's a bit
of a nuisance to have to supply each dynamic field's type in every query.
Example:
select "dynamic_field" from MY_TABLE("dynamic_field" varchar)
This example is not too bad, but image it with 5+ dynamic fields being
used.
