>Dear All,
>
>I would like to do something like this:
>
>select ..., 0 ....
>
>
>I want the select statement to make the column of zero of integer type. But istead it gives me a 1 digit wide numeric column.
>
>Does anybody know the right syntax?
>
>TIA
>
>bb
"Integer" is not an available VFP
memvar type, so I don't think it's possible to force creation of an integer column in the column list of a SELECT - SQL. Integer exists only in tables/cursors, so you have to link/join one in to your SELECT to get one in your output. Andrew's technique is as good as any I've seen to accomplish that.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up