[VXCMD] Bug in 1.9.8

[Ruslan Zasukhin]

on 10/30/03 18:57, Ken Ray at kray at sonsothunder.com wrote:

> I have a table with a field called "Union". When I do a SQLSelectRecords
> calling out that field by name, my result ends up empty. When I change
> the name of the field to "UnionName", everything works fine. So
> something like this:
> 
> SELECT RecID,Name,Type,Union,Rate,Location FROM Projects
> 
> returns empty, whereas:
> 
> SELECT RecID,Name,Type,UnionName,Rate,Location FROM Projects
> 
> returns many records.
> 
> Perhaps Valentina is tripping up on a field name that *means* something
> (like Join, Union, etc.)?

Yes. 

I have this this bug. Probably VXCMD was not updated yet.

For now you can rename your field.
It is always good idea keep names different from keywords of SQL

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------