Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 5 of 5 total |
Dropping Memory Tables |
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. |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |