Update a DataBase table through CI
dimple (guest) 26 Mar 2011 16:34
the table is not part of the component.
Update a DataBase table through CI
Forum
» Forum / Help
» Update a DataBase table through CI
Summary:
hi.. can anyone suggest a work-around on how to update a table through a CI method.. thnx..
dimple (guest) 26 Mar 2011 16:34
The easiest way to accomplish this is to create a page with that record on it and then add that page to a new component. If you have more than one case like this, you might want to have a generic component as a container. You shouldn't need to register the component as it doesn't need to be accessible from the portal. Once you have the component, create a CI from it.
we already have a component..it will be updated using CIobj.save() in java code, based on a certain condition..
but the new record needs to be updated in either case.. whether the condition is met or not.. in that case what is the
possible solution?
There isn't a setting to do this. So you would need to write PeopleCode that logs at specific points during the process, and have that write to a suitable location on the application server.
Possibly you could look at using application logging (LogFence) as well.
thnx praj..i ws able to generate logs (in the appserver logs) using WriteToLog function..
hv another ques.. if i query the component table, which is getting updated through the CI, it gives only 3 rows..
for newer records, original rows of data in the table are overriden and a total of thee latest three rows exist in the table..
is there possibility to view all records in the table?
actually, there is only 1 row which gets over-written everytime..seems to be an issue with the underlying component..since when i make the CI for this component, 'GetKeys', 'FindKeys' and 'CeateKeys' dont get generated..any possible solution?
Could it be an issue with the search record, i.e., keys on the search record? Can you replicate it on the component, if so, then SQL traces may help to identify what is causing it.
/forum/t-338390/update-a-database-table-through-ci#post-
