Re: Create a table in runtime

From: Sietse Wijnker (sietse.wijnker_at_ATsw-software.nl)
Date: 11/18/04

  • Next message: Cindy Winegarden: "Re: How to free a dbf table if dbc file is missing" 
    Date: Thu, 18 Nov 2004 17:05:21 +0100

    Hi Eusebio,
    If you're using vfp7+:
    =Execscript(strCadCreate)

    You can even create indexes in the same script:
    TEXT TO strCadCreate NOSHOW
    create table Txx ( campo1 C(10), c2 C(10))
    INDEX ON campo1 tag campo
    RETURN USED("Txx")
    ENDTEXT
    boolSuccess=Execscript(strCadCreate)

    The statement currently in the string will fail. You need to specify the
    type.

    HTH,
    Sietse Wijnker

    "Eusebio" <SpamHere@hotmail.com> wrote in message
    news:emocHhKzEHA.2200@TK2MSFTNGP09.phx.gbl...
    > Hi,
    >
    > I need to create a table in runtime, the definition's table is in a
    > variable.
    >
    > strCadCreate = "create table Txx ( campo1 type, c2 type ) "
    > I need to execute the CREATE TABLE statement strCadCreate
    >
    > how I do?
    >
    >

  • Next message: Cindy Winegarden: "Re: How to free a dbf table if dbc file is missing"