I'm using SPT (ODBC).
I have 2 different handles since I have 2 different database in 2 different paths/locations (2 different connection strings).

I have a grid with text box.
Currently the text box shows employee ID.
I want to show Employee name instead.
The employee ID came from the 1st database,
but the names are stored in the 2nd database (different location, different handle).

Here's what I currently have for my SQLEXEC:
lSuccess=SQLEXEC(THIS.lnHandle1,"SELECT empid FROM mytable1 WHERE refno='&zRefno' ","cCursor1")

The grid has .RecordSourcetype=1
.RecordSource='cCursor1'

How do I code my SQLEXEC so that cCursor1 reflects Employee name (from a different handle, THIS.lHandle2)? Can that be done?
What I want is the grid to show employee name instead of the ID.

(cCursor1 is set up so that it is updatable -- used CURSORSETPROP).

Thank you all.