What's the underscore?

[Edis, Bob]

G'day Victor

All SQL databases don't allow a dash/hyphen as a valid character in a column
or table name.  If you want to make your system more flexible with future
database needs, especially utilizing embedded SQL, you need to convert the
dashes (-) to underscores (_).

Blue

-----Original Message-----
From: Victor Geere [mailto:victor@nha.co.za]
Sent: Thursday, May 30, 2002 8:41 AM
To: Powerhouse List (E-mail)
Subject: What's the underscore?


Is there a way of addressing FIELD_NAME (in Oracle) as FIELD-NAME in
Powerhouse?
Image allowed hyphens in the field name and Oracle doesn't, but we would
like to retain the naming conventions in Powerhouse.
I was thinking along the lines of an alias/synonym statement in the ELEMENT
clause.

Victor.



= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.