Orlando
|
| Posted: 11/02/2004, 10:31 AM |
|
I cant modify data (Editable Grid) based in a query (MS-SQL), it displays this error:
Error Type:
Microsoft VBScript runtime (0x800A0009)
Subscript out of range: 'I'
/csg/Lista_ProductosMod.asp, line 547
I can Modify the data directly in SQL, the query is based in 2 table in a INNER JOIN relation.
|
|
|
 |
mrachow
Posts: 509
|
| Posted: 11/02/2004, 2:00 PM |
|
Sorry,
I faced this too but I cant remember.
Is the primary key filled for the new records?
Michael
_________________
Best regards,
Michael |
 |
|
Orlando
|
| Posted: 11/08/2004, 7:16 AM |
|
I create the Join using the Query Builder of CCS, but when I Generate the page, it displays this in the message window:
Warning:Update is allowed for EditableGrid ITM1. Unable to build Update based on the current Datasource settings (joins, SP or custom SQL). Change the Allow Update property to disable Update or specify Custom Update.
I need to use both tables, Table1: List of Products and Table2: List of Prices for each products
I can modify the structure of the database because Im developing a Web Front for an existing desktop aplication. What can I do???
|
|
|
|
peterr
Posts: 5971
|
| Posted: 11/08/2004, 12:51 PM |
|
It's often not possible to update several tables at once using Joins. Joins are usually used for retrieving data. To do an update or insert records you may need, for example, to insert one record into one table, then obtain its key, then use it to update the second table.
That's why CCS displayed the instructions for you: "Change the Allow Update property to disable Update or specify Custom Update". So that's what you will need to do.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Orlando
|
| Posted: 11/08/2004, 1:55 PM |
|
Im just trying to update one field in one table, I use the secont table to retrieve the "name of the product".
Table1 has the product id, country and the price, and table2 has the name of the product, I only need to change the price, not the name of the product....
|
|
|
|
peterr
Posts: 5971
|
| Posted: 11/08/2004, 2:20 PM |
|
Not a problem, that's what I thought.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
