Do not let any software impress you!

Only let it convince your intellect.
Slider img 1
Do not look for a business paradise!

It is a waste of time.
Slider img 2
Only yourself can push you uphill.

There is no easy road to prizes.
Slider img 3
Productivity is the name of the game.

And you have to conquer it.
Slider img 4
As long as you understand it,

you will start to build your know-how.
Slider img 5
We can help with that.

We have the tools and the method.
Slider img 6

Embedded SQL in AutoScript (2)



In cases where there is need for an one-line SELECT statement then is better to use SelectFrom predefined function together with the GetStrArgumentNo. The usage is as follows:

str = SelectFrom(“SELECT COMM, UNAME, RNAME, AU_BUSINESS FROM AU_STEP WHERE (AU_STEP=“,rec_id,“)“)
sep = Escape(1,-1) { ....the separating character is asci 1}
comm = GetStrArgumentNo(str,sep,1)
uname = GetStrArgumentNo(str,sep,2)
rname = GetStrArgumentNo(str,sep,3)
bus_id = GetStrArgumentNo(str,sep,4)

or for a single value return

       comm = SelectFrom(“SELECT COMM FROM AU_STEP WHERE (AU_STEP=“,rec_id,“)“)