Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to force SQL select to make an const integer column?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00338053
Message ID:
00338063
Vues:
20
Bela,

I often do this by creating a one-row cursor containing the constant integer and doing a cartesian join with the required fields from the table.

E.G.
create cursor const (const I)
insert into const values (0)
select last_name, const ;
  from (home(2) + 'data\employee'), const
list stru
Cheers,

Andrew

>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


If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?


From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."


All my FoxTalk and other articles are available on my web site.


Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform