Hi Raal
I better mention that even though you can traverse the records using the
next statement, using a while select construct is the recommended way.
Lennart Conrad
Microsoft Business Solutions
This posting is provided "AS IS" with no warranties, and confers no
rights.
________________________________
From: Raal Goff [mailto:[EMAIL PROTECTED]
Sent: 19. januar 2005 03:59
To: [email protected]
Subject: [development-axapta] Direct SQL Queries
Hi,
Is there any way to make a QueryRun object move through a direct SQL
query? Rather than creating QueryBuildRanges and such, can I just
specify 'select * from whatever...' and have the QueryRun.next() move
through the results?
Alternatively, is there a way to move through a table one record at a
time? As opposed to something like
While Select * from tableobject
{
}
Is there another way of moving through the results one at a time?
I hope I am being clear in what im trying to do...
Please excuse me if this is an incredibly obvious thing to do, but I am
just starting out with X++ and axapta, so please try to be patient with
me :)
Thanks,
Raal Goff
Software Developer
NAS Insurance Brokers
T 08 9480 8900
F 08 9481 1166
W www.nasinsurance.com.au
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
be>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
