Recent content by rinoshjoseph

hi, May be primarykey.Required is made true in your case. Please make it false and try.. Regards Rinosh

Hello, I use TOracleDataset to connect a database table and a dbGrid.(ie 'select a.rowid, a.* from obj_table a' ) The doubt is after calling the .open if I execute an update statement for this table using an SQL(Update table ...) in another transaction , how the dataset gets refreshed and the...

Thank u

Hello Is there any way to retrieve spaces from Oracle. For eg. (A particular field in Oracle has 5 spaces(' '). While I am retrieving TOracledataset gives ''. Is there any properties to set for getting spaces) Please help Thanks

u can use TBookmark before calling the refresh. For eg: x TBookmark //declarartion x := TOracledataset.getBookmark TOracledataset.refresh; TOracledataset.gotobookmark(x); TOracledataset.freebookmark(x); I think Refreshrecord will refreshes only the current record and .Refresh will refreshes...

(DOA 3.4.5 and Oracle 8i) I want to know how much data should be stored in Toracledataset. I had an sql "Select a.*,a.rowid from table_name" and this table contains 80,000 records in Oracle. When I call dataset.open it takes 2-3 minutes to get data. Also if I made some changes and refresh it ...

Calling last will give only the last value that was saved earlier. For eg. if I add one value and in the after post I call Last it will not give the added one. ?????

After inserting a set of data's I want to see the last record. For that in the after post I wrote OracleDataset.Last. This is not working. Is there any other way. [This message has been edited by rinoshjoseph (edited 24 September 2002).]