So you suggest to populate the TMemDataset from the ADO recordset and after
modification save the changes from the TMemDataset back to the ADO
recordset.
That's easy!
Thanks,
Stephan
"Ignacio Ortiz de Zúñiga" <
NoName@xailer.com> wrote in message
news:46f79d97$[email=
1@ozsrv2.ozlan.local...]
1@ozsrv2.ozlan.local...[/email]
> Stephan,
>
> Right now our ADO implementation always checks that a connection ( a
> Datasource) exists. We may change that in the future but I am afraid it
> will provoke important modifications.
>
> I suggest, since you are just using a copy of the data, to retrieve the
> data with CreateOleObject() and use its method GetRows to pass the array
> to a TMemDataSet. I hope it helps.
>
> Regards,
>
> --
> Ignacio Ortiz de Zúñiga
>
http://www.xailer.com
>
>
> "Stephan Hennekens" <
stephan.hennekens@wur.nl> escribió en el mensaje
> news:46f78c49$[email=
1@ozsrv2.ozlan.local...]
1@ozsrv2.ozlan.local...[/email]
>> Ignacio,
>>
>> the connection with the database is at the server site.
>> On the client site you can retrieve an ADO recordset.as follows:
>> oRS := CreateObject("ADODB.Recordset")
>> oRS:Open(
http://www.synbiosys.alterra.nl/nl/getr ... p?sql=SELE CT *
>> FROM customer)
>>
>> // SERVER site code could be something like..
>> cSQL := Request:QueryString["sql"]:Item(1)
>> oCon := CreateObject("ADODB.Connection")
>> oCon:Open(<connectionstring>)
>> oRS := oCon:Execute(cSQL)
>> Response:ContentType := "multipart/mixt"
>> oRS:Save(Response, adPersistADTG)
>> oRS:Close()
>> /////
>>
>> So on the client site a ADO recordset is received, and now I would like
>> to see it in a TSQLTable (in order to display it in TDBBrowse for further
>> processing).
>>
>> Hope this clarifies.
>>
>> Regards,
>> Stephan
>>
>>
>>
>>
>>
>> "Ignacio Ortiz de Zúñiga" <
NoName@xailer.com> wrote in message
>> news:46f775f2$[email=
1@ozsrv2.ozlan.local...]
1@ozsrv2.ozlan.local...[/email]
>>> Stephan,
>>>
>>> I suposse that even on a Web request there should be a connection.
>>> Please
>>> send us a sample on any other language to see what we can do. BTW you
>>> can
>>> always use ADO directly without the Datasource.
>>>
>>> Regards,
>>>
>>> --
>>> Ignacio Ortiz de Zúñiga
>>>
http://www.xailer.com
>>>
>>>
>>> "Stephan Hennekens" <
stephan.hennekens@wur.nl> escribió en el mensaje
>>> news:[email=
46f76dbd@ozsrv2.ozlan.local...]
46f76dbd@ozsrv2.ozlan.local...[/email]
>>>> Ignacio,
>>>>
>>>> I know that ADO supports disconnected recordsets, because I have worked
>>>> with it with other types of applications. I just wondered how I could
>>>> connect a ADO recordset (for example retrieved from a web request) to a
>>>> Xailer dataset and have all the benefits that comes with that. The
>>>> problem is that there is NO database connection.
>>>>
>>>> Regards,
>>>> Stephan
>>>>
>>>> "Ignacio Ortiz de Zúñiga" <
NoName@xailer.com> wrote in message
>>>> news:46f76bc0$[email=
1@ozsrv2.ozlan.local...]
1@ozsrv2.ozlan.local...[/email]
>>>>> Stephan,
>>>>>
>>>>> I believe it can not, but consult ADO documentation.
>>>>>
>>>>> Regards,
>>>>>
>>>>> --
>>>>> Ignacio Ortiz de Zúñiga
>>>>>
http://www.xailer.com
>>>>>
>>>>>
>>>>> "Stephan Hennekens" <
stephan.hennekens@wur.nl> escribió en el mensaje
>>>>> news:46f520e1$[email=
1@ozsrv2.ozlan.local...]
1@ozsrv2.ozlan.local...[/email]
>>>>>> Is TADODataSource capable to work with disconnected recordsets?
>>>>>> Regards,
>>>>>> Stephan
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>>
>
>