Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating a Logical with SQL
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00096152
Message ID:
00096251
Views:
11
>I am populating a grid with a Cursor and I need a logical field returned from a select to use as one of the grid columns control Controlsource. For example, to create a Char field with 5 spaces in a sql statement I use --> space(5), a date field {}, but I can't remember how to create a logical field from a SQL statement. Any help appreciated!
>
>Thanks.
You can also use something in the table to create a logical for you...

SELECT table1.cvalue = 'X' FROM table1

Wayne
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown
Previous
Reply
Map
View

Click here to load this message in the networking platform