Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combo box still not Combo'ing
Message
From
27/03/2019 16:34:18
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
27/03/2019 16:12:06
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01667365
Message ID:
01667612
Views:
49
>>>>>
>>>>>Right, I forgot that the length was irrelevant, as long as lname and fname are trimmed.
>>>>
>>>>If it is not leading spaces, then no trimming is needed. Trailing spaces are unimportant.
>>>
>>>For DBF's they are.
>>
>>No they are not. We are talking about SQL, no?
>
>Yes, I meant that trailing spaces must be trimmed when you use SQL syntax against DBFs. (You made me unsure, so I just tested it).

I am not sure what you have tested. When using SQL, with == operator, trailing spaces are not important. I have posted demo code here on UT many many years ago and also you can find the demo codes on Stackoverflow VFP guide (posted there too).
Ç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