automation datatype in navision

Comments

• Options

  PrebenRasmussen Member Posts: 137

  2005-06-23

  Maybe the field is not blank, it might contain a NULL. Try getting the value using a variable of type Variant.

  0
• Options

  rvduuren Member Posts: 92

  2005-06-24

  Hello Jsk,
  
  I asume you use 'Microsoft DAO x.x Object Library'.DBEngine for accessing M$ Access, I had the same problem (Attain 3.60) and fixed it by replacing in the NULL in the Query and it worked for me. This is how I did it:
  

  Query := 'SELECT IIF( Table.StringField is null,"0",Table.StringField) as NewStringName, IIF( Table.DateField is null,0,Table.DateField) as NewDateName, FROM Table ORDER BY Table.StringField,Table.DateField';
  

  Met vriendelijke groet, best regards,
  
  Rvduuren

  0
• Options

  kine Member Posts: 12,562

  2005-06-24

  I assume that you are inserting data into MS SQL server. See http://www.mibuso.com/forum/viewtopic.php?t=6530 for examples of settings... mainly "Maintain Defaults"...

  Kamil Sacek
  MVP - Dynamics NAV
  My BLOG
  NAVERTICA a.s.

  0
• Options

  jks Member Posts: 277

  2005-07-13

  Hi all,
  
  I checked 'Maintain Defaults' option. But still getting an error.
  
  I also tried IIF. But it gives me an following error.
  'No value given for one or more required parameter'
  
  I am using
  'Microsoft ActiveX Data Objects Recordset 2.5 Library'.Recordset
  
  Please help

  0
• Options

  Magnus Member Posts: 1

  2005-07-13

  You can use the Actualsize property of an ADO-field to check on Null-values. If the actual size = 0 then the value will probably be null.
  
  Hope this helps. Greetz

  0
• Options

  jks Member Posts: 277

  2005-07-14

  Hi all,
  
  It was my mistake. IIF works. But I get some problem with it.
  I have one field of type memo in my table. I handeled it like
  iif(table1.memofield is null, "0", table1.memofield)
  
  Problem is that I am getting only some portion of the memofield(when it is not null)
  
  Please help.

  0