Hello, Altamash, Are you still having this problem? I would recommend doing the following. 1. Compile the full application from Adminstration menu. This will do forward compilation also. Please make sure no user is online when you do this. 2. if not also solved, please do 'Re indexing' . Again , please make sure no one is working there. I am sure option 1 should solve your problem... please let us know if you have already solved.. Thanks & Regards, subbu
kumar gaurav <[EMAIL PROTECTED]> wrote: Hi, This is a clear case of lack of data integrity , check synchronize the table and delete the incosistent data. reagrds, Kumar G Radhakrishnan <[EMAIL PROTECTED]> wrote: Is it happening after compilation, synchornization and indexing ? --- Altamash <[EMAIL PROTECTED]> wrote: > Hello, > > I am facing this problem for the first time and > don't know wht went > wrong overnight. The forms were working fine till > yesterday night but > started giving the error when i tried to execute the > forms today. > > The error messages are listed below in the sequence > as shown in Axapta : > 1.Cannot select a record in ASSNCustomerMasterTable > (ASSNCustomerMasterTable). > > The SQL database has issued an error. > 2.SQL error description: [Microsoft][ODBC SQL Server > Driver][SQL Server] > Invalid object name 'ASSNCUSTOMERMASTERTABLE'. > > 3.A.ASSNCUSTOMERGENDER,A.ASSNCUSTOMERADDRESS,A.ASSNCUSTOMERAGE,A.ASSNCUS > TOMERNAME,A.ASSNCUSTOMERID,A.RECID FROM > ASSNCUSTOMERMASTERTABLE A WHERE > (DATAAREAID=?) ORDER BY A.DATAAREAID,A.RECID > OPTION(FAST 1) > > As soon as i try to open the form axapta throws this > error and after > closing the error message the form opens. If i > create a new record in > the form the record is created but not saved, as > when i close the form > again it throws the same error message. > > Please help me out. > > Altamash > > > > > > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools --------------------------------- YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- Jiyo cricket on Yahoo! India cricket Yahoo! Messenger Mobile Stay in touch with your buddies all the time. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools --------------------------------- YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- Yahoo! Mail Bring photos to life! New PhotoMail makes sharing a breeze. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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/
