Insert Multiple records.

krithika

Can we insert multiple records using single insert statement in NAV. :?

vijay_g

what are you exactly looking for?
what's your code and where you want to insert data?

Sog

No,but with the commit function you can make sure that all or none of the multiple records are inserted.

bbrown

Sog wrote:

No,but with the commit function you can make sure that all or none of the multiple records are inserted.

Off original topic, but why would the commit function be required to achieve this? The normal implicit transaction behavior would handle this.

Belias

No, but the standard behavior from nav 5sp1, actually does bulk inserts behind the scenes...
search "bulk insert" in mibuso, google, msdn...i'm sure there are a lot of topics about that.

Sog

<going further off topic (but still related somehow)>

bbrown wrote:

Sog wrote:

No,but with the commit function you can make sure that all or none of the multiple records are inserted.

Off original topic, but why would the commit function be required to achieve this? The normal implicit transaction behavior would handle this.

I didn't say it was required to type, but since a transaction is completed with that function, and if that transaction is multiple inserts, then it would be the command to use for multiple inserts. (either implicit, or explicit).
Since our topic starter is quite hesitant with details about the situation, and ask a question that is very likely to be misinterpreted, I gave a very wide but correct answer. It's my way of telling people to be more specific/ask right questions.