ClientDataset and SQL queries

From: Aragorn (warcayac_at_yahoo.com)
Date: 03/14/05

  • Next message: Vitali Kalinin: "Re: Help needed, urgent. First does not locate the first record. Findfirst hangs with exception, invalid bookmark." 
    Date: Mon, 14 Mar 2005 10:38:53 -0500

    Hi dude,

    I'm using Delphi 7 Enterprise on WinXP, I've built a C/S app using sockets
    where my DBMS is MS-Access (I have my reasons), when this app was a single
    app
    I used the ADOConecction for executing SQL queries through its EXECUTE
    method, but under this C/S scheme where I must use DataSetProviders and
    ClientDatasets, how can I run these queries? I use those queries for:

    - exporting data to MS-EXCEL (on the client side) using parameters, and
    - modifying (UPDATE) data in DB

    A bonnus question: When refreshing my client-data for seeing changes from
    my DB, I cannot see any change so I have to close the connection then
    re-open
    it for seeing such changes. How to see the changes from my DB using only
    REFRESH method? When do I use ClientDataset's APPLYUPDATES method?

    Thanks,

    Aragorn.

  • Next message: Vitali Kalinin: "Re: Help needed, urgent. First does not locate the first record. Findfirst hangs with exception, invalid bookmark."

    Relevant Pages

    • Re: Access apps with user definable fields?
      ... New fields would need to added to tables, queries, ... Of course they have their own built in report writer ... > I have an app I built for nonprofits who provide FREE ... > add control switches to control whether certain fields are displayed or ...
      (microsoft.public.access.formscoding)
    • Re: Access apps with user definable fields?
      ... Of course they have their own built in report writer so impact on queries and reports isn't so great. ... Most I have seen use the user definable field approach where the user definable fields already exist. ... I have an app I built for nonprofits who provide FREE food, clothes and financial assistance such as prescriptions and to avoid utility cutoff, etc. ... Instead what I now do is add new fields that others won't mind that for really unique fields, I add control switches to control whether certain fields are displayed or not. ...
      (microsoft.public.access.formscoding)
    • Re: membership provider
      ... the user only if the user exists in the DB then doing a redirect to the next ... When I stepped through the current app I noticed what he's doing just on the ... running 7 more queries to pull data and put into a user object then passing ... I think your login screen needs to use the custom provider.. ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Cannot open any more databases and splitting databases
      ... split your database into a front-end and a back-end. ... Only if your app is badly designed to begin with, ... was that excessive use of nested queries can ... a form's recordsource. ...
      (microsoft.public.access.modulesdaovba)
    • Re: Replacing SQL with XML
      ... But, earlier in the design of our app, we discovered that the nit picky ... It seems that we could not call the queries the same way so we ended ... > Hi Norton ... >> The problem with MSDE is that if you have to install it, ...
      (microsoft.public.dotnet.xml)