Welcome to Forums Sign in | Join | Help | Forums
in Search





Make the world a better place.
Home Blogs Forums Photos Downloads
Forums » Technical Forums » VBA/API » Data field type and length

Data field type and length

Last post 07-09-2008 11:57 PM by Paul Black. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next

  • 07-09-2008 11:57 PM

    • Paul Black
    • Not Ranked
    • Posts 10
    • Organization: RMIT University
    • Products:  Blackbaud NetCommunity, The Raiser's Edge

    Data field type and length

    Reply Contact
    Hi,
     
    In Education  :  GPA field is set to accept only numeric values and not string or varchars.
     
    I had a look at the education database table in RE (on test system) and GPA field is set to be as numeric. Can change the data type using VB?.
     
    But what I noticed that the degree field was also a numeric field, but it's a lookup.
    Education table stores corresponding  numeric values of degree names and actual degree names are stored in another table.
     
    How can we make GPA field as a lookup? At present it does not allow us to do that in config options.
     
    I also noticed that data length are fixed for example : Campus is fixed to 50 characters only. I checked CAMPUS field in education table in database itself.
     
    Please advise.
     
    Regards,
    Pankaj
Page 1 of 1 (1 items)