I have not run into a single letter alias issue, but then again, I do not
use single letter aliases.
However, this is a great time to bring up a problem I have seen with file
naming conventions within VFP (and I am certain in pre-Visual versions
also). You do not ever want to use a dash ("-") in a file or cursor name
with Fox. Fox internally changes the "-" to an underscore ("_") character.
If your code opens a table named "File-Name.dbf", and later tries to use
that table by its File-Name value, your app will fail, as the table is named
File_Name.dbf internally. If you try to use a table with an alias with a
nested "-", Fox throws an error.
I can't begin to tell you how much grief that caused me before I figured out
what was going on.
In my file naming conventions I use no "-" or <Spaces>. I use an "_"
instead.
Gil
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of MB Software Solutions
> General Account
> Sent: Wednesday, February 06, 2008 11:42 AM
> To: [EMAIL PROTECTED]
> Subject: Single letter aliases in VFP SQL causing issue?
>
>
> I was investigating a bug report with old code. Have you ever seen a
> situation where a single letter alias in a VFP SQL-SELECT caused an issue?
> I know I've always used 2 character aliases (like A1 instead of just A)
> ever since Ed Leafe posted that tip back in 1999
> (http://leafe.com/archives/showMsg/5244).
>
> Ed (or others) -- this is a good tip but did you actually see an instance
> where a single letter alias failed?
>
> (VFP9SP1)
>
> tia,
> --Michael
>
>
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
