Posted by Tom Fulton on May 11, 2004 at 08:04:28:
In Reply to: Re: Comet 2004 336 03.07 posted by Brian Levantine on May 10, 2004 at 15:47:59:
These results are from programs running against a MySQL database. The
same programs are being run under Comet2003 and Comet2004
1) Comet2003 - In the table maps, the fields must be prefixed with a
leading TableName. So, if I have a table named OrdHdr and a field
name OrderNumber the map would be OrdHdr.OrderNumber,9 If the field
is referenced as OrderNumber,9 then a hard error 29 is generated.
2) Comet2004 - In the table maps, the fields must NOT be prefixed with leading TableName. Using the above example, OrderNumber,9 will
process fine. OrdHdr.OrderNumber,9 will generate a '-' Result$ that
displays the message "Invalid field or Index found in rsOpen".