Is it possible to use prepared statement in DataGrid SQL?

[yshld]

Hi,

I have a DataGrid and it will be refreshed frequently. Is it possible to use a prepared statement is the SQL property? I cannot figure it out how to do it in Architect? Can anyone give any suggestion?

Thanks!

[RJSamp · Accepted solution]

Absolutely.....run your stored proc, native client table functions, etc. into an ADO Recordset....then slam the record set into the grid. No need to use SQL property at all.

The SLX OLE DB Provider can't handle any of this.....so you'll have to use your own native connection to the database to create your recordset.....we go after sysdba as we know the password....

[yshld]

Unfortunately, we don't have the access to the dba account to create the connection. We have to use the SLX OLE DB provider to deal with database activities. So that means we cannot use the prepared statement. Thanks a lot for your reply.