Message to Edit Object

[LeGauche]

I'm using an ODBC object and an Edit Object (text box). What's the correct syntax to put the result of an SQL search column into a specific text box. For example, after getting a row of data from "SELECT * FROM ORDERS"", I need to put the $ in column 2 (Field 2) of the result into the text box named "CustName". Can someone PLEASE walk through that? Thanks,
Warren Shore

[Jeff]

I believe the ODBC sends a null record at the end of datatransmission.
You need to pump the results to a list box then move the data from the list box to an edit box.

If you modify the example on CD#2 you can see the issue
Add an edit box on someplace on the screen and set the text to ColText$( "ODBC", 2) -- In the event line "Can get data" in the Display all group.

When you run the query you will see your list box gets data but when the query is over its a NULL -- Since its set to the last data row.

So to work around it you would need to do what I suggested above.