ADO

From: Gavin (gavdraper_at_hotmail.com)
Date: 04/05/04

  • Next message: Michael Kochendoerfer: "D5+ADO+Threads" 
    Date: Mon, 5 Apr 2004 08:05:02 +0100

    I have a delphi 5 app that currently stores information locally in dbase
    tables. I have now made a web page that can query the data and display
    results so I want to store a small portion of the data on an sql server on
    the web. I have a librarys that when it writes to a dbase file also stores
    the record to a text file on the local drive. Every 2 hours I want a routine
    to take this file and upload all the records in it to the SQL server. whats
    the best way to do this? AdoQuery? Its only going to be about 30 records a
    day.

  • Next message: Michael Kochendoerfer: "D5+ADO+Threads"

    Relevant Pages

    • Re: TempDB & Performance/Storage space issues
      ... > query, it starts with the first two, joins them & stores the results ... > tempdb, and so on. ... The SQL Server optimizer is cost-based and will try to determine the ... I suggest you take a look at the query execution plan and try to address ...
      (microsoft.public.sqlserver.server)
    • Re: customise primary Key
      ... it all with a SELECT statement and built in SQL Server functions. ... let's say the chain had a total of 1,000 stores. ... Your customer data is an analogous issue. ... Then it's easy to uniquely identify the Party. ...
      (comp.databases.ms-sqlserver)
    • Re: other table that stores data differently than ADO.Net datatable?
      ... query the database everytime the user does a scroll ... will display the next N records once the user has reached the last visible ... > We have this huge application that's based on storing tons of data on a ... > datatable that stores a better way. ...
      (microsoft.public.dotnet.languages.csharp)
    • Re: Synchronous Bulk-Copy into two table
      ... Permit me to remark that the designe does not look good to me. ... INSERT Stores ... WHERE StoredId = @oldstoreid ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
      (comp.databases.ms-sqlserver)
    • Re: other table that stores data differently than ADO.Net datatable?
      ... >>> query the database everytime the user does a scroll (or page up/page ... >>> will display the next N records once the user has reached the last ... >>>> We have this huge application that's based on storing tons of data on ... >>>> datatable that stores a better way. ...
      (microsoft.public.dotnet.languages.csharp)