General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Michael,
I suspect the problem is in the table structure of the columns that you are joining on do not match. Check to make sure that the width of r.sedol and c.sedol are the same width. The reason why your code works in VFP development is probably because you have SET EXACT OFF in the development environment but it is ON in your .exe.
I would hesitate against changing this setting in the .exe since it could have major implications in other parts of your app. If the field widths are different, just add the SUBSTR() function to the larger field in the join statement so that both columns are joining on the same size field.
Hope this helps,
Kurt Huebner
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only