Alpha Video Training
Results 1 to 3 of 3

Thread: Query Genie Does Not Show Fields for a Table?

  1. #1
    Member
    Real Name
    Chris DiBianco
    Join Date
    Feb 2006
    Location
    Albany, NY
    Posts
    76

    Default Query Genie Does Not Show Fields for a Table?

    I am trying to use the query genie on one of my tables and when it comes up it does not show any of the fields. Instead it gives you options to query by record, any field, all fields, and expression. All my other tables work fine. What am I missing?

  2. #2
    Member
    Real Name
    Marion Taylor
    Join Date
    Jan 2012
    Location
    Hudson Valley, NY
    Posts
    481

    Default Re: Query Genie Does Not Show Fields for a Table?

    not sure if this is applicable to your situation, but I ran into a complication (using Microsoft SQL) when I had two tables, with different schema names.

    For example, I had:
    dbo.Entity
    Venue.Entity

    and that confused A5. I've reported it as a bug and they've fixed it; I haven't installed the latest pre-release build to confirm.

    As a work around, I renamed one of the tables.
    MSQL since 2010
    A5V11 since Feb 2012

  3. #3
    Member
    Real Name
    Chris DiBianco
    Join Date
    Feb 2006
    Location
    Albany, NY
    Posts
    76

    Default Re: Query Genie Does Not Show Fields for a Table?

    I fixed it. I ran the current updates which I haven't run in a long time and it solved the problem!

Similar Threads

  1. Query Genie?
    By Peter.Greulich in forum Application Server Version 10 - Web/Browser Applications
    Replies: 4
    Last Post: 05-05-2011, 12:16 PM
  2. Replies: 0
    Last Post: 07-03-2009, 05:25 AM
  3. genie query - missing fields
    By diane novatnik in forum Alpha Five Version 5
    Replies: 5
    Last Post: 01-03-2004, 06:28 AM
  4. Query Genie Missing Fields
    By Barrett Anderson in forum Alpha Five Version 5
    Replies: 0
    Last Post: 09-18-2003, 01:22 PM
  5. Query Genie
    By Rhea Vaughan in forum Alpha Five Version 4
    Replies: 0
    Last Post: 09-26-2000, 10:12 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •