What is the purpose of SQL Expression. How i can use it. Can Any One one give me some code for this. I wanna to use it from VB.
Printable View
What is the purpose of SQL Expression. How i can use it. Can Any One one give me some code for this. I wanna to use it from VB.
It depends what you want to do really. The SQL expression is used to extract, update or modify data that is stored within a database.
The sql expression has to be stored within a string variable.
dim SqlStr as String
SqlStr = "Select * from [Table Name];"
That would select all the fields from the table "Table Name". After creating the expression, you need to bind this to a datacontrol within VB. This can be done be setting the recordsource of a DAO control to the Sql variable name or, by using the recordset datatype within VB