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