Ergebnis der Suchanfrage

• Forum: Programmieren allgemein

  AW: Mysql Typs (Null) Typ (Integer)

   
    by question, 25. Aug 2013
  QueryA.ParamByName('ID').AsInteger := QueryBID.AsInteger //this using the field of VCL Component)
  QueryYA.ParamByName('ID').AsInteger := ueryB.FieldByName(('ID').AsInteger;// this using sqil query fieldbyname
  
  
  value of both query can be different, i mean Null and 0?
• Forum: Programmieren allgemein

  Mysql Typs (Null) Typ (Integer)

   
    by question, 25. Aug 2013
  Hello,
  I am using Delphi with mysql, i have a table which contains the data.For example
  Table A has ID,Name,Phone and so on , the empty field are filled with "Null"
  ID=1, Name=To,Phone=null,
  
  I would like to copy the data from Table A to Table B, but the problem is, if there is no value in a filed then its filled with '0' instead of Null and i got a error messege
  
  "Variante des Typs...