Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
Tuned Listener
Posts: 67
Registered: ‎11-29-2011
Accepted Solution

Is it possible to use prepared statement in DataGrid SQL?

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!

Highlighted
Silver Contributor
Posts: 835
Registered: ‎03-24-2009

Re: Is it possible to use prepared statement in DataGrid SQL?

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....

RJ Samp
Highlighted
Tuned Listener
Posts: 67
Registered: ‎11-29-2011

Re: Is it possible to use prepared statement in DataGrid SQL?

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.