datatable.select
I have fill a table. and is doing a select on this table I have setup an index. When two values are the same When I do the select I find the first one and the second one is not found. Is there a way to reset the search pointer to tell it to start the search from the beginning of the table....
0 answers | 290 bytes |
Datatype
What is the datatype to record time ? if a datatype exists does it work in Oracle 8?Smoove....
3 answers | 101 bytes |
Datatype
What is the datatype to display hrs,minutes?...
2 answers | 44 bytes |
Date
Hii have the following records and i want to select November records only.1/12/20042/12/20041/11/20042/11/2004so what is the best SQL statement to get the answer?Note : i m using Access Databasethanks...
1 answers | 256 bytes |
datawarehouse and MDX, the only way?
Hi,I want to access to a datawarehouse. Is MDX the only way to go?Thanks in advance.Davinia....
0 answers | 112 bytes |
deadlock
How can we minimize the deadlock situation?...
0 answers | 43 bytes |
Deadlocks on multiprocessor MSSQL server
Hi, I have two apllications connected to MSSQL2000 server at the same time. One connection is via ODBC, second use OLEDB. When SQL server run on single-processor HW (for example my notebook) everything is ok. But when I test it on server with 2 processors both communications generate errors "deadloc...
1 answers | 477 bytes |
DB2 performance (waits)
HiI have a table with a numeric Primary Key. This key is composed of NNRRRRRRRRR where NN is the week since the system went live and RR is a randomly generated number. Multiple programs simultaneously try to read data from this table while others could be creating records on it at the same time. Thi...
0 answers | 1071 bytes |
Db Schema in MFC app
Is it possible to display a database schema in my MFC application? I'm using the ODBC API functions SQLTables and SQLColumns to dynamically display the database tables and the table attributes. However I would also like to display the relations (one-to-one, one-to many) between the tables in a...
0 answers | 822 bytes |
DB rows/records as oo-objects?
Tables with their columns are very similar to objects in object oriented programming (if yet only structs).What ways exist to work with them as such, getting and setting this.X = that?Constraints could be implemented with properties in languages that support that....
5 answers | 279 bytes |
DB_VARNUMERIC data
Hi All,When i want to read data from varnumeric field using OLEDB consumer templates, i am not able to useDB_VARNUMERIC structure so with the help of MSDN i made it to receive thevalue type casted to BYTE*. I am able to get and set the value for avarnumeric field. If the data is in other datatypes l...
0 answers | 585 bytes |
DB synch for out of network clients modlesa adn practices?
I have a complex application at work that is client/server application. Client DB and server DB is synchronized once a week using MSSQL Replication Jobs. Since it all clients are out of the network they have to connect to VPN. We were thinking to replace this model and I was just wondering if anybo...
0 answers | 580 bytes |
- datatable.select
- Datatype
- Datatype
- Date
- datawarehouse and MDX, the only way?
- deadlock
- Deadlocks on multiprocessor MSSQL server
- DB2 performance (waits)
- DB rows/records as oo-objects?
- Access DB Application Locks Up
- access 97 to 2000 conversion with ADO
- data convirsion
- Data Synchronisation
- how do i use MFC to access Access tables database?
- how does oracle deal or transfer large data ?
- How much storage space does nvarchar() eats? Always max?