Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP SQL Syntax - Tuesday BrainFreeze
Message
De
11/07/2007 08:56:27
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
10/07/2007 16:39:44
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01238981
Message ID:
01239211
Vues:
10
Tracy,
There is something wrong there < g >. VFP9, SP1 it says, no? The first field is not an issue then.
Cetin

>That was it! :o) Thanks Steve!
>
>
>>Tracy,
>>
>>Does the first record in the query result have a match between table1 and table2 for that field? Are you allowing enough spaces in the space() function? If you use NVL(bvalue,"") and the first record has no match, then the field won't be wide enough to show any results.
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform