Alpha Video Training
Results 1 to 7 of 7

Thread: Error Creating List Control

  1. #1
    Member
    Real Name
    Daniel Binns
    Join Date
    Apr 2017
    Posts
    48

    Default Error Creating List Control

    Working on a new project and I am getting an error when trying to add my first list control

    New blank project. UX. Panel Nav with multiple panels.

    Inside of one panel trying to add my first control a List.

    Error image attached.
    List builder image attached
    Build number info attached.

    If I go into another project that has controls already and add a list i don't get this error.
    Screenshot 2019-09-19 at 12.51.11.png
    Screenshot 2019-09-19 at 12.50.22.png
    Screenshot 2019-09-19 at 12.48.43.png

  2. #2
    "Certified" Alphaholic
    Real Name
    Larry Grupido
    Join Date
    May 2010
    Posts
    1,794

    Default Re: Error Creating List Control

    Can you add any other controls?

  3. #3
    VAR Pat Bremkamp's Avatar
    Real Name
    Pat Bremkamp
    Join Date
    Apr 2000
    Location
    Oregon, USA
    Posts
    2,626

    Default Re: Error Creating List Control

    As a quick test, try changing the table's name to type1. Type may be a reserved word.
    Pat Bremkamp
    MindKicks Consulting

  4. #4
    Member
    Real Name
    Daniel Binns
    Join Date
    Apr 2017
    Posts
    48

    Default Re: Error Creating List Control

    Okay getting stranger.

    I hadn't tried to do anything beyond adding that list.

    Hopped back on to try adding another control, yes i can add other controls, and when i did that list was added.

    Backed up and removed everything. Cannot add any list with any table name without that error, but adding a control after adding the list makes it show up...

    Definitely a bug as I have created many ux's all with list and never seen this.

  5. #5
    "Certified" Alphaholic
    Real Name
    David Kates
    Join Date
    Apr 2008
    Location
    Unionville, ON
    Posts
    7,702

    Default Re: Error Creating List Control

    Have you installed the hotfix for 6012? If so, try re-installing 6012... and then apply the hotfix again.

  6. #6
    Member
    Real Name
    Daniel Binns
    Join Date
    Apr 2017
    Posts
    48

    Default Re: Error Creating List Control

    I haven't installed the hotfix but installed the prerelease. Working through email with Selwyn.

    I have found that what's happening is the list builder is not recognizing the primary key on some tables. When it doesn't the primary key field in the builder is not set, and the error happens.

    If I set it manually it works.

    If the table has no primary key, there is no issue.

    Some tables with primary keys set it just fine, and this is across multiple databases hosted locally with similar definitions, the primary key always having the same definition of int(11).

    It's weird. But working with Selwyn on it.

  7. #7
    Member
    Real Name
    Sean OKelly
    Join Date
    Sep 2015
    Location
    Charleston, WV
    Posts
    220

    Default Re: Error Creating List Control

    Not sure if this is related, but it seems to be. I ran into an issue recently where I had an autogenerated primary key AND a unique index key made up of 5 different fields. This caused a problem and I had to get rid of the autogenerated primary key. In my case, I didn't really need the autogenerated primarykey, so getting rid of it wasn't an issue.

Similar Threads

  1. List Control Error - The database could not find the data you requested
    By DVD528 in forum Mobile & Browser Applications
    Replies: 24
    Last Post: 03-04-2019, 05:28 PM
  2. Replies: 7
    Last Post: 10-17-2018, 10:30 PM
  3. Can't See Synchronization Error in List Control Header
    By pbc83 in forum Mobile & Browser Applications
    Replies: 0
    Last Post: 02-05-2015, 12:48 PM
  4. 27 Jan 09 : Error creating list: Invalid query specified
    By yemulss in forum Application Server Version 9 - Web/Browser Applications
    Replies: 0
    Last Post: 01-27-2009, 02:45 AM
  5. Record List Control Script Error
    By forskare in forum Alpha Five Version 5
    Replies: 6
    Last Post: 12-14-2002, 10:06 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
  •