Hi John,

Yes, me and my familly are fine. How are you? Still working for Sodema?

Welcome to the wonderful word of VB! :) VB has no concept of data by itself, things like SELECT-SQL are not defined in the langage like in VFP. You will need to use a data control like ADO and use the methods and properties of the control to do your query. You will need to learn how to use the data control before, look at the help file to learn more about data control.

Good luck :)

---

>How are you? How is your family? Hope all is well.
>
>I am trying to write SQL statements within VB, but the VB compiler generates an error, stating "Expected: CASE". It assumes I wish to use the Select Case statements of VB. I do not. How can I bypass this. Is there anything I have to enable or activate before I can use the SELECT SQL statement?