On Sat, 2010-10-16 at 21:46 -0500, Andrew Brunner wrote: > On Sat, Oct 16, 2010 at 8:04 PM, Joost van der Sluis <[email protected]> wrote:
> >> SELECT SUM(LENGTH(ITMDAT)) as TesT FROM scms_ufls WHERE ITMUID=2 AND > >> ITMKND=1 > >> > >> the FieldDef come back with FieldDefs count =1 > >> The name looks good. > > > > Fielddef <> Fields. So what is the field-count? > > Field count always ZERO. Then it probably doesn't recognize the field-type. But it should give an exception while opening the dataset in that case. Now I know that there are a lot of people who send in bug-reports that no exception should be given but that the fields should be ignored... But afaik this never changed. (It would be wrong, if it did) So you are really sure you don't get an exception when you try to open the dataset? (Btw: you DID open the dataset, didn't you?) > Thanks. So other than using the laz TMySQL51 Connection and setting > Transaction and Query to stock components I don't know what else to > offer. Ask more questions :-) What happens when you do a simple 'select ITMDAT as TesT from ...' ? Joost -- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
