Support Forums - View Thread

View Thread

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

Messages 1 to 5 of 5 total

Thu, Apr 2 2009 9:22 AM	Permanent Link
Bill	I need specifics on dropping memory tables. What component is used? ie: Drop Table IF Exists "MEMORY\Tab1" or ?????? How to call the SQL? Thanks in advance. Bill
Thu, Apr 2 2009 9:33 AM	Permanent Link
"John Hay"	Bil > I need specifics on dropping memory tables. > What component is used? > > ie: Drop Table IF Exists "MEMORY\Tab1" or ?????? > > How to call the SQL? If this is in delphi use a DBISAMQuery. Query.Clear; Query.Add('Drop Table IF Exists "MEMORY\Tab1"'); Query.ExecSql; John
Thu, Apr 2 2009 9:36 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Bill >I need specifics on dropping memory tables. >What component is used? TDBISAMQuery with the sql you've shown below. >ie: Drop Table IF Exists "MEMORY\Tab1" or ?????? > >How to call the SQL? query.ExecSQL; Roy Lambert [Team Elevate]
Thu, Apr 2 2009 10:02 AM	Permanent Link
Bill	"John Hay" wrote: Bil > I need specifics on dropping memory tables. > What component is used? > > ie: Drop Table IF Exists "MEMORY\Tab1" or ?????? > > How to call the SQL? If this is in delphi use a DBISAMQuery. Query.Clear; Query.Add('Drop Table IF Exists "MEMORY\Tab1"'); Query.ExecSql; John Thanks, john. This helps.
Thu, Apr 2 2009 10:03 AM	Permanent Link
Bill	Roy Lambert wrote: Bill >I need specifics on dropping memory tables. >What component is used? TDBISAMQuery with the sql you've shown below. >ie: Drop Table IF Exists "MEMORY\Tab1" or ?????? > >How to call the SQL? query.ExecSQL; Roy Lambert [Team Elevate] Thanks, Roy. I think I got it.