Subject Mainly SQL help needed
Author John Hart

Sorry about the last email it somehow got sent before
I even changed the subject.

Thank you Helen, your last advice worked wonders but
now I need some more help.

1) I want to extract data from an MSSQL 2000 batabase
and load it into Interbase, it is very very slow about
10 records a second. Currently I use a Findnext loop
(BDE) and in the loop Insert/Post to interbase (IBO).

2) How do I check, in Delphi, if a table or trigger
etc exists.

3) How do I assign the result of 'Select count(*) from
Student' to a Delphi variable.

4) How do I obtain the date from the 'Datepick'

I borrowed three SQL manuals from the Uni library but
they did not have the answer.

Thank you

John Hart
Macquarie Training Centre

Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games