Search Unity

  1. Megacity Metro Demo now available. Download now.
    Dismiss Notice
  2. Unity support for visionOS is now available. Learn more in our blog post.
    Dismiss Notice

Null Dataset Returned

Discussion in 'Scripting' started by mholmes, May 4, 2021.

  1. mholmes

    mholmes

    Joined:
    Dec 8, 2012
    Posts:
    414
    I have a fairly large dataset that is all Long values coming from my API/Database. When I debug the API, it returns a data table correctly but when it hits Unity it says its Null. I only seen this a few times when the data table was too large. Is there a limit in 2019? If so is there a way I can allow large amounts of dat

    SQL:
    Code (CSharp):
    1. ,[Email]
    2.       ,[Blank_Scroll]
    3.       ,[Bottle_Of_Healing_I_Scroll]
    4.       ,[Bottle_Of_Healing_II_Scroll]
    5.       ,[Bottle_Of_Healing_III_Scroll]
    6.       ,[Bottle_Of_Poison_I_Scroll]
    7.       ,[Bottle_Of_Poison_II_Scroll]
    8.       ,[Bottle_Of_Poison_III_Scroll]
    9.       ,[Bottle_Of_Mana_I_Scroll]
    10.       ,[Bottle_Of_Mana_II_Scroll]
    11.       ,[Bottle_Of_Mana_III_Scroll]
    12.       ,[Bottle_Of_Rejuvenation_I_Scroll]
    13.       ,[Bottle_Of_Rejuvenation_II_Scroll]
    14.       ,[Bottle_Of_Rejuvenation_III_Scroll]
    15.       ,[Bottle_Of_Toxic_Waste_I_Scroll]
    16.       ,[Bottle_Of_Toxic_Waste_II_Scroll]
    17.       ,[Bottle_Of_Ice_I_Scroll]
    18.       ,[Bottle_Of_Ice_II_Scroll]
    19.       ,[Bottle_Of_Ice_III_Scroll]
    20.       ,[Bottle_Of_Fire_I_Scroll]
    21.       ,[Bottle_Of_Fire_II_Scroll]
    22.       ,[Bottle_Of_Fire_III_Scroll]
    23.       ,[Bottle_Of_Magical_Harm_I_Scroll]
    24.       ,[Bottle_Of_Magical_Harm_II_Scroll]
    25.       ,[Polished_Ancient_Stone_Scroll]
    26.       ,[Rune_a_Scroll]
    27.       ,[Rune_da_Scroll]
    28.       ,[Rune_ja_Scroll]
    29.       ,[Rune_ka_Scroll]
    30.       ,[Rune_ma_Scroll]
    31.       ,[Rune_na_Scroll]
    32.       ,[Rune_pa_Scroll]
    33.       ,[Rune_ra_Scroll]
    34.       ,[Rune_sa_Scroll]
    35.       ,[Rune_ta_Scroll]
    36.       ,[Rune_wa_Scroll]
    37.       ,[Rune_za_Scroll]
    38.       ,[Rune_e_Scroll]
    39.       ,[Rune_de_Scroll]
    40.       ,[Rune_je_Scroll]
    41.       ,[Rune_ke_Scroll]
    42.       ,[Rune_me_Scroll]
    43.       ,[Rune_ne_Scroll]
    44.       ,[Rune_pe_Scroll]
    45.       ,[Rune_qe_Scroll]
    46.       ,[Rune_re_Scroll]
    47.       ,[Rune_se_Scroll]
    48.       ,[Rune_te_Scroll]
    49.       ,[Rune_we_Scroll]
    50.       ,[Rune_ze_Scroll]
    51.       ,[Rune_i_Scroll]
    52.       ,[Rune_di_Scroll]
    53.       ,[Rune_ki_Scroll]
    54.       ,[Rune_mi_Scroll]
    55.       ,[Rune_ni_Scroll]
    56.       ,[Rune_pi_Scroll]
    57.       ,[Rune_qi_Scroll]
    58.       ,[Rune_ri_Scroll]
    59.       ,[Rune_si_Scroll]
    60.       ,[Rune_ti_Scroll]
    61.       ,[Rune_wi_Scroll]
    62.       ,[Rune_o_Scroll]
    63.       ,[Rune_do_Scroll]
    64.       ,[Rune_jo_Scroll]
    65.       ,[Rune_ko_Scroll]
    66.       ,[Rune_mo_Scroll]
    67.       ,[Rune_no_Scroll]
    68.       ,[Rune_po_Scroll]
    69.       ,[Rune_qo_Scroll]
    70.       ,[Rune_ro_Scroll]
    71.       ,[Rune_so_Scroll]
    72.       ,[Rune_to_Scroll]
    73.       ,[Rune_wo_Scroll]
    74.       ,[Rune_zo_Scroll]
    75.       ,[Rune_u_Scroll]
    76.       ,[Rune_du_Scroll]
    77.       ,[Rune_ku_Scroll]
    78.       ,[Rune_mu_Scroll]
    79.       ,[Rune_nu_Scroll]
    80.       ,[Rune_pu_Scroll]
    81.       ,[Rune_ru_Scroll]
    82.       ,[Rune_su_Scroll]
    83.       ,[Rune_tu_Scroll]
    84.       ,[Rune_zu_Scroll]
    85.       ,[Magical_Harm_I_Scroll]
    86.       ,[Magical_Harm_II_Scroll]
    87.       ,[Magical_Harm_III_Scroll]
    88.       ,[Fear_I_Scroll]
    89.       ,[Fear_II_Scroll]
    90.       ,[Fear_III_Scroll]
    91.       ,[Acid_I_Scroll]
    92.       ,[Acid_II_Scroll]
    93.       ,[Acid_III_Scroll]
    94.       ,[Magical_Arrow_I_Scroll]
    95.       ,[Magical_Arrow_II_Scroll]
    96.       ,[Magical_Arrow_III_Scroll]
    97.       ,[Magical_Armor_I_Scroll]
    98.       ,[Magical_Armor_II_Scroll]
    99.       ,[Magical_Armor_III_Scroll]
    100.       ,[Wind_I_Scroll]
    101.       ,[Wind_II_Scroll]
    102.       ,[Wind_III_Scroll]
    103.       ,[Mana_I_Scroll]
    104.       ,[Mana_II_Scroll]
    105.       ,[Mana_III_Scroll]
    106.       ,[Mana_Vampire_I_Scroll]
    107.       ,[Mana_Vampire_II_Scroll]
    108.       ,[Mana_Vampire_III_Scroll]
    109.       ,[Agility_I_Scroll]
    110.       ,[Agility_II_Scroll]
    111.       ,[Agility_III_Scroll]
    112.       ,[Strength_I_Scroll]
    113.       ,[Strength_II_Scroll]
    114.       ,[Strength_III_Scroll]
    115.       ,[Wisdom_I_Scroll]
    116.       ,[Wisdom_II_Scroll]
    117.       ,[Wisdom_III_Scroll]
    118.       ,[Fire_I_Scroll]
    119.       ,[Fire_II_Scroll]
    120.       ,[Fire_III_Scroll]
    121.       ,[Fireball_I_Scroll]
    122.       ,[Fireball_II_Scroll]
    123.       ,[Fireball_III_Scroll]
    124.       ,[Steamy_Shower_I_Scroll]
    125.       ,[Steamy_Shower_II_Scroll]
    126.       ,[Steamy_Shower_III_Scroll]
    127.       ,[Hot_Shower_I_Scroll]
    128.       ,[Hot_Shower_II_Scroll]
    129.       ,[Hot_Shower_III_Scroll]
    130.       ,[Flaming_Armor_I_Scroll]
    131.       ,[Flaming_Armor_II_Scroll]
    132.       ,[Flaming_Armor_III_Scroll]
    133.       ,[Ice_I_Scroll]
    134.       ,[Ice_II_Scroll]
    135.       ,[Ice_III_Scroll]
    136.       ,[Snowball_I_Scroll]
    137.       ,[Snowball_II_Scroll]
    138.       ,[Snowball_III_Scroll]
    139.       ,[Snow_Showers_I_Scroll]
    140.       ,[Snow_Showers_II_Scroll]
    141.       ,[Snow_Showers_III_Scroll]
    142.       ,[Cold_Shower_I_Scroll]
    143.       ,[Cold_Shower_II_Scroll]
    144.       ,[Cold_Shower_III_Scroll]
    145.       ,[Ice_Armor_I_Scroll]
    146.       ,[Ice_Armor_II_Scroll]
    147.       ,[Ice_Armor_III_Scroll]
    148.       ,[Poison_I_Scroll]
    149.       ,[Poison_II_Scroll]
    150.       ,[Poison_III_Scroll]
    151.       ,[Poisonous_Spray_I_Scroll]
    152.       ,[Poisonous_Spray_II_Scroll]
    153.       ,[Poisonous_Spray_III_Scroll]
    154.       ,[Antidote_I_Scroll]
    155.       ,[Antidote_II_Scroll]
    156.       ,[Antidote_III_Scroll]
    157.       ,[Antidote_Spray_I_Scroll]
    158.       ,[Antidote_Spray_II_Scroll]
    159.       ,[Antidote_Spray_III_Scroll]
    160.       ,[Paralyzer_I_Scroll]
    161.       ,[Paralyzer_II_Scroll]
    162.       ,[Paralyzer_III_Scroll]
    163.       ,[Immunity_I_Scroll]
    164.       ,[Immunity_II_Scroll]
    165.       ,[Immunity_III_Scroll]
    166.       ,[Healing_I_Scroll]
    167.       ,[Healing_II_Scroll]
    168.       ,[Healing_III_Scroll]
    169.       ,[Blood_Lust_I_Scroll]
    170.       ,[Blood_Lust_II_Scroll]
    171.       ,[Blood_Lust_III_Scroll]
    172.       ,[Rejuvenation_I_Scroll]
    173.       ,[Rejuvenation_II_Scroll]
    174.       ,[Rejuvenation_III_Scroll]
    175.       ,[Resurrection_I_Scroll]
    176.       ,[Resurrection_II_Scroll]
    177.       ,[Resurrection_III_Scroll]
    178.       ,[Light_I_Scroll]
    179.       ,[Light_II_Scroll]
    180.       ,[Light_III_Scroll]
    181.       ,[Lightning_I_Scroll]
    182.       ,[Lightning_II_Scroll]
    183.       ,[Lightning_III_Scroll]
    184.       ,[Holy_Armor_I_Scroll]
    185.       ,[Holy_Armor_II_Scroll]
    186.       ,[Holy_Armor_III_Scroll]
    187.       ,[Smite_I_Scroll]
    188.       ,[Smite_II_Scroll]
    189.       ,[Smite_III_Scroll]
    190.       ,[Holy_Water_I_Scroll]
    191.       ,[Holy_Water_II_Scroll]
    192.       ,[Holy_Water_III_Scroll]
    193.       ,[Darkness_I_Scroll]
    194.       ,[Darkness_II_Scroll]
    195.       ,[Darkness_III_Scroll]
    196.       ,[Electric_Bolt_I_Scroll]
    197.       ,[Electric_Bolt_II_Scroll]
    198.       ,[Electric_Bolt_III_Scroll]
    199.       ,[Satanic_Armor_I_Scroll]
    200.       ,[Satanic_Armor_II_Scroll]
    201.       ,[Satanic_Armor_III_Scroll]
    202.       ,[Power_Surge_I_Scroll]
    203.       ,[Power_Surge_II_Scroll]
    204.       ,[Power_Surge_III_Scroll]
    205.       ,[Toxic_Water_I_Scroll]
    206.       ,[Toxic_Water_II_Scroll]
    207.       ,[Toxic_Water_III_Scroll]
    208.       ,[Cure_I_Scroll]
    209.       ,[Cure_II_Scroll]
    210.       ,[Cure_III_Scroll]
    211.       ,[Dead_Eye_I_Scroll]
    212.       ,[Dead_Eye_II_Scroll]
    213.       ,[Dead_Eye_III_Scroll]
    214.       ,[Tree_Armor_I_Scroll]
    215.       ,[Tree_Armor_II_Scroll]
    216.       ,[Tree_Armor_III_Scroll]
    217.       ,[Reign_Of_Arrows_I_Scroll]
    218.       ,[Reign_Of_Arrows_II_Scroll]
    219.       ,[Reign_Of_Arrows_III_Scroll]
    220.       ,[Disease_I_Scroll]
    221.       ,[Disease_II_Scroll]
    222.       ,[Disease_III_Scroll]
    223.       ,[Cleansing_I_Scroll]
    224.       ,[Cleansing_II_Scroll]
    225.       ,[Cleansing_III_Scroll]
    226.       ,[Earthquake_I_Scroll]
    227.       ,[Earthquake_II_Scroll]
    228.       ,[Earthquake_III_Scroll]
    229.       ,[Vortex_I_Scroll]
    230.       ,[Vortex_II_Scroll]
    231.       ,[Vortex_III_Scroll]
    232.       ,[Meteor_Shower_I_Scroll]
    233.       ,[Meteor_Shower_II_Scroll]
    234.       ,[Meteor_Shower_III_Scroll]
     
  2. mholmes

    mholmes

    Joined:
    Dec 8, 2012
    Posts:
    414
    Nm Im stupid. I was trying to convert my email to a Long. I need to just remove it. Thanks everyone