I am using ADO object , how can I use LIKE operator in ADO
please check the below coding , is it must to use a keyset cursortype
please give me how can I give SQL query in ADO coding while useing LIKE operator
dc.cmd.CommandText = "SELECT p_name from quntity where p_name LIKE '" & "Body*" & "'"
Set dc.rs = New ADODB.Recordset
dc.rs.CursorLocation = adUseClient
dc.rs.CursorType = adOpenKeyset
dc.rs.LockType = adLockPessimistic
Set dc.rs.Source = dc.cmd
Do While Not dc.rs.BOF
' cmbweight.AddItem (dc.rs.Fields(1))
Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.
There is also a companion Debug Toolbar that looks like the followin…
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…