Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Mon, Jan 29 2007 5:27 PM	Permanent Link
Steve Forbes Team Elevate	Hi Tim, The TDBISAMTable component had an Exists method, what is the TEDBTable equivalent, or how do I go about checking for the table's existence using a code based (rather than SQL based) approach? -- Best regards Steve
Mon, Jan 29 2007 6:43 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Steve, << The TDBISAMTable component had an Exists method, what is the TEDBTable equivalent, or how do I go about checking for the table's existence using a code based (rather than SQL based) approach? >> Well, you could check the list returned by the TEDBSession.GetTableNames method, but frankly I would always suggest using a direct SQL query on the catalog to determine if a table exists. -- Tim Young Elevate Software www.elevatesoft.com
Mon, Jan 29 2007 6:55 PM	Permanent Link
Steve Forbes Team Elevate	Hi Tim, Thanks. > but frankly I would always suggest using a direct SQL query on the catalog > to determine if a table exists. Yes, I agree, ... but I am trying to write a purely code-based approach <wink, wink> and didn't want to mix metaphors, so I guess I'll use the Session method. -- Best regards Steve "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message news:2ED0FE8E-73C8-45FD-9189-98DFAAB6F18C@news.elevatesoft.com... > Steve, > > << The TDBISAMTable component had an Exists method, what is the TEDBTable > equivalent, or how do I go about checking for the table's existence using > a code based (rather than SQL based) approach? >> > > Well, you could check the list returned by the TEDBSession.GetTableNames > method, but frankly I would always suggest using a direct SQL query on the > catalog to determine if a table exists. > > -- > Tim Young > Elevate Software > www.elevatesoft.com >