Re: Converting fields from Double to String while writing a table view
From: Matt Whitman <mgwhitman_at_gmail.com>
Date: Thu, 15 Nov 2012 17:49:36 -0800 (PST)
Message-ID: <b6a214f6-fdec-47ce-a4b6-8a6245f87b95_at_googlegroups.com>
Thanks for the reply.
FROM Location
WHERE status = "active"
Date: Thu, 15 Nov 2012 17:49:36 -0800 (PST)
Message-ID: <b6a214f6-fdec-47ce-a4b6-8a6245f87b95_at_googlegroups.com>
Thanks for the reply.
Here is a brief example of what I'm trying to do. I've not had any issues creating the view I am uncertain the best method to change the connection column to string when it is currently a double.
CREATE VIEW GIS_VIEW AS
SELECT address,
id,
status,
connection
FROM Location
WHERE status = "active"
Regards,
-MGW Received on Fri Nov 16 2012 - 02:49:36 CET