>>Put this in Watch window od the debuger:
>>
>FIELD(1, [CAAlias]) -- "SCHTYP_DESC" - the name of the only field in the table
>FIELD(2, [CAAlias]) -- "ADOBOOKMARK"
>>
>>What is the result?
According to HELP and
http://msdn2.microsoft.com/en-us/library/4z9yct10(VS.80).aspxhttp://msdn2.microsoft.com/en-us/library/t8zy5cty(VS.80).aspxADOBOOKMARK Contains a value that corresponds to an ADO Bookmark for the current record in an ADO-based cursor
I think this is a BUG in FCOUNT() and FIELD() functions. Maybe this is an internal field created for ADO based cursors (never played with ADO yet) that contains this property, but I think these functions should not returned it.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.