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

[Lennart Conrad]

Hi Daniel   The following is taken from the documentation of the Statement class (\System Documentation\Classes\Statement)   Description  A Statement object is used for executing a static SQL statement and obtaining the results it produces. Only one ResultSet per Statement can be open at any point in time. Therefore, if the reading of one ResultSet is interleaved with the reading of another, each must have been generated by different Statements. Remarks  All statement execute methods implicitly close a statement's current ResultSet if an open one exists. Example  {     Connection Con = new Connection();     Statement Stmt = Con.createStatement();     ResultSet R = Stmt.executeQuery('SELECT VALUE FROM SQLSYSTEMVARIABLES');         while ( R.next() )     {         print R.getString(1);     } }   As I mentioned earlier you cannot use the Statement class if you want to execute X++ sql syntax   Lennart Conrad Microsoft Business Solutions This posting is provided "AS IS" with no warranties, and confers no rights.   From: daniel lim [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 08:37 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0   hi Lennart,   i'm not really understand what u mean by system class statement?   i get solution from other group's member to suggest using something like:   xppCompiler compiler = new xppCompiler(); str sql = 'void sql{select .....}'   if(compiler.compile)       runbuf(sql);   but it seems not working perfectly when i try in job cos the compiler.compile requesting param "str source". i've post this to him but no respond yet. u have any idea on this?will appreciate if u can provide an example. rgds, daniel     Lennart Conrad <[EMAIL PROTECTED]> wrote: 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. Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. 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.