Naomi:

> I see. You're saying that you had the working code and adding
> just few fields made it stop working? Did you also add few new
> lookup tables (at the top of the code)?
>
> Ok, remove all new fields and verify that it works. Then add
> new fields one by one until it breaks again. That's what I may
> try to do in this situation.
>
> Also are you sure you have less than 254 fields?


I have less than 254 fields in the query.

I think perhaps I will have to pull stuff back out out the query
string to find out what went wrong. I am just being stubborn since
it works from TOAD but there are cracks in my monitor and bruises
on my forehead.

This is the first time I have seen SQLEXEC() return a 1 and not
create a cursor.




Borislav:

> What happens if you run that code from completely separated
> program in IDE?
>
> What is your connection string? (w/o any sensitive info of course)


The one thing is, this is a running application, so I feel that I can
trust stuff like the connection string. It's rather standard stuff:

lcGen_Conn_String = [DRIVER=Microsoft ODBC for Oracle;SERVER=]+ALLTRIM(.cDataSource)+[;UID=xxxx;PWD=xxxx]

*--Open a connection for queries and selection statements.
.nGen_Sel_Handle = SQLSTRINGCONNECT(lcGen_Conn_String)
IF .nGen_Sel_Handle < 0
.SPT_Message('A connection to the server could not be established.',0,'Build_Gen_Db_Connection')
RETURN .F.
ENDIF