David
Was going to post about this last Friday, but got called away... I
remember a post from Dr:R> a good while back that said the same thing
about the $ character as the # in column names... basically don't use
them. His post was mostly referring to the $ char being used at the end
of a col name like User$. I also have gotten the jist like posted where
that you can use the IDQUOTE setting to surround and get by, but better
to comply. I know I ran into a problem using an ODBC connecttion a year
or two ago when the program I was using - I think it was Data Junction..
didn't like the # sign... Had to shove data into a table without # signs
to get it to work... All in all it's just another ... Better to comply
than deal with the later/present limitations of an older way of doing
things. I guess that's why job markets exist - it always changes so we
can never keep up.
Jim Limburg
[EMAIL PROTECTED] wrote:
>
> I owe you all (and Jim Andrus) an apology. I really
> goofed big style.
>
> I use ClipMate5 and TextPad on a daily basis but why I
> typed ClipMate5 when I should have typed TextPad is
> beyond me. Put it down to Age, Familiarity Blur (and
> probably just one drop too many of that famous flying
> Elixir from Scotland !)
>
> What follows comes from feeling a bit of an EJUT and is
> in no way intended to be an Ad.
>
> Textpad comes with a seemingly endless trial period
> and sits on the toolbar in virtually any application
> (including the R:Prompt). It does the things mentioned
> in my original mail (and so much more).
> You can even create your own Macros and run them
> whenever and if interested, you can submit your
> routines for others to use. www.textpad.com/ An
> eventual single user licence eventually costs $27.
>
> Chest feels a bit lighter now !
>
> Many thanks for the replies - Already convinced about
> removing # from column names - you've now made it a
> priority. (Gulp !)
>
> Ben - I agree - # have been great for searches but I'm
> sure %ID will quickly become as familiar so I'll take this
> opportunity to become watertight for future .
>
> A big THANKS for the time you all give to the List.
> There must be hundreds like me who really look forward
> to the daily learning session.
>
> David Atkinson.
> [EMAIL PROTECTED]
> www.skidbusters.co.uk
