Re: exec sp_password using rawRowsForSQL

2006-04-20 Thread Jerry Haynes
Patrick, your example got me thinking about some code I had used in the past. It works but I still do not get a result from this particular stored procedure. Other Sybase built-in stored procedures that I tried (sp_helpdb is one example) do return a result set. It's a in-house only project

Re: exec sp_password using rawRowsForSQL

2006-04-18 Thread Patrick Middleton
On 13 Apr 2006, at 21:21, Jerry Haynes wrote: Has anyone successfully called sp_password on a Sybase database? Nothing is being returned back to theArray so I have no clue what the problem might be. private NSArray setSybasePassword(String eoModel, String masterPassword, String newPasswo

Re: exec sp_password using rawRowsForSQL

2006-04-13 Thread Jean-François Veillette
You might be better using stored-procedure capacities of eof instead of raw-row. In EOModeler, let the model know about the stored-proc, the input / output fields, etc. That way there is more chance it's going to work. - jfv Le 06-04-13, à 16:21, Jerry Haynes a écrit : Has anyone succes

Re: exec sp_password using rawRowsForSQL

2006-04-13 Thread Chuck Hill
rawRowsForSQL is intended for SQL select statements that return a rowset. I am not familiar with Sybase but I will hazard a guess that whatever you are callling does not have a rowset return result. You might need to dig down to EOAdaptorChannel.evaluateExpression (EOSQLExpression expressi

exec sp_password using rawRowsForSQL

2006-04-13 Thread Jerry Haynes
Has anyone successfully called sp_password on a Sybase database? Nothing is being returned back to theArray so I have no clue what the problem might be. private NSArray setSybasePassword(String eoModel, String masterPassword, String newPassword, String userName) { EOEditingContext