|
I have a table that it's PK Field Type is autonumber
I want to enter a record between another records.so the other records after it should increase once.how can i do it with query?
|
|
|
|
|
UPDATE table SET PK =PK+1 WHERE PK>=X
INSERT INTO table(PK) VALUES(x)
But your DB may not allow a direct access to the PK field, depending on the implementation. In that case, simply forget it.
dirk
|
|
|
|
|
i want to use the date part of the function getdate in my sql query.
the getdate function return the current date and time. i want only the date part.
how can i do it.
|
|
|
|
|
Goodway,
First of all I assume you use SQL Server (7.0/2000). If not quit reading.
Then, SQL Servers date/time datatype always consists of a date AND a time part. A date without a time component does not exsist is SQL Server.
If you insert a date value without a time, for example jan 1, 2004, SQL Server inserts the date as 2004/01/01 00:00:00.000 (for smalldatetime skip the milliseconds).
So if you need a date without a time you need to convert a datetime value to a string. You can use the CONVERT-function in SQL (see "CAST and CONVERT" in SQL Books online).
Example:
SELECT CONVERT (varchar(24), GetDate() , 103);
Returns:
01/01/2004 -- Note: the result is a string. Not a datetime value.
Good luck
|
|
|
|
|
Using Dataadapter.Fill, a DS.tables("TBL") was populated with, say, n records. Is there a built-in method / procedure through which one can easily find out the row- number in a datacol of the "TBL" contains a given value.
Say, for example, given datacol("FNAMES") and another string fn_str, is there a readily-available procedure such as :-
dim kt as integer, fn_str as string = "John"
kt = ReadilyAvailable(datacol("FNAMES"), fn_Str)
Here, kt will be a value - either -1 or {0 .. n-1}. -1 indicates that the given value does not exist.
Ofcourse, alternatively, a for-next loop will have to be written, but i wanted to avoid it 
|
|
|
|
|
C# syntax:
myDataSet.Tables["mytabl"].Rows.Find() method.
Mazy
"Man is different from animals in that he speculates, a high risk activity." - Edward Hoagland
|
|
|
|
|
thanks, Mazy.
Regards,
Sanjay.
|
|
|
|
|
Whenever you insert a new record, then decide you want to manipulate that record immediately after, is there any easier way to find a reference to it than querying for the last record?
|
|
|
|
|
If you have inserted via Dataadapter>Dataset, then, if the Dataset has not been disposed/cleared off, the inserted record contents will still be in the "tables", from where you could pick it back up.
Hth.
|
|
|
|
|
Thanks, but for this app I'm just using readers and class representations.
If anyone is interested, I found the following:
MySQL: SELECT LAST_INSERT_ID()
MSSQL: RETURN @@IDENTITY
|
|
|
|
|
|
hello friends
i am new to vb.net. can i use "ADO" in vb.net instead of ADO.NET. iam a bit scared to use ADO. becoz all the books suggest to use ADO.NET.
my doubt is if i use ADO then will there be any problems reg. performance, installation ... etc and about the problems that i can't at this level.
please any body guide me.
(i can't accept any guesses .... extreemly sorry for that. i am very much obliged if i can get the correct guidence pls.)
thank in adv.
mohan G
Mohan G
|
|
|
|
|
ADO.net is well formatted and well suited for the applications with the .NET framework... better performance too
I was born intelligent
Education ruined me!.
|
|
|
|
|
Hey
i am trying to use CoCreateInstance();but it is giving failure only. i am very beginner to sql server. what may be the reason for this error. is it because of sql server setup?
Please help me.
Thanks
JP
ALL THINGS ARE POSSIBLE UNTIL THEY ARE PROVED IMPOSSIBLE-AND EVEN THE IMPOSSIBLE MAY ONLY BE SO,AS OF NOW
|
|
|
|
|
CoCreateInstance is a COM API; what COM object are you trying to create? Is the object registered?
If you're not trying to create an ADO object or a SQL-DMO object, please ask on the COM forum.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
Thanks for ur reply, I am trying to create OLE-DB provider. But its giving error. Should I register the COM component? I didn't do this. Please help me.
ALL THINGS ARE POSSIBLE UNTIL THEY ARE PROVED IMPOSSIBLE-AND EVEN THE IMPOSSIBLE MAY ONLY BE SO,AS OF NOW
|
|
|
|
|
Typically a provider will be registered properly by its installer, so that's unlikely to be the problem. Have you called CoInitializeEx or OleInitialize on this thread?
I suggest checking the return value of CoCreateInstance in winerror.h to see if there's a better description of the error.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
Hi Friends,
Is it possible to have both servers installed on same machine and concurrently working?
Vikram S
VikramS
|
|
|
|
|
You mean 2000 - is that 8.0?
You can have them both installed on the same machine. I believe you want 7.0 to exist and then install 2000 as a new instance - but I not sure that is a requirement.
Barbara
|
|
|
|
|
As the other reply... the answer is YES... but I was wondering 'why would u need that'
I was born intelligent
Education ruined me!.
|
|
|
|
|
Am having major problems trying to connect an Access database to my webpage via dreamweaverMX.
|
|
|
|
|
What connection string are you using?
Michael Flanakin
Web Log
|
|
|
|
|
I created a database application in Acess and I want to connect to my website. I published my web using DreamweaverMX. For example I have a login page that I want to be validated with the data(names) in my Acess table. Eartlink is my webhost and they do not support ASP. So, my question is three folds.
1. Do you know the steps to make the connect using a login page as an example?
2. Do I have to convert to MySql in Acess?
3. Do you know of any good book? they ones that i'v tried pretty much suck
|
|
|
|
|
What language do you plan on doing this with? Or, do you even have a plan? You will first need to find out what Earthlink can support. If you're deploying to their servers, you are limited to their list of supported technologies. It is very likely that they don't support scripting (ASP, PHP, Perl, etc.) or compiled (ASP.NET, JSP, etc.) technologies. You need to find this out first.
Michael Flanakin
Web Log
|
|
|
|
|
iamucha wrote:
Am having major problems trying to connect an Access database to my webpage via dreamweaverMX.
If u get error message... whats the error message
I was born intelligent
Education ruined me!.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
