I've also once used a regular instead of a temp table, so yes sometimes (for joins, special lookups or other) it can be better. However, with regular tables you'll have multiuser problems with deleting records. Only real safe way would be to add some field with a unique sessionID for this user (sessionID could be the exact time for start of this piece of code)(can't use username for if you login 2 times) And if Axapta crashes or whatever the records will not be deleted. Regards, Nico --- In Axapta-Knowledge-Village@yahoogroups.com, "compashi" <[EMAIL PROTECTED]> wrote: > > Hi Everybody, > > Friends i am in Dilemma whether to use Permanent or Regular Table. > Because i was creating a report with the help of a temporary table > but when i tried to use that table a lot many issues do cropped up > like > > 1.Some people said that Insert_recordset can not be used with temp > tables however mine finding is adverse to the same . > 2.I found some join related problem and the ultimate result is that > temp table can't be an outer table and rather can be used only an > inner one. > 3.I faced problem regarding the movement of cursor when i tried to > use it as a normal table viz. by making variable of the same then > tried to make joins with other normal table. > > Now mine question is why to use temporary table when the same effect > can be get by using a regular table in combination with delete_table > to erase the earlier records i hope that is only advantage that a > temp table is providing over reglar table because data is there on to > the fly only. > > Are there any performance or other benefits or something else. > > every type of suggestion is welcomed. Especially from old guys in > Axapta Development. > > > Bye to All . Please do contribute your valuable suggestions. ------------------------ Yahoo! Groups Sponsor --------------------~--> What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
