- You can get a whole lot of information about your database (i.e. if a
table exists) the TIB_Connection.SchemaCache property. Have a look in your
IBO help file.

- To put the result from a SELECT COUNT(*) in a variable do something like
this:

var
CountVariable: Integer;
begin
CountVariable := MyTable.FieldByName('COUNT').AsInteger;
end;

To get the date from the TIBODatePicker compononent you can do something
like this:
var
MyDate: TDateTime;
begin
MyDate := MyDatePicker.Date;
end;


- Hope this helps:

Best Regards,
Don Schoeman


-----Original Message-----
From: akahanek@... [mailto:akahanek@...]
Sent: 22 February 2002 14:16
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Mainly SQL help needed


I extracted data from MSSQL 2000 too with help of free utility SQL2GDB.
It is very handy and easy to use. In converts all metadata including
triggers, autoincrement fields etc. correctly. Moves data too. You can
find it at www.ibphoenix.com somewhere in the download section, I think.
Ales

> -----Original Message-----
> From: John Hart [mailto:macquarietc@...]
> Sent: Friday, February 22, 2002 12:58 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Mainly SQL help needed
>
>
> Hi,
>
> 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'
> component.
>
> 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
> http://sports.yahoo.com
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Sponsored by VeriSign - The Value of Trust
> When building an e-commerce site, you want to start with a
> secure foundation. Learn how with VeriSign's FREE Guide.
> http://us.click.yahoo.com/oCuuSA/XdiDAA/yigFAA/PhFolB/TM
> --------------------------------------------------------------
> -------~->
>
> ______________________________________________________________
> _____________
> IB Objects - direct, complete, custom connectivity to
> Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ______________________________________________________________
> _____________
> http://www.ibobjects.com - your IBO community resource for
> Tech Info papers,
> keyword-searchable FAQ, community code contributions and more
> !
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/