Re: Pro*C and Reserved Words (Help)

Tim Boemker (tim_boemker_at_zacatecas.optimum.com) wrote:
: In article <sza1vk7QB4VB083yn_at_medcal1.csustan.edu>
: JCL_at_medcal1.csustan.edu (John Landers) writes:
 

: > This may sound a little off but some legavy programs name some fields
: > in a table as begin and end. These are date fields. The problem comes when a pro*c
: > program tries to precompile and see the begin & end fields but thinks they are
: > part of a PL/SQL function
 

: In many circumstances, it's possible to quote a name. For example, I
: can create a table with a column named uid (a reserved word) if I say
: "uid" number... Perhaps the same approach will work with Pro*C.

Yes, this works. You'll also need to do it if you have any fields named COUNT.
(i.e. replace them with "COUNT").

Joe

: Tim Boemker
: Optimum Group
: (513) 577-7785

--
                                   
=------------------------------------------------------------------------=
Joe Nardone               |    
joe_at_access.digex.net      |