Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2015
    Posts
    1

    Unanswered: Restructure Field Type

    I'm trying to restructure a field from Memo to Alpha, but I'm stuck. Here is my script so far. Where am I going wrong?

    Var
    tbl4 Table
    TcFlds2 Tcursor
    Endvar


    tbl4.attach("roject:03 Door Note.db")
    tbl4.enumFieldStruct("field_struct2.db")
    tbl4.enumIndexStruct ("ind_Struct2.db")

    tcFlds2.open("field_struct2.db")
    tcFlds2.edit()

    scan tcFlds2 :
    if tcFlds2."Field Name" = "Note" then
    tcFlds2."Field Name" = "Note,A,120"
    quitLoop
    endif
    endscan

    tcFlds2.endEdit()
    tcFlds2.close()

    endMethod

  2. #2
    Join Date
    Dec 2007
    Posts
    375
    late reply, but..

    you're trying to change a record in the "struct" table you made, not the actual "structure" of the table.. most Paradox help is found at the "paradox community" site..

    www.thedbcommunity.com/support
    --
    Steven Green - Myrtle Beach, South Carolina USA

    http://www.OasisTradingPost.com

    Oasis Trading Post
    - Collectibles and Memorabilia
    - Vintage Lego Sets and Supplies
    - and Paradox Support, too

  3. #3
    Join Date
    Sep 2017
    Location
    USA
    Posts
    2

    Restructure Field Type

    I have a field, "Meet3 Time" in the table "Boys" that is of type Time with a custom format MMS
    It displays correctly with this simple query:
    SELECT "Meet3 Time" FROM "Boys"

    but reverts to the Time format HH:MMS which was the previous format in the following query:
    SELECT "C"."Meet3 Time" FROM "Boys" "C"

    Why is this and what can I do to get my MMS format in the second query? The second query is a simplified version of the actual query that I need.

    Thanks,
    Stan

  4. #4
    Join Date
    Dec 2007
    Posts
    375
    are you trying to do a SQL query within Paradox, or are you querying a Paradox table in another environment?
    --
    Steven Green - Myrtle Beach, South Carolina USA

    http://www.OasisTradingPost.com

    Oasis Trading Post
    - Collectibles and Memorabilia
    - Vintage Lego Sets and Supplies
    - and Paradox Support, too

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •