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 Rating: 6.4 Views: 5
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 Rating: 7.4 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 Rating: 6.4 Views: 0
Hi
i want to display only those records which are duplicate in the table. Please let me know the query.
tks
-atif
http://www.experts-exchange.com/Database/Oracle/Q_10133848.html
Zones:
OracleDate Answered: 03/05/1999 Rating: 6.8 Views: 0
Hello
I want to create a selection query in access,
I'm using vb5 and in access i have made some query's (tables). Is it possible to make a code that vb makes
automatically a new selection table...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_DB/Q_10152509.html
Zones:
VB DBDate Answered: 05/27/1999 Rating: 7.2 Views: 0
Can I speed up my database if I use VBA and not Queries?
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10163300.html
Zones:
MS AccessDate Answered: 05/21/1999 Rating: 7.4 Views: 4
i have got a dbase and i have made a perameter query that querys on more then one thing. in other words, i have 50 cars and i have ented the colour, make and year of the car. if i query all of the ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10163624.html
Zones:
MS AccessDate Answered: 05/28/1999 Rating: 7.2 Views: 0
I want to query for the status of a Service. Just give the servicename as a string and get a string back with the current state.
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10182619.html
Zones:
Visual BasicDate Answered: 07/15/1999 Rating: 7.0 Views: 0
Hi,
I want to write a query which should perform some math operations and store these results in a table as another(add new) field,which already have some fields in it.Please suggest me how to do ...
http://www.experts-exchange.com/Microsoft/Applications/FoxPro/Q_10184583.html
Zones:
FoxProDate Answered: 09/01/1999 Rating: 6.4 Views: 0
I'm trying to count the total number of records in a query.
RecordCount seems to work well with a table but does not seem to give the correct number for a query. Is there any way to do this?
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_10202699.html
