lol
i didn't know about gettablenames... i tryed to catch
exceptions and the other way was to access
"msysobjects" but was protected...
it works thx :)
--- Jangita <[EMAIL PROTECTED]> wrote:
> Hi there
>
> There are several ways of doing this but I've found
> that this work for me
> most of the time.
>
> I use the TADOConnection.GetTableNames(tables) where
> tables is of type
> tstringlist then I use
> tstringlist.indexof('tablename') to see if its there
> for example
>
>
> Var
> Tables : tstringlist;
> Begin
> Tables:=tstringlist.create;
>
> Adoconnection1.gettablenames(tables);
> If tables.indexof('mytable')>0 then
> Begin
> // table exists
> End
> Else
> Begin
> // whatever if table doesn't exist
> End
>
> Tables.free;
> End
>
> Jangita.
> http://www.jangita.com
> mailto:[EMAIL PROTECTED]
>
>
> -----Original Message-----
> From: [email protected]
> [mailto:[EMAIL PROTECTED] On Behalf
> Of Nighty
> Sent: 07 December 2005 4:28 p
> To: [email protected]
> Subject: [delphi-en] ms access check if table exists
>
> I'm using MS Access, and I have to test by code any
> kind(sql or delphi) if a table exists in the
> database.
> Can you make a function that will return true or
> false
> depending on the existance of the table:string in
> the
> database connected to tado1:tadoconnection?
>
>
>
>
> __________________________________________
> Yahoo! DSL - Something to write home about.
> Just $16.99/mo. or less.
> dsl.yahoo.com
>
>
>
>
>
-----------------------------------------------------
> Home page: http://groups.yahoo.com/group/delphi-en/
> To unsubscribe:
> [EMAIL PROTECTED]
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
__________________________________________
Yahoo! DSL Something to write home about.
Just $16.99/mo. or less.
dsl.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
1.2 million kids a year are victims of human trafficking. Stop slavery.
http://us.click.yahoo.com/.QUssC/izNLAA/TtwFAA/i7folB/TM
--------------------------------------------------------------------~->
-----------------------------------------------------
Home page: http://groups.yahoo.com/group/delphi-en/
To unsubscribe: [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/delphi-en/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
