Hi,

i have managed to get the data from SQL server but how do i actually
populate the data into the data grid and i am not able to show a true false
in the data grid as i could not specify a true/false field from a query

appreciate any advise

tks & rdgs

Hi rdgs:

Sounds like your from an Access background (SQL Svr does not have true/false fields like Access).
In any case, you can achieve the same visual effect using Case, i.e.

SELECT CASE WHEN MyField <> 0 THEN 'True' ELSE 'False' END AS MyField FROM MyTable

hth,

Doug.


Show quoteHide quote

Need some help in compressing bmp file to jpeg file
Get rid of flicker inside a frame.
VB6 don't see events of the implemented interface
X-axis value of Excel chart
load extern exe file into mdi framework?
UDT question
Installing Fonts
using user defined types
VB to MySQL connection
DateSerial overflows