Iron Speed Technical Forums
Register Latest Topics
 
 
 


Reply
  Author   Comment  
chorn@subsystem.com

Registered:
Posts: 5
Reply with quote  #1 
I am getting an error on a filter search page. The page's sole purpose is to get filtered data from a view, and then allow the user to export it to excel.

The error is:

Unable to get records. Incorrect syntax near the keyword 'INSERT'. InnerException: incorrect keyword near the keyword 'INSERT'.

After trouble shooting for a while, I decided since the page was so simple, just to use ISD and build a new one using the same view.

I used the wizard to create a new filter and search page.

Prior to making any customizations, I still get the same error on the new page.

I have synced my database schema.
I have verified properties for the view has "Allow insert, update, and delete" marked as "NO"
nestor

Registered:
Posts: 115
Reply with quote  #2 
My guess is that it has something to do with populating one of the filters.
akeshgupta

Avatar / Picture

Iron Speed MVP
Design, Develop & Deliver

Registered:
Posts: 1,090
Reply with quote  #3 
A quick way might be to open this in Visual Studio and try to run this.  This may provide more details on the type of error you are receiving.

HTH,

__________________
Akesh Gupta
Light Speed Solutions, LLC.
If I rest, I will rust !   Let's share the knowledge !
chorn@subsystem.com

Registered:
Posts: 5
Reply with quote  #4 
Thank you both for the reply. I have run it Visual Studio with all exceptions turn on. The filters populate. The problem presents itself when the "go" button is clicked. There is an unhandled exception in the LoadData when the GetRecords is called.
akeshgupta

Avatar / Picture

Iron Speed MVP
Design, Develop & Deliver

Registered:
Posts: 1,090
Reply with quote  #5 
I recommend looking at the properties of the Go Button in Iron Speed.  You can compare the properties to another Go Button on a different page to see the differences.

HTH,

__________________
Akesh Gupta
Light Speed Solutions, LLC.
If I rest, I will rust !   Let's share the knowledge !
chorn@subsystem.com

Registered:
Posts: 5
Reply with quote  #6 
I am a little late in this reply, but I wanted to close the loop. The issue actually stemmed from the Iron Speed generated stored procedure. I was able to trace the problem in VS all the way to the GetRecords when an unhandled exception occurred.   I then used the SQL Server Profiler to grab the stored procedure and arguments as seen by SQL. I grabbed the script and ran the execute statement with the incoming arguments in a new query window in SQL.  This gave me the same error I was seeing in my unhandled exception. 

The short version is:

I edited the IronSpeed stored procedure in SQL, then I dropped and re-created the stored procedure with my changes. This fixed the problem.
JimiJ

Avatar / Picture

MVP Developer
Registered:
Posts: 1,927
Reply with quote  #7 
I don't think that solution is already permanent. You need to keep in mind that ISD will always regenerate SP according to your schema as well as on VFK and VPK settings. [smile]

__________________

  Jaime Jegonia
[jts_logo]

Iron Speed MVP Developer
 

". . . and whoever sows generously will also reap generously" 2 Cor 9:6

Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Download Iron Speed Designer

Terms of Service Privacy Statement