> And where are you storing these rows? I haven't million records yet. That was just a sample.
> BTW how the RefreshSQL procedure in Delphi loads only the changed row? AFAIK > Firebird doesn't return the "new" row after updating/inserting. 1) For inserting component knows ID because it calls GEN_ID before inserting and than inserts record with alredy known id 2) For updating it use something like @ID variable So i don't see any problems... > 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. I already understood this. It was easy to do this in delphi, so i'm wondering... Last ~2 years i developed ASP.NET applications. In that applications we use own ORM libruary. Seems i'll try to use it for desktops too because ADO.NET concepts still looks strande for me :-( ------------------------------------------------------------------------- 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
