Using a Creator can I check for the existence of a table? Or do I need to try and create a Table or Editor object instead? Is there a specific function that does the check or is it a case of attempting to create a Table or Editor, if that fails assume the table doesn't exist and then get a Creator?



Thanks,

Tommy

Unfortunately, there is no function that checks if a table exists or not at the moment.

You can do something like

or you can check if the .def file exists.

Ivan
-----
Iyengar Yoga Resources / GT Plugins

Thanks Yogi, I'll give that a bash.

Basically, if you look at the install.pm of some of GT's plugins, you attempt to do what you want to do, then read the error messages to see what went wrong.

You can always attempt to connect to a table, and if that fails, attempt to create it. If the creation fails, you know there is some sort of database problem. If the creation succeeds, you know you've successfully created it.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.

Is there a way to check for table existance in 3.x?
RGB World, Inc. - Software & Web Development.
rgbworld.com

I hope Ian wont mind as I think this is his code but this is what I use to check for a table:

sub hastable {
#---------------------------
# Determine if a table exists
# Return true if it does.
my $table = shift;
my $exists = 0;

my $def_path = "$CFG->{admin_root_path}/defs/" . $DB->prefix() . "$table.def";

if (-e $def_path) { $exists = 1; }

return $exists;
}


then in your script you can use

if ( hastable('TableName')) {print 'TableName table found.<br>'; } else {create table...}