|
Tony
DevExpress Persistent Objects is pretty good. I've used it quite a bit now and I have to say that I like it.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Sorry,
What i meant is the DAL Source Code that is given by the microsoft for all its .net language.........
|
|
|
|
|
tonyalex wrote: What i meant is the DAL Source Code that is given by the microsoft for all its .net language.........
What DAL source code? Microsoft does not supply DAL source code.
|
|
|
|
|
yes, microsoft is providing code for the data access layer for the our custom application,think some thing like SQLHELPER
|
|
|
|
|
tonyalex wrote: yes, microsoft is providing code for the data access layer for the our custom application,think some thing like SQLHELPER
That is part of the Enterprise Library. It is not a DAL, it is designed to help you create a DAL more easily.
|
|
|
|
|
Can anybody please tell me in SQL Server how should I get the records with their row numbers in a table. Like we use Rownum in Oracle. Thank you.
Regards,
Mohd. Abdul Aleem,
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
|
indian143 wrote: Can anybody please tell me in SQL Server how should I get the records with their row numbers in a table.
You need SQL Server 2005. However, you should realise that row numbers are a fiction. Oracle and SQL Server 2005 supply a number based on the order that the rows are returned and have little (only incidental) or no bearing on how the data is actually stored.
Anyway, the answer is ROW_NUMBER[^]
|
|
|
|
|
Could you please tell me that dont I have any other option to get it SQL Server 2000. Please. Thank you.
Regarsd,
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
|
I do not recommend this but you could create a insert/delete trigger that loops through the recordset and inserts the new value. This is a performance hit. A sample trigger is below. You must have a primary key on the table to do this. I am confused of why you need to reference the rownumber. It has no significance. If you dont mind a few holes here and there after you have deleted a record, use an Identity column.
<br />
CREATE TRIGGER dbo.trg_Count <br />
ON dbo._TEST<br />
AFTER INSERT, DELETE<br />
AS <br />
BEGIN<br />
<br />
SET NOCOUNT ON;<br />
DECLARE @PKEY UNIQUEIDENTIFIER<br />
DECLARE @I BIGINT<br />
<br />
IF ((SELECT trigger_nestlevel()) = 1)<br />
BEGIN<br />
DECLARE TRG_TEST_CUR CURSOR FOR<br />
SELECT [GUID] FROM _TEST<br />
<br />
OPEN TRG_TEST_CUR<br />
FETCH NEXT FROM TRG_TEST_CUR<br />
INTO @PKEY<br />
<br />
SET @I = 1<br />
<br />
WHILE @@FETCH_STATUS = 0<br />
BEGIN<br />
UPDATE _TEST SET ID = @I WHERE [GUID] = @PKEY<br />
SET @I = @I + 1<br />
FETCH NEXT FROM TRG_TEST_CUR<br />
INTO @PKEY<br />
END<br />
CLOSE TRG_TEST_CUR<br />
DEALLOCATE TRG_TEST_CUR<br />
END<br />
END<br />
GO<br />
|
|
|
|
|
I need to make a a recursive table.coz i have Main Category & this Main Category have sub category & these Sub Categoris Have Another sub category.my be alot it depend in the main Category.& in the last there are some items to the last sub category.so i need to design the tables.IF Anyone can help me.
J.M.M.G
|
|
|
|
|
You made me confused about the term of "recursive tables". There is no such thing actually because tables cannot be recursive. Regarding your message I suggest you to layout all items such as (Main Category, Sub Category, Child Category and etc.) and each item should have an index for instance lets say that "Fruits" is the main category and it has an index of 01. The banana blongs to Fruits and its index should be 0101. If bana would have a sub category you should index it as 010101... goes on like that...
I sugges you not to use a field as Number but text. That would make it easier to call back the main index.
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
I have a a couple of reports that are viewed using the reporting services report viewer control on a aspx page built with visual studio 2003. The report executes just fine. The problem is that the online page count will state a number like 5 but when you print it the real page count is 10. The online count is always off by about half. How can I make the online count be the correct number?
Thanks,
Patrick
|
|
|
|
|
Hi ..
the project is running ok ,, after only one pc restart ,, when I reRun the project the new message Is appear :
an error has occured while estaplishing a conneciton to the server ...
I use the next connection to the server ..
Public SqlCon As SqlConnection = New SqlConnection(" workstation id=localhost; Password=123; packet size=4096;user id=sa;data source=PcServer;Network=DBMSSOCN;persist security info=False; persist security info=False; initial catalog=DataB ")
that connection is working on the network as good ..
when I change the connection to be :
Public SqlCon As SqlConnection = New SqlConnection("workstation id=DESKTOP;Password=123; packet size=4096;user id=sa;integrated security=SSPI;data source=PcServer;persist security info=False;initial catalog=DataB;")
the project is running as good ..
i'm why .. the first connection was good , and it solved the problem of running the program on the LAN ,,
the second connection can't work on the LAN,,
now what can I do ,, If I use the seconed connectoin the program willn't work on the LAN ,,
it's sure that there're alot of programmers may have faced a poroblem like that >>
(
I founded that When I add Network=DBMSSOCN to the connection string the project can't run ..
-- modified at 5:01 Sunday 25th February, 2007
jooooo
|
|
|
|
|
And what is your question?
Wout Louwers
|
|
|
|
|
hi to all!!
i want to make database connectivity of say sqlserver or oracle with a language like java
kindly tell me the basic steps to do for a connectivity.
thanks a lot in advance.
|
|
|
|
|
|
Hi,
I have made a trigger on inserting a record in a table in oracle, but the problem is that if trigger fails, then insertion transaction is aborted and rolled back, is it possible to specify some attribute to the trigger so that the transaction is not aborted.
Warm Regards,
Mushq
|
|
|
|
|
|
Hi,
I'm writing a wrapper for ADO for some computer game's scripting in C++.
(I compile a dll that extends the game's functionality, and by so add new features to its scripting abilities)
After connecting with a _ConnectionPtr and opening a _RecordsetPtr with an Insert command, how do I get the autonumber column from the inserted row?
I understood that I could do it if I used AddNew instead of an insert command, but that's a problem of circumstance. Mainly relating to the fact I couldn't understand how to easily use this function.
Any help would be appreciated!
|
|
|
|
|
What database do you use ?
If SQL Server you can use this query:
Select @@Identity()
|
|
|
|
|
Currently I'm connecting to an Access 2000 database. That might change to Sql Server later on, but not planned to be soon.
And the second thing is, this might be called a lot in different threads, so I can't be sure that between the insert and the Select @@Identity() stuff won't change on me.
|
|
|
|
|
Hi
@@Identity is supported in JET 4.0 (the engine that runs MS Access queries)
Check: http://support.microsoft.com/kb/232144[^]
Also @@Identity gets the last insert id for the current open session (Connection), so you should not worry about multiple threads.
|
|
|
|
|
Hi everyone,
I am trying to send parameters to a stored procedure as an array using VB 6 , is that possible, and how ?
Please help
|
|
|
|
|
Hi
It is not possible to pass array to Stored Procedure but instead of that pass comma-separated values. (eg. 1,2,4,5).
Write a separate function to read & return value as '1','2','3','5'
For example Pass value as '1,2,3,4,5' and function should return as '1','2','3','5'.
Harini
|
|
|
|
|
Sir,
can you please tell me query to display records from 20th to 30th from 100 records in SQL server and Access database. How they differ. Thank you.
Regards,
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|