|
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.
|
|
|
|
|
This works in SQL Server but not sure in MS Acceess
Select top 10 * from TALE_NAME
where ID not in
(Select top 20 ID from TALE_NAME order by ID )
order by ID
another method in MS SQL Server 2005:
With ctp as
(
Select row_number() over (order by ID) a, * from TABLE_NAME
)
Select * from ctp
where a between 21 and 30
order by a
|
|
|
|
|
well its so simple.
Do one thing first add a Field which is autonumber.
then u'll have hundered ids in tht column then use its value as follows.
select * from TableName where id between 20 and 30;
hope it works.
|
|
|
|
|
Ok. But could you please tell me to create the dynamic column from within the query itself only. And it will not be permanently created in the table. The query should be in SQL Server 2000. Thank you.
Regards,
Aleem,
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
|
We having two fields 1)shift time 2)Actual time .Actually when subtracting these two time we are not able to get in time format for another field.plz give me ur valuable suggestion
Jeyan
|
|
|
|
|
|
I know that this can't be too hard, but for whatever reason, I haven't been able to figure out how to do it.
I have a query that is returning a group of fields, including some date fields. The data in the field is formatted as follows:
2007-02-08 00:00:00.000
The date part is fine, but I need the time to be standard time (hour:minute:second:millisecond AM/PM) instead of military because of a brittle application that reads the data.
Can anybody help me?
|
|
|
|
|
select convert(varchar(28),@dt,131)
Where @dt is your datetime variable.
Ben
|
|
|
|
|
That's odd. Now it's coming out as:
3/02/1428 12:00:00:000AM
Now the time is right, but the date is odd. The offset seems about right for the Arabic year though (if I remember my Middle East history).
|
|
|
|
|
Sorry I didn't look close enough to the format it puts it in:
dd/mm/yy hh:mi:ss:mmmAM
Here is what I know:
Change the 131 to:
100 you get mon dd yyyy hh:miAM (or PM)
109 you get mon dd yyyy hh:mi:ss:mmmAM (or PM)
So then your date isn't formatted right. It is almost starting to look like you need to take the date part that is ok and then take the time part from 109
Anyway it is a bit more of a pain, but if you need that specific format here it is:
declare @dt datetime,
@time varchar(28),
@date varchar(30)
select @time = convert(varchar(28),@dt,109)
select @date = convert(varchar(30),@dt,112)
Select substring(@date,1,4)+'-'+substring(@date,5,2)+'-'+Substring(@date,7,2)+' '+ltrim(substring(@time,12,15))
Ben
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
