RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0

[Lennart Conrad]

Hi Daniel   Take a look at the system class Statement and its documentation. Note that the SQL syntax should be “real” SQL and not Axapta sql   Lennart Conrad Microsoft Business Solutions This posting is provided "AS IS" with no warranties, and confers no rights.   From: daniellim_yh [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 05:05 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0   hi all, in Axapta, can i do execution to a string like this: TempTableA      _Tmp_Tbl;  //TempTableA is Temp table in Axapta Exprstr = "delete_from _Tmp_Tbl where _Tbl.field1 == 'A'"; then execute this query. i need the syntax to execute it. the reason i do like this because the string is a dynamically generated SQL string. i m using Axapta 3.0. pls help n thx in advance. rgds, daniel Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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.