Creating ESS records in script.

[Ocean West]

Curious which method is preferred, when creating a record thru ESS in a script. Should you create the record and then commit, then proceed with setting other fields- then committing again. Or is it fine to create new record do a bunch of set fields then commit the record?

[Garry Claridge]

I've been successfully inserting into a MySQL database via Scripts without using "Commit". However, not too sure about using "Set Field" directly after the INSERT.

Good Luck.

Garry

[sullyman]

Hi,

I've creted an ESS Script where i first set field, then commmit record, then grab another variable, and again set field and then commit the record again. Works well.

Sully

[James Steele]

Can I get a copy of that script? I am having some difficulty with that.