Hi All,
Actually I should say "two weird types of problems" that I need help with. I'm working on a fairly simple database which contains work order requests for our M.E. department. I have a search and a grid on the page. When you click on the request number in the grid, a detail view pops up inside the grid. All the editing is done via the detail view.
The first problem is that I'm getting an HY007 (associated statement not prepared) error from the DB sometimes after changing something and publishing. This error is annoying as hell. It happens when you click the save new record button. The grid will allow you to edit older records and save them without issue but when you try a new one up pops this stupid error. I've messed with primary keys and unique IDs and can't seem to figure out exactly what's causing it. I seem to be able to fix it by opening my grid in alpha 5's grid builder, clicking on the "Query", "edit SQL in Query Builder", and then running a test query. I make no changes. After I save my grid and republish it, it seems to work. There's got to be something I'm doing stupid or a glitch somewhere.
The second problem has to do (possibly) with my dropdown lists and lookups for editing the detail view before saving though I don't think it's exclusive to these types of controls. I have a field called "quantity" and the other day I put something in there and saved it. I was trying to find the source of my first problem so was individually moving some fields on and off my detal view in the grid bulider. When I came back to edit that same record again later it wouldn't let me save it and said "Database reported an error: The database could not find the data you requested." Now, no matter what I do, I can't enter anything into this field on this particular record ever again. The field will work fine on new records but not this one, like it's forever screwed up.
Problem number 2 happed again today when someone went to click on the "vendor" field which was an editcombobox lookup. Initially they got a different error and I found that for some reason the "&" in the vendor name was causing the sql to error out upon trying to save the record. When I tried to work around the problem by changing the lookup to bring back the vendor number instead, the same thing happed: "Database reported an error: The database could not find the data you requested." and this record is forever junk in that one field.
If anyone could let me in on what could be causing my problems here I'd greatly appreciate it.
P.S. I just thought of another one. Why won't a .pdf repor print when my control panel isn't open on the server? Do I always have to leave it open so users can print their reports?
Just had problem number 1 again with a completely new grid and a different table:
Record was not inserted. Less...
Database API specific error [Microsoft][ODBC SQL Server Driver]Associated statement is not prepared SQL State is: HY007
This table only has very few columns in it. Fullname First Middle Last Unique ID. I wanted to create a grid to enter user names. This time I can't seem to fix the error at all. It won't let me enter anything!
Actually I should say "two weird types of problems" that I need help with. I'm working on a fairly simple database which contains work order requests for our M.E. department. I have a search and a grid on the page. When you click on the request number in the grid, a detail view pops up inside the grid. All the editing is done via the detail view.
The first problem is that I'm getting an HY007 (associated statement not prepared) error from the DB sometimes after changing something and publishing. This error is annoying as hell. It happens when you click the save new record button. The grid will allow you to edit older records and save them without issue but when you try a new one up pops this stupid error. I've messed with primary keys and unique IDs and can't seem to figure out exactly what's causing it. I seem to be able to fix it by opening my grid in alpha 5's grid builder, clicking on the "Query", "edit SQL in Query Builder", and then running a test query. I make no changes. After I save my grid and republish it, it seems to work. There's got to be something I'm doing stupid or a glitch somewhere.
The second problem has to do (possibly) with my dropdown lists and lookups for editing the detail view before saving though I don't think it's exclusive to these types of controls. I have a field called "quantity" and the other day I put something in there and saved it. I was trying to find the source of my first problem so was individually moving some fields on and off my detal view in the grid bulider. When I came back to edit that same record again later it wouldn't let me save it and said "Database reported an error: The database could not find the data you requested." Now, no matter what I do, I can't enter anything into this field on this particular record ever again. The field will work fine on new records but not this one, like it's forever screwed up.
Problem number 2 happed again today when someone went to click on the "vendor" field which was an editcombobox lookup. Initially they got a different error and I found that for some reason the "&" in the vendor name was causing the sql to error out upon trying to save the record. When I tried to work around the problem by changing the lookup to bring back the vendor number instead, the same thing happed: "Database reported an error: The database could not find the data you requested." and this record is forever junk in that one field.
If anyone could let me in on what could be causing my problems here I'd greatly appreciate it.
P.S. I just thought of another one. Why won't a .pdf repor print when my control panel isn't open on the server? Do I always have to leave it open so users can print their reports?
Just had problem number 1 again with a completely new grid and a different table:
Record was not inserted. Less...
Database API specific error [Microsoft][ODBC SQL Server Driver]Associated statement is not prepared SQL State is: HY007
This table only has very few columns in it. Fullname First Middle Last Unique ID. I wanted to create a grid to enter user names. This time I can't seem to fix the error at all. It won't let me enter anything!
Comment