Author Topic: Too Few Parameters error with Custom SQL Fragment  (Read 4532 times)

Screwtape

  • EA User
  • **
  • Posts: 93
  • Karma: +4/-0
    • View Profile
Too Few Parameters error with Custom SQL Fragment
« on: August 27, 2014, 11:11:16 pm »
Hi,

I've a really simple query and yet I'm getting this error message "Too Few Parameters - Expected 1" each time the fragment is called.

The SQL is
Code: [Select]
SELECT name FROM t_object
where stereotype = "StartEvent"
and t_object.parent_id = #OBJECTID#
which seems so simple there couldn't be anything wrong with it, but I might just be blind.

Any help with this would be great! Thanks!

Screwtape
Screwtape

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: Too Few Parameters error with Custom SQL Fragm
« Reply #1 on: August 28, 2014, 12:50:08 am »
Remove the underline in ParentID

q.

Screwtape

  • EA User
  • **
  • Posts: 93
  • Karma: +4/-0
    • View Profile
Re: Too Few Parameters error with Custom SQL Fragm
« Reply #2 on: August 28, 2014, 01:28:58 am »
Thanks - it's always something simple.

By the way - it's listed as Parent_ID in section 2.4.1 of Inside Enterprise Architect, or at least on the online preview that I was looking at...
Screwtape

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: Too Few Parameters error with Custom SQL Fragm
« Reply #3 on: August 28, 2014, 01:43:48 am »
 :-[ So you're the first one falling in that typo-trap. I'll make a correction immediately. Just download the pdf in a couple of hours.

<rant> One of those inconsistencies. Some names use underline, others don't.</rant>

q.
« Last Edit: August 28, 2014, 01:47:35 am by qwerty »