Walter Kempees
|
| Posted: 12/01/2005, 3:27 AM |
|
curthess:
You can avoid this by aliassing the fieldnames.
instead of where last
use
where <table>.last
"curthess" <curthess@forum.codecharge> schreef in bericht
news:6438ed7039537f@news.codecharge.com...
> Using another's MSAccess database where they use field names like "first"
> and
> "last" instead of "firstname" and "lastname".
>
> When building VQ, specifying a Where using "last", CCS uses [last] as
> field
> name, as it should. Unfortunately, when CCS builds the query, the WHERE
> gets
> confused/hosed into some meaningless field name.
>
> VQ builds just fine using another other fields in the Where.
>
> Using CCS 3.0.1.5 activated.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
 |
|
