SQL Expression

[qfmomen]

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.

[PCrate]

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