Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Square brackets
Message
From
26/04/2001 11:06:31
 
 
To
26/04/2001 10:26:04
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00500093
Message ID:
00500130
Views:
32
Useful if you want to build up a string containing Feet and Inches!
(i've used them for SQL passthrough) - only problem is if your string contains brackets then you're lost...

eg to get the following strings into SPT :
lcStr = "Select * from table where field = " + [Height is 6' 3"]
lcStr = "Select * from table where field = " + [Height is 6' 3"] + "[and a bit]"
The first one works fine
To get the second one programatically from a user entered field is pretty hard to do) - it all gets a bit messy really :(

Will

>Hi all,
>
>A while back, when getting into WebConnect, I found liberal use of square brackets where I had expected to see quotes (single or double). I knew these substituted nicely for parentheses in array coding but was totally surprised by this other usage.
>
>I've played around with these a bit and find them (square brackets) equivalent to quotes of either variety.
>
>Is this a correct conclusion?. . . Is this documented somewhere (a search of MSDN (July 2000) and Hacker's revealed virtually nothing)? . . . Are there things to watch out for?
>
>Thanks for any comments,
>
>JimN
Will Jones
Previous
Reply
Map
View

Click here to load this message in the networking platform