BorlandTalk.com

Beto Neto · Guest

At Server Application:

TSQLConnect + TSQLDataSet + TDataSetProvider

Provider.Options has opFetchBlobsOnDemand, opAllowCommandText,
opRetainServerOrder
Provider.UpdateMode as upWhereAll

At Client Application:

TSocketConnect + TClientDataSet

ClientDataSet.CommandText :=
'select p.field1, p.field2 from sp_something(param1, param2) p order by
p.field1';

Now I open it!
Field2 is a TBLOBFIELD. When I invoke Field2.AsString an error occours.
Provider are trying request the data from the blobfield, but I'm already
using opFetchBlobsOnDemand at provider options.

I debug the TSQLDataSet.PSExecuteStatment and I trace an unkown select
stament like this
'select "field1", "field2" from "sp_something" where "field1" = ? and
"field2" = ?'

The provider is trying to request the blob data with another select, and it
is considering the "sp_something" as a TABLE, but it is a StoredProcedure
with params...

What can I do to resolve this "bug"?!
Can I change anything to fix it?

Thank you, a lot!!!

Bye bye!