ADO loadfromfile

[Gene G.]

I start with a ado select query connected to a SQL Server 2000 database. I
open the query and fill the dataset.
I then save that dataset to a file. If I then nil the connection to the
server and then myquery.loadfromfile, I can never
reconnect that query to the server. My research suggests that the
Tadoquery's Tcustomadodataset.properties of commandtype and commandtext are
changed to accommodate a file load. After that all opens are to the filename
stored.
These properties are protected and I haven't found a way to reset them and
get the my query reconnected to the server.
Anyone have any ideas?

thanks,
Gene G.

[Luis E. Canga]

When you save to file, the commandtype property becomes cmdfile and the
command text becomes your filename. This property are not protected, you can
change it freely, but you may lost data or becomes confused using this
approach, why don't use ClientDataset (fror free as long as you don't
transfer data using MIDAS between two different machines)?

Regards
Eduardo

Gene G. <ggri...@pci-dahl.com> escribió en el mensaje de noticias
3aa6283a$1_2@dnews...