How can I make an SQL Query if at the moment I have this piece of code: VB4
Private Sub Form_Load()
Dim oSQLServer As New SQLOLE.SQLServer
Dim oDatabase As SQLOLE.Database
Dim sql As String
oSQL...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10006391.html
Zones:
Visual BasicDate Answered: 03/26/1997 Grade: C Views: 0
having trouble with table and relationship design. tracking vendor quotes. vendor submits bid on whole units, subassembly of the unit and parts that are not part of a subassembly. There are 3 le...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10041256.html
Zones:
MS AccessDate Answered: 03/20/1998 Grade: A Views: 0
I have a Informix 6.0 and VB 4.0 and used ODBC. I can use sql query for returning recordset of text, integer and other data field.
My problems is how to query DateTime data fields. My date fields...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10056645.html
Zones:
Visual BasicDate Answered: 06/07/1998 Grade: B Views: 0
is there a wildcard you can pass as a parameter that will select all records?
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10057538.html
Zones:
MS AccessDate Answered: 06/12/1998 Grade: A Views: 0
I have a query that extracts records for mailing labels. When I run the query I get an error, "Can't perform join, group, or sort. Combined fields are to long."
If I remove some text from the nam...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10058724.html
Zones:
MS AccessDate Answered: 06/29/1998 Grade: A Views: 0
I have a crosstab query which retrive the employee daily call summary, the query has parameter which set for the beginning date and ending date for user input. I can't set the employee field prope...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10063480.html
Zones:
MS AccessDate Answered: 08/04/1998 Grade: C Views: 0
I have a query (which is parameterised by two dates) upon which other queries are based. Is it possible to make the arguments which are used for the base query automatically used for the other quer...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10078849.html
Zones:
MS AccessDate Answered: 10/25/1998 Grade: C Views: 0
I have a small query which I would like to be activated when I click on a cell on a subform. What Kind of code do I need, I just want to execute the query. I have no examples to follow. Can anyo...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10086795.html
Zones:
MS AccessDate Answered: 10/07/1998 Grade: A Views: 0
In short,What can you do to speed up the returning of thousands of rows?
I have a VERY,very large table. There is an index set up on a couple columns. I have a query which uses the index.
If the ...
http://www.experts-exchange.com/Database/Oracle/Q_10099328.html
Zones:
OracleDate Answered: 11/18/1998 Grade: B Views: 0
I am looking for a query that enables me to select all the tables in a database that have a certain field. Is this possible. Thanks for your help
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10105310.html
