by: Christopher Brandsdal |
last post by:
Hi!
I am having some problems width a little script i downloaded...
I'm not able to figure out what he SELECT line does!
What does the @@identity mean?
Is this maby a javascript? :)
|
by: Rick |
last post by:
I want to write a single sp where I pass in the column values and if
it finds an exact match it returns the refid of that match else if it
doesn't find it, it adds a new row using the passed in...
|
by: Larry |
last post by:
I am seeing a problem with an ASP application, where I have 2 tables.
In the first table, the ASP inserts just 1 row and retrieves the
primary key of the new row using SCOPE_IDENTITY. It then uses...
|
by: avinashraj |
last post by:
Hi All,
I need to run a compound SQL statement involving a insert into followed
by a select into statement from a ADO.NET command object.
The insert into inserts the record while the select into...
|
by: Banski |
last post by:
Hi,
Im trying to use SELECT @@IDENTITY in a transaction. But it always returns 0.
Im using an ms access database. And using the following code.
What am i doing wrong?
Best regards banski
...
|
by: Brian |
last post by:
Hello all -
I am trying to Insert a new record to an Access 2002 database.
Following the insert, I need to obtain the primary key of the inserted
row (person_ID) which is an Autonumber field. I...
|
by: Justyn |
last post by:
Hi everyone, I hope someone can help me out!
I have added a trigger that gets fired on INSERT and which itself inserts data into another table WITHOUT an identity
I used to get back the...
|
by: PinkBishop |
last post by:
I am using VS 2005 with a formview control trying to insert a record
to my access db. The data is submitted to the main table no problem,
but I need to carry the catID to the bridge table...
|
by: tslorick |
last post by:
Hi,
I'm having trouble getting this ASP code to work. I want to retrieve the record just added, and found the scope_identity() syntax, but I get the following error:
Microsoft JET Database...
|
by: Miro |
last post by:
I am trying to get my ID added from a people table in an access table
"MyContacts.mdb" i just added.
Its basically a contact file i created in access:
PK Person_ID - Unique - autoincrement...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|