Re: strsql how to cram fields together -- MIDRANGE-L

Subject: Re: strsql how to cram fields together
From: John Yeung <gallium.arsenide@xxxxxxxxx>
Date: Fri, 28 Mar 2014 17:14:03 -0400
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

On Fri, Mar 28, 2014 at 4:35 PM, Stone, Joel <Joel.Stone@xxxxxxxxxx> wrote:

Why doesn't LEFT(fieldname,10) shorten the field for display?

Honestly, I think the main reason is that the development team didn't
care to. It wasn't a priority. I don't believe there is a compelling
technical reason why it couldn't be made to.

That said, I'm not sure I would have made it a priority either.
Personally, I don't think of STRSQL as a full-fledged reporting tool.
I see it as an impromptu query tool. It's also a quick way to check
my logic or my SQL syntax when I'm working on a Real Program (tm) that
uses SQL. For these uses, visual polish isn't critical.

John Y.

As an Amazon Associate we earn from qualifying purchases.

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.