sasha wrote: > But if i have 1 000 000 records in datbase and inserted one record why i > should refresh other 1 000 000 ? Such behavour have no sence as for me. > I want refresh only inserted or updated records. Is it possible?
And where are you storing these rows? BTW how the RefreshSQL procedure in Delphi loads only the changed row? AFAIK Firebird doesn't return the "new" row after updating/inserting. IMHO there's no way how to get the update result from DB defaultly (no matter that it can be completely changed during insert process) - you can use returning, or load it by i.e. id or something like this. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider