|
I deduced the inserts would not be visible and deletes would by this: what would happen with a forward only cursor if I do a SELECT ... ORDER BY table_field and someone inserts data before my current cursor position?
Q261186 - Computer Randomly Plays Classical Music
|
|
|
|
|
I agree. If you do an order by and that order by is not the clustered index SQL Server would have to preprocess the entire dataset. (meaning the keys .. not necessarily the data).
However, it would be interesting to see what happens if you don't use a postprocessing instruction. (ORDER BY, GROUP BY, UNION, DISTINCT etc)
Morty
|
|
|
|
|
Hi I have the following table schema
Order(orderID, orderDate, creditCardNo, etc.....)
OrderedItem(OrderID(pk), ProductID(pk) )
Product(productId, productName ....etc.._
In access, when i delete the product from the Product table, if it is associated with a particular OrderedItem then i can not delete it, else i will be able to delete it.
However, I want to set it to ON DELETE SET NULL the ProductID in the OrderedItem
How will i do it?
Thanks
|
|
|
|
|
Hi,
I am trying to access password and aliases or for that matter every thing related to microsoft exchange users i am able to retrieve only usernames using mapi.session object,
Please help in retrieving other things if any body has code plesae post it here.
I have tried using ADSI also.
Thanks,
Amit Gupta
|
|
|
|
|
I would be very surprised if you were able to retrieve the user password using ANY form of API
|
|
|
|
|
I'd like to query and XML file with an SQL statement. Can this be done, or do I have to use XPath stuff? I've been perusing all sorts of CP code and MSDN stuff, and I can't seem to find an example of this, but I can't seem to find something that says I can't do this either.
Also, can the queries consist of a table join?
Thanks,
Marc
Help! I'm an AI running around in someone's f*cked up universe simulator.
|
|
|
|
|
Marc Clifton wrote:
Can this be done, or do I have to use XPath stuff?
I believe you have to use XPath, however SQL Server can return your "recordset" as an XML document. If that is any help to you.
Nick Parker
The greatest lesson in life is to know that even fools are right sometimes. - Winston Churchill
|
|
|
|
|
|
|
Is it possible create table WITH MY PROGRAM useing ADO.NET?
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
Yes
Vagif Abilov
MCP (Visual C++)
Oslo, Norway
Hex is for sissies. Real men use binary. And the most hardcore types use only zeros - uppercase zeros and lowercase zeros.
Tomasz Sowinski
|
|
|
|
|
Yes, the easiest way is to issue a "CREATE TABLE ..." command
Dave.
|
|
|
|
|
dougieb wrote:
An extra $20 if you add parameters for 'first record to return from set', 'how many to return from set'
Save your $20 bucks and put a SELECT TOP X, where X is the record #.
No one will be able to give you a working solution without the tables. All you'll get is untested queries, and probably none will work and all of them will be slow.
Or, if you want, buy me a Amazon certificate.
Q261186 - Computer Randomly Plays Classical Music
|
|
|
|
|
I had a correct answer, so I tried to delete the thread as not to bug anyone else, but to no avail.
Thank you.
|
|
|
|
|
dougieb wrote:
As for the absence of tables, I'm pretty sure that generic tables could be made for testing purposes, or I figured that there would be some puzzle enthusiast who would just redo the syntax.
All I can say is good luck
Q261186 - Computer Randomly Plays Classical Music
|
|
|
|
|
I guess for a guy who's going to earn $60 it will be quite helpful to know data layout (tables, columns, column types, indices). Or do you think $60 should cover all guessing work too?
Vagif Abilov
MCP (Visual C++)
Oslo, Norway
Hex is for sissies. Real men use binary. And the most hardcore types use only zeros - uppercase zeros and lowercase zeros.
Tomasz Sowinski
|
|
|
|
|
This is my first run with SQL Server 2000. I have the server setup on my network, but when I go to "Register New Server" within Enterprise Agent, it's not listed. It's listed in the Win2k ODBC Admin tools (where you setup DSN's), but not within Enterprise Agent. There is a server showing up, but it is not mine. There are about 30 or so SQL server's out there (which, again, are listed where you setup ODBC in Win2K), but only one of these are showing up with I go to register a new server. What are some of the possible problems? I have verified protocol setup of TCP/IP for both server and client. Any help is appreciated!
|
|
|
|
|
I have seen this several times. Sometimes you jst have to type in the name of the server.
|
|
|
|
|
Is it possible to get a reference (pointer) to the actual data stored in a recordset, rather than a local copy? All the functions we have found return data by value. However, we want the fastest mechanism for getting at large volumes of data and so don't want to perform copies every time an item is accessed.
Thanks in advance!
Visit my website![^]
|
|
|
|
|
Connected recordset is the closest thing to actual data you can get. So if you have ADO Recordset object (not disconnected), you can call Update method to modify data. There is no way you can get a pointer to physical data. If you OLE DB directly (bypassing ADO), you can retrieve and modify data in a more efficient way.
Vagif Abilov
MCP (Visual C++)
Oslo, Norway
Hex is for sissies. Real men use binary. And the most hardcore types use only zeros - uppercase zeros and lowercase zeros.
Tomasz Sowinski
|
|
|
|
|
Thanks for your help, Vagif. It's a shame you can't get a pointer to the physical data. Nevermind. I guess your sig could say: ADO is for sissies. Real men use OLE DB. And the most hardcore types use only db library!!!
Cheers!
Visit my website![^]
|
|
|
|
|
I hope someone can help with this problem I am having...
In our application, we have a situation where a grid is populating itself from a simple SQL SELECT statement. The grid must update in real time when data in the database is changed. Data in the database may be changed by any user sitting at any workstation.
My question is: Is it possible to receive a recordset event when data is changed in the database, given that the data may be changed by another user with a different connection?
All the documentation we have found indicates that events are fired when an application changes data in the recordset, rather than the underlying data in the database being changed. Is this correct?
Many thanks in advance!
Visit my website![^]
|
|
|
|
|
Hi,
i have following problem, i have application which is linked with
ddao35.lib (ddao35.dll) (change table properties, like validation rule)this was org. built for a access 97 database.
now i like to update my application for usage access 2000 together with access 97
so with SP 5 for visual studio 6.0 a project (ddao.cpp) was shipped, new dll ddao36.lib (ddao36.dll) could be built
now i linked my application with ddao36.lib and everything goes well for a
access 2000 database, but for access97 database is code still running but
after opening the database in access i see that some modifications are not done
a function like this, won't work for access 97 (running without errors)
void ChangeTableValidation(CString strDBFileName, CString strTableName, CString strFieldName, CString strValidation)
{
CdbDBEngine dbEngine;
CdbDatabase dbDatabase = dbEngine.OpenDatabase(strDBFileName, FALSE);
CdbTableDef dbTableDef = dbDatabase[strTableName];
CdbField dbField = dbTableDef[strFieldName];
dbField.SetValidationRule(strValidation);
}
perhaps has somebody any idea about this,
DanielO
|
|
|
|
|
Hi!
What do I need to re-distribute if I have written an App which uses SQL server? Is the desktop engine enough? How does it work then? I distribute that thing, install it and then run my scripts through isql (osql) in order to install my dbobjects? Does anyone know where to get information on this topic? Searched MSDN but can't find anything...
Any help is greatly appreceated!
A ton of thanx.
In theory, there is no difference between theory and practice. In practice, however, there is.
(unknown author)
|
|
|
|
|