Alpha Video Training
Results 1 to 5 of 5

Thread: sql arguments

  1. #1
    Member
    Real Name
    Mark Villa
    Join Date
    Aug 2012
    Location
    Louisiana
    Posts
    40

    Default sql arguments

    in a dialog component, I get sql arguments not in list.... form error
    (dialog component, multiple tables with bindings, repeating section)
    any ideas
    Attached Images Attached Images

  2. #2
    Member
    Real Name
    Mark Villa
    Join Date
    Aug 2012
    Location
    Louisiana
    Posts
    40

    Default Re: sql arguments

    any help out there?
    Wiki's videos sure don t show "if there is a problem" tutorial. Most videos are for the perfect scenario .... which does not always happen.

  3. #3
    "Certified" Alphaholic
    Real Name
    Lee Vasic
    Join Date
    May 2010
    Location
    Salt Lake City
    Posts
    1,182

    Default Re: sql arguments

    Make sure the names that are used in the set args are the same in the SQL statement. If they are off you can get this type of error.

  4. #4
    Member
    Real Name
    Mark Villa
    Join Date
    Aug 2012
    Location
    Louisiana
    Posts
    40

    Default Re: sql arguments

    where do I find this?

  5. #5
    Member
    Real Name
    Edhy Rijo
    Join Date
    Sep 2012
    Location
    Bronx NY
    Posts
    348

    Default Re: sql arguments

    Hi Mark,
    Looking at your screenshot in the first post, the SQL query is expecting a value for the :Main Quote_notes argument. Review your form and make sure the Quote_notes fields is included in your selected fields or something along those lines.

Similar Threads

  1. Insert SQL with arguments
    By eblaschka in forum Alpha Five Version 11 - Desktop Applications
    Replies: 2
    Last Post: 06-04-2012, 02:51 PM
  2. SQL and Arguments
    By njguy in forum Application Server Version 11 - Web/Browser Applications
    Replies: 1
    Last Post: 04-30-2012, 03:48 PM
  3. Concatenating arguments in an SQL filter
    By RaEd. in forum Application Server Version 10 - Web/Browser Applications
    Replies: 5
    Last Post: 01-10-2012, 11:42 AM
  4. What to do with multiple SQL arguments
    By gagsoft in forum Alpha Five Version 9 - Desktop Applications
    Replies: 11
    Last Post: 08-31-2009, 12:46 PM
  5. SQL Arguments as variables
    By hpjchobbes in forum QReportBuilder
    Replies: 4
    Last Post: 04-09-2008, 11:30 PM

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
  •