RemObjects SQL execution is not supported yet! Help

I have a delphi DA server and I want to connect to a DA SQL ASP client and I get this error

RemObjects SQL execution is not supported yet!

Help

DA SQL is only supported on .NET Servers a s Relativity Server. It should be usable from Delphi clients, though.

Another alternative to do what you i want?

you can use Dynamic Where and Dynamic Select to limit your queries. Eugene will be able to help you with a more concrete example, tomorrow.

Hi,

you can use SQLGetData method of DAService.

I have attached outdated sample from DA6: Dynamic SQL.zip (41.7 KB)
it should show this functionality but will require some changes for compatibility with DA9 like replacing Utf8String with ROUtf8String, etc

this does sql passthrough though and. glasses da security, right?

it sends plain SQL as is

Exactly, so that’s not really a solution. it’s a hack from the olden days before we had DA SQL and Dynamic Where/Select, and is unsafe. It should not be enabled.

DA SQL isn’t supported by DAD servers

Right. That’s what I said in my initial reply.

Thank you very much everyone for your prompt response