[ezRETS-users] Storing Queries

[Jack Burnish]

Its just that, an excel oddity.  It will allow you to use the Wizard to
initially create the Query.  I've only noticed that message when I go to
edit an existing Query.  Its not a bad thing, it just says "Nope, can't use
the wizard on this, here, use this Query panel instead." 

It does the same thing to me when I link to a regular Access database.  So
my assumption is that its intended to return that message.

Jack


-----Original Message-----
From: ezrets-users-bounces at crt.realtors.org
[mailto:ezrets-users-bounces at crt.realtors.org] On Behalf Of Keith T. Garner
Sent: Tuesday, May 22, 2007 9:57 AM
To: Support and talk for users of the ezRETS ODBC Driver
Subject: Re: [ezRETS-users] Storing Queries

On 5/21/07 8:12 PM, Rick Quatro wrote:
> Hello All,
> 
> Can I use * in a SELECT query to return all of the fields? Thanks.

Yep.  However, some RETS severs may not return everything when you ask for
*.  Most do, however.

> Also, I notice in Excel if I choose Data > Import External Data > Edit 
> Query, I get a message that says "This query cannot be edited by the 
> Query Wizard" but it lets me edit it anyway. And, it seems to return 
> the new data. Is there any rhyme or reason why I get the message? 
> Thank you very much.

That's an excel oddity I have yet to figure out.  There is nothing in
ezRETS/an ODBC driver it seems to depend on.  If you figure it out, please
let me know.

Keith

--
  Keith T. Garner - Managing Director - Center for REALTORR Technology
   kgarner at realtors.org - 312-329-3294 - http://blog.realtors.org/crt

_______________________________________________
ezRETS-users mailing list
ezRETS-users at crt.realtors.org
http://mail.crt.realtors.org/mailman/listinfo/ezrets-users