I am trying to add a command to interactively modify a connection from within a program. However, when I do so the code after my MODI CONN statement does not wait for this command to clear. Am I missing something?
Sample code...
OPEN DATA
lvalid = .F.
liscanc = .F.
DO WHILE NOT lvalid AND NOT liscanc
lvalid = SQLCONNECT('myConnection') > 0
liscanc = MESSAGEBOX('Invalid ODBC Connection, please correct',49) = 2
IF NOT liscanc
MODI CONNECTION ?
ENDIF
=sqldisconnect(0)
ENDDO
return(lvalid)