|
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
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.