[Axapta-Knowledge-Village] C# COM Connector

[Joel WU]

Hi   My code is as follow in C#   DateString = ‘2004-11-10’                      AxCustTable  = Axapta.CreateRecord("MyTable");                      AxCustTable.ExecuteStmt("select * From %1 where %1.ScanDate >= '"+ DateString  + "'");     What is the problem with this statement? I get no exception, but it just give me all the record.   Regards, Joel Sharing the knowledge on Axapta. Yahoo! Groups Sponsor Get unlimited calls to U.S./Canada 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 the Yahoo! Terms of Service.