Delphi 7 and SQL/Sybase - tips?

From: rune sovik (rune.soevik_at_verizon.net)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 03:11:23 GMT

Hi there,

I have used Delphi a lot, i.e. I am quite familiar with it (version 7 I now
use) - but I am not familiar with SQL. I need to download data into a Sybase
data base, and extract data from the same data base. I need to put thousands
of rows and columns of data into the data base every day, i.e. we're talking
lots of data here.

Typically, I have a stringgrid or an array of array (matrix) filled with
data, and I need to INSERT or MODIFY this data into the Sybase data tables.

Being rather new to SQL, do you have any good books to recommend that
informs on Delphi and SQL techniques for mass xdata transfer, or how would
you approach this?

Kind regards, Rune, New York

Relevant Pages

  • RE: Invalid cursor state when using PRINT in MSSQL
    ... The server and all the SP's I am running this on is MSSQL and not Sybase. ... MS SQL Server help also mentions that you have to call SQLError right after ...
    (perl.dbi.users)
  • Re: Dateadd in SQL statement not working
    ... Omigod, I thought you said you were using SQL Server, which is what my ... version of SQL used by Jet, which is the database usually used by Access): ... But my confusion is not totally resolved: Why are you using a Sybase ODBC ... driver to connect to either a Jet or a SQL Server database? ...
    (microsoft.public.inetserver.asp.general)
  • Re: Newbie Qs on mass delete processing
    ... "neutral" Update statements to preserve my test data. ... implement dynamic SQL in our 11.9.2 environment! ... Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0 ... "The Complete Sybase Replication Server Quick Reference Guide" ...
    (comp.databases.sybase)
  • Re: SQL Update: How do I get more error information
    ... The data base is a MS Access. ... // Record set for AccountJournalProject view ... // Write it back to the database - if it was changed ... , (SQL ...
    (microsoft.public.data.ado)
  • ANN: VISOCO dbExpress driver for Sybase SQL Anywhere Is Now Available.
    ... SQL Anywhere, a dbExpress driver for Borland Delphi, Kylix, C++ Builder. ... VISOCO dbExpress driver for Sybase SQL Anywhere is based on the Embedded SQL ...
    (borland.public.delphi.thirdpartytools.general)