RE: How to simple retrieve autonumber valuees or identity from data so

From: Cowboy (Gregory A. Beamer) - MVP (NoSpamMgbworld_at_comcast.netNoSpamM)
Date: 01/18/05 

Date: Tue, 18 Jan 2005 08:43:02 -0800

First off, you can write the equivalent of a stored procedure in Access. They
are called queries. Simply write your SQL in a query and save it. Call it by
name. You will have to set the command object to CommandType.StoredProcedure
and attach any parameters by name. I am, by no means, an access expert,
however, so I am not sure if you can chain commands in a single query to get
the latest value out. If not, Row_Update may be the best option.

In most cases, I would prefer using MSDE to Access. If that is an option,
the app can later be upgraded to SQL Server without much, if any, pain. 

---
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
"£ukasz Margielewski" wrote:
> I use the access database in my simple application. That database doesn't 
> support stored procedures. In the one of te Microsoft tutorilas,they propose 
> to solve this problem by attend the row update event. Is any simplest 
> solution?
> 
> 
>

Relevant Pages

  • Re: Stored Procedures v Views
    ... Build a stored procedure, ... The goal here will be to not use any dynamic sql like you used in Access. ... If the query is very complex, but frankly, if you have to do this, you are ... > they make are then used to create the SQL statement which is then used to ...
    (microsoft.public.sqlserver.programming)
  • RE: Class Module Choices
    ... SQL Server has Stored Procedures. ... Perhaps you meant Stored Query with is different. ... When I said stored procedure, ... I don't know how to assign a value to Param1 within the execute command. ...
    (microsoft.public.access.formscoding)
  • Re: Stored Procedure
    ... We cannot delare variables within the SQL statements we build in Access. ... If I want 14284 I should do a seperate query whereas in a stored procedure I ... This is preferable to having the client submitting all those queries ...
    (microsoft.public.access.modulesdaovba)
  • Re: Operator in SQL like "Like"
    ... I have an Access database with a table called "product". ... The SQL that Access gives me for the query I am trying ... All of the operators used in Microsoft Jet SQL ... So it may be that the Like operator for Access SQL cannot be used in Delphi. ...
    (microsoft.public.access.modulesdaovba)
  • Help Please interfacing to SQL
    ... I'm still a novice when it comes to getting MS Access talking to SQL ... I have a pass through query in my access front end called ... Below is the stored procedure in the SQL database that it talks to(written ... NULL, @QueueItemDesc) ...
    (microsoft.public.access.queries)
Quantcast