RE: Mixed Case Fields and SQL

Glad that worked.  Got used to the double quotes when someone named a text 
field DESC.  Seems that SQL thinks that means DESCending.  To use it as a 
field you have to put double quotes around it.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




"Andy Leisk" <ALeisk@xxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
04/29/2003 07:12 AM
Please respond to Midrange Systems Technical Discussion
 
        To:     "'Midrange Systems Technical Discussion'" 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        RE: Mixed Case Fields and SQL


Rob,
That worked ! 

Thank you, I suspected that someone in this list would know how to do it, 
if
it could be done at all.
Andy

-----Original Message-----
From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
Sent: Monday, April 28, 2003 2:52 PM
To: Midrange Systems Technical Discussion
Subject: RE: Mixed Case Fields and SQL


Let me lay that out again, and see if it makes more sense.
----------
create view itemview
("Item_Number", "Item_Description") as
select 
  ITM_NUM,
  ITM_DESC
  From ITEMMASTER 
--------------

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




"Andy Leisk" <ALeisk@xxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
04/28/2003 02:39 PM
Please respond to Midrange Systems Technical Discussion
 
        To:     "'Midrange Systems Technical Discussion'" 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        RE: Mixed Case Fields and SQL


Rob,
following that example I changed my source to be:
----------
create view itemview ("my_Item")  as 
select 
  ITM_NUM  as Item_Number, 
  ITM_DESC as Item_Description 
  From ITEMMASTER 
--------------
then used the RUNSQL command again and got the following result:

 SQL0158  30       1  Position 1 Number of columns specified not 
consistent.


But thanks for trying
Andy

-----Original Message-----
From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
Sent: Monday, April 28, 2003 2:23 PM
To: Midrange Systems Technical Discussion
Subject: Re: Mixed Case Fields and SQL


CREATE VIEW ROB/LEISKL1 ("My_field") AS
SELECT MYCHAR
FROM leisk 

Rob Berendt

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.