TADODataSource

[Stephan Hennekens]

Is TADODataSource capable to work with disconnected recordsets?
Regards,
Stephan

[ignacio]

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
>

[NoName]

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
>

[Stephan Hennekens]

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

[Stephan Hennekens]

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

[ignacio]

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

[NoName]

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

[Stephan Hennekens]

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

[Stephan Hennekens]

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

[ignacio]

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

[NoName]

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

[Stephan Hennekens]

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

[Stephan Hennekens]

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

[notengo]

Stephan,
> 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.
A friend asked for help to do the same as you but I never worked ADO that way.
The idea of Ignacio seems very good so, if you agree, you could send me
some working code when you have it and I could write a native Xailer
component. What do you think ?
Regards,
José Lalí­n

[notengo]

Stephan,
> 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.
A friend asked for help to do the same as you but I never worked ADO that way.
The idea of Ignacio seems very good so, if you agree, you could send me
some working code when you have it and I could write a native Xailer
component. What do you think ?
Regards,
José Lalí­n

[Stephan Hennekens]

I think that's a very good idea José. So with this component it will be easy
to retrieve (disconnected) recordsets from a webdatabase, and also send them
back to server.
Yes, I can provide code to retrieve from and send back to the server.
I'll provide the code tomorrow.
Regards,
Stephan
"José Lalín" <notengo@correo.com> wrote in message
news:46fabb90$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
>
> Stephan,
>
>> 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.
>
> A friend asked for help to do the same as you but I never worked ADO that
> way.
>
> The idea of Ignacio seems very good so, if you agree, you could send me
> some working code when you have it and I could write a native Xailer
> component. What do you think ?
>
> Regards,
> José Lalín

[Stephan Hennekens]

I think that's a very good idea José. So with this component it will be easy
to retrieve (disconnected) recordsets from a webdatabase, and also send them
back to server.
Yes, I can provide code to retrieve from and send back to the server.
I'll provide the code tomorrow.
Regards,
Stephan
"José Lalín" <notengo@correo.com> wrote in message
news:46fabb90$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
>
> Stephan,
>
>> 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.
>
> A friend asked for help to do the same as you but I never worked ADO that
> way.
>
> The idea of Ignacio seems very good so, if you agree, you could send me
> some working code when you have it and I could write a native Xailer
> component. What do you think ?
>
> Regards,
> José Lalín

[notengo]

Stephan,
> I think that's a very good idea José. So with this component it will be easy
> to retrieve (disconnected) recordsets from a webdatabase, and also send them
> back to server.
> Yes, I can provide code to retrieve from and send back to the server.
> I'll provide the code tomorrow.
Many thanks for your help with this !
Regards,
José Lalí­n

[notengo]

Stephan,
> I think that's a very good idea José. So with this component it will be easy
> to retrieve (disconnected) recordsets from a webdatabase, and also send them
> back to server.
> Yes, I can provide code to retrieve from and send back to the server.
> I'll provide the code tomorrow.
Many thanks for your help with this !
Regards,
José Lalí­n

[Stephan Hennekens]

José,
Sooner than I expected I have put together some code. There are two files,
one with code for the client and one for code on the (web)server. Each file
contains code for retrieving and saving ADO recordsets.
The code was initially written for UltimADE applications, which is a COM
based enviroment using clipper alike script. I also have Delphi clients
working with this kind of code. The code is not bullet prove, but I am sure
you can make it more save.
If you want I give you an internet address for retrieving data, but I prefer
to send the address to your private mail box.
Kind regards.
Stephan
"José Lalín" <notengo@correo.com> wrote in message
news:[email=46fac806@ozsrv2.ozlan.local...]46fac806@ozsrv2.ozlan.local...[/email]
>
> Stephan,
>
>> I think that's a very good idea José. So with this component it will be
>> easy
>> to retrieve (disconnected) recordsets from a webdatabase, and also send
>> them
>> back to server.
>> Yes, I can provide code to retrieve from and send back to the server.
>> I'll provide the code tomorrow.
>
> Many thanks for your help with this !
>
> Regards,
> José Lalín


Attached files Clientcode.txt (1.7 KB)Â Servercode.txt (1.8 KB)Â

[Stephan Hennekens]

José,
Sooner than I expected I have put together some code. There are two files,
one with code for the client and one for code on the (web)server. Each file
contains code for retrieving and saving ADO recordsets.
The code was initially written for UltimADE applications, which is a COM
based enviroment using clipper alike script. I also have Delphi clients
working with this kind of code. The code is not bullet prove, but I am sure
you can make it more save.
If you want I give you an internet address for retrieving data, but I prefer
to send the address to your private mail box.
Kind regards.
Stephan
"José Lalín" <notengo@correo.com> wrote in message
news:[email=46fac806@ozsrv2.ozlan.local...]46fac806@ozsrv2.ozlan.local...[/email]
>
> Stephan,
>
>> I think that's a very good idea José. So with this component it will be
>> easy
>> to retrieve (disconnected) recordsets from a webdatabase, and also send
>> them
>> back to server.
>> Yes, I can provide code to retrieve from and send back to the server.
>> I'll provide the code tomorrow.
>
> Many thanks for your help with this !
>
> Regards,
> José Lalín


Attached files Clientcode.txt (1.7 KB)Â Servercode.txt (1.8 KB)Â

[notengo]

Stephan,
> Sooner than I expected I have put together some code. There are two files,
> one with code for the client and one for code on the (web)server. Each file
> contains code for retrieving and saving ADO recordsets.
> The code was initially written for UltimADE applications, which is a COM
> based enviroment using clipper alike script. I also have Delphi clients
> working with this kind of code. The code is not bullet prove, but I am sure
> you can make it more save.
Many thanks. Once I got some spare time I'll look into this.
> If you want I give you an internet address for retrieving data, but I prefer
> to send the address to your private mail box.
I'll ask you as soon I work on it.
Regards,
José Lalí­n

[notengo]

Stephan,
> Sooner than I expected I have put together some code. There are two files,
> one with code for the client and one for code on the (web)server. Each file
> contains code for retrieving and saving ADO recordsets.
> The code was initially written for UltimADE applications, which is a COM
> based enviroment using clipper alike script. I also have Delphi clients
> working with this kind of code. The code is not bullet prove, but I am sure
> you can make it more save.
Many thanks. Once I got some spare time I'll look into this.
> If you want I give you an internet address for retrieving data, but I prefer
> to send the address to your private mail box.
I'll ask you as soon I work on it.
Regards,
José Lalí­n