tag:blogger.com,1999:blog-2757538670382901720.post1724462836434190270..comments2024-03-21T21:19:29.772-07:00Comments on Dynamics Ax Live: How to create complex SQL statements in AxWillyhttp://www.blogger.com/profile/15369416963614928863noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-2757538670382901720.post-73984527476270847502010-06-30T23:32:31.204-07:002010-06-30T23:32:31.204-07:00Hi Gert,
Indeed.
But I've encoutered more str...Hi Gert,<br /><br />Indeed.<br />But I've encoutered more strange things with resultSet in the past. Like if you select multiple fields, you are forced to retrieve all their values with resultSet.getXYZ.<br /><br />Thanx for the comment,<br /><br />Willy.Willyhttps://www.blogger.com/profile/15369416963614928863noreply@blogger.comtag:blogger.com,1999:blog-2757538670382901720.post-37187198670464512612010-06-30T14:24:23.475-07:002010-06-30T14:24:23.475-07:00please notice that the resultset.getxxx method sho...please notice that the resultset.getxxx method should be called in order, for example<br />var1 = resultSet.getReal(1);<br />var2 = resultSet.getReal(2);<br /><br />if you do <br /><br />var1 = resultSet.getReal(2);<br />var2 = resultSet.getReal(1);<br /><br />you get an errorGerthttps://www.blogger.com/profile/04175695552197424855noreply@blogger.com