Results 1 to 7 of 7
  1. #1
    Join Date
    May 2003
    Posts
    5

    Question Unanswered: Dimensional Arrays in MSSQL 2000

    I am converting a database from Clarion to MSSQL 2000. In the Clarion files we use dimensional arrays. I've seen dimensional arrays mentioned on the forum, but can't find how to set one up in MSSQL 2000. Can anyone help me find some kind of documentation on this, or point me in the right direction?

    Marty

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Refer to this Clarion link for information and also refer to books online for 'sp_OAMethod' and other referenced topics.

    HTH
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    honea, not sure I know what dimesional arrays are with regards to Calrion. As best as I remember Clarion used flat files. If you can provide an explination I will be glad to help if I can.
    Paul Young
    (Knowledge is power! Get some!)

  4. #4
    Join Date
    May 2003
    Posts
    5
    Satya,

    Thank you for the response. I did look up the 'sp_OAMethod', and while it talks about referencing the arrays, I have found no place that talks about actually setting the array up. How do I put an array in the table?

    Marty

  5. #5
    Join Date
    May 2003
    Posts
    5
    Paul,

    In Clarion you would declare a field type and then dimension it. Example:

    mydimlong Long Dim(2,36)

    This would give you a long data type that has 72 possible places to store data. You would then retrieve or put data in by referencing it like this...


    mydimlong[1,1] = 'Male'
    mydimlong[2,1] = 'Female'
    mydimlong[1,2] = somedata
    mydimlong[2,2] = somemoredata

    ETC...

    Marty

  6. #6
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    To my klnowledge there is nothing comperable in MSSQL Server. I would probably set this up as a child table and move on.
    Paul Young
    (Knowledge is power! Get some!)

  7. #7
    Join Date
    May 2003
    Posts
    5
    Thank you Paul,

    I will probably keep the table in clarion for now.

    Marty

Posting Permissions

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