well, i got a firebird database, conect and collect using a recordset, add a collection object, but if in my table have a field with one blank space, NOT null, only one space stored, when asign to collection, this show Nil.
Why?
depends…
what is the fields datatype? and any other table constraints.
what is the query used to retreieve the data?
i use a debug, and see, my recordset have a nil in the field,
mi question change, why the recordset return nil whe the field have a blank space stored.
The field datatype is varchar
this is a query… the field is Msgtodos
cCurResp=dbFB.SQLSelect(“Select nombre,telefono,direccion,Trim_activo, Impboletin, Decimales”+_
“,Bloq_estudiantes,Msgtodos,Msgmorosos,Msgestudiantes from colegio”)