Hi
I had a interview qn like this
How to access a recordset without connection in vb6?
what is that technique called?

Can anyone help me?


Jelfy


Thanks
Jelfy

__________________
Thanks
Jelfy

.. disconnected recordset ?

Marco

In short you fill a recordset with data, then break the connection (disconnect it). So you can work on the data with your local program. Once you are done with the data you connect to the database and send it your changes.

Hope this helps.

There is some name to that technique.whats it?

I think what u said only ADO does ,is it so?
In ado whether aftergetting recordeset is it automatically disconnecting?



Thanks
Jelfy

Hello,

There is a way and it is called Fabricated Recordset Object.

Here you can open recordset without connection, add fields,
add data, save them and reuse it. even you can bind the data
to flexgrids.



With Regards,
Raghavendra Mudugal

Thanks,You r right.
But how can i use that feature,can u explain?



Thanks
Jelfy

Okay, here the sample of this FRO. Check this out. Hope it will helps.

http://www.geocities.com/raghavendra...teRecrdset.zip


With Regards,
Raghavendra Mudugal

How to open the dat file to view its contents (other than the program used)?

Here in
rst.Open App.Path & "\data1.dat", "Provider=MSPersist;", adOpenForwardOnly, adLockBatchOptimistic, adCmdFile

y u used batchoptimistic and,adcmdFile?
is it compulsory to give that ?


Thanks
Jelfy

adPersistADTG for what this is used?
without adcmdfile also its working then y its given?
Pls answer my qns?

Thanks
Jelfy

Hello

adOpenForwardOnly, adLockBatchOptimistic, adCmdFile

these are the terms to open a recordset,

adOpenForwardOnly:
Opens a forward-only–type cursor (it is used for the faster
process)

adLockBatchOptimistic:
required for batch update mode as opposed to immediate update mode. (in case to edit the data and save them back)

adCmdFile:
Its aoptional value , that to know the recordset its opening a
physical hard file from the harddisk and it is not a database.

adPersistADTG:
It is the way that recordset will save the data and its is by
default. ot you can use adPersistXML (it is not shown, but change the adPersistADTG to adPersistXML) and see the data
in the XML format.

And the data stored in the adPersistADTG format, as of i know
you cannot open the file in another application to viwe the
content. you have to look inside through the recordset itsself.

And for adPersistXML (if you use this) it can be viewed through
opening that file in the Internet explorer, and by another
application which known how handle the XML data structure.
(say for example C++ DSO which can used in the HTML file to
view the content of that XML file.)

Hope this helps.

With Regards,
Raghavendra Mudugal