Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP SQL Syntax - Tuesday BrainFreeze
Message
From
11/07/2007 08:56:27
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
10/07/2007 16:39:44
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01238981
Message ID:
01239211
Views:
11
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform