Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "Wolfgang Riedmann" Newsgroups: comp.lang.clipper.visual-objects Subject: Re: SetFilter cancels the default rdd Date: Mon, 5 Aug 2013 20:55:28 +0200 Lines: 28 Message-ID: References: <0018e291-a145-40e5-91fe-258609fc9d07@googlegroups.com> <1ae32ad4-44e8-4c02-bf2f-b3edab90a5cd@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 X-Trace: individual.net aA++b1W/IjunS30Bqrnqpgu9NyE58SyZmZlNfXqf8wRsF34sI= Cancel-Lock: sha1:cr4RMiWSFYjavIJ2G1kSei+eGvQ= User-Agent: XanaNews/1.18.1.6 Xref: csiph.com comp.lang.clipper.visual-objects:5650 Hi Krystian, > Thank you for "enlightenment" me - up to now I worked with medium > dbf's (< 100000) and max 4,5 persons from one department. Now I must > prepare a program for many people from many departments, cooperating > with my old one. I think, that I should to become familiar with sql - > I do not escape from that architecture. I do not know the shortcut > of ADS - what is this ? ADS is Advantage Database Server - a commercial database server that is available as VO, Vulcan and Clipper RDD. There are some changes in filters and some other minor issues to change, but for the normal operation if works like DBFCDX, only faster and without data corruption. One of my large clients has a 45 user installation running - with normally 30-40 people accessing the database at the same time. ADS is not cheap, but cheaper than rewrite the applications. I don't use bBrowser with SQL - for SQL access I use only ListViews because the data volume is fixed and will not change when the underlying data changes. It is not so dynamic as DBF. Wolfgang --