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

2005-03-16 Thread Varden Morris
From: daniel lim [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 08:37To: Axapta-Knowledge-Village@yahoogroups.comSubject: 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

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

2005-03-16 Thread daniel lim
From: daniel lim [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 08:37To: Axapta-Knowledge-Village@yahoogroups.comSubject: 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 f

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

2005-03-16 Thread daniel lim
"AS IS" with no warranties, and confers no rights.   From: daniel lim [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 10:47To: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0   hi Lennart,   it works for select statement,

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

2005-03-16 Thread daniel lim
  From: daniel lim [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 08:37To: Axapta-Knowledge-Village@yahoogroups.comSubject: 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 s

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

2005-03-16 Thread Lennart Conrad
lto:[EMAIL PROTECTED] Sent: 16. marts 2005 10:47 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0   hi Lennart,   it works for select statement, but not with delete statement. my example as follow

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

2005-03-16 Thread daniel lim
To: Axapta-Knowledge-Village@yahoogroups.comSubject: 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:   xppComp

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

2005-03-16 Thread Lennart Conrad
.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 =

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

2005-03-15 Thread daniel lim
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 w

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

2005-03-15 Thread 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.   Fr