Insert will not show update until second pass

Insert will not show update until second pass

Post by CyberSpide » Wed, 01 Aug 2001 10:29:11

I have a button on an access form in Access Data Projects (ADP).
This button executes a SQL stored procedure which searches for a child
record in the table.  If the record cannot be found the procedure inserts a
record into the table and populates the loanid field with the loanid
parameter that was passed in.  The procedure then queries for this record.

Here is a list of the error messages that I receive and a copy of the stored
procedure listed below.  If I click the button on my form a second time, the
data shows up correctly in the form.  I believe the record is being created
correctly the first time but the query cannot see the record.  Please help

    "The stored procedure executed successfully but did not return records."
when I click ok on the dialog box I receive this message

when I click ok on the dialog box the dialog box disappears.

Procedure "sp_frmUnderwriterPopup"

-- Check to see if the loan exist in the fund table
-- if it does not exist create the record and populate
-- the FUND LOANID field with the LOAN LOANID field and
-- the PROGRAMID field with the INITIALPROGRAM field from the loan table


select * f


1. Insert query results don't show until I reopen the database

Hello, all !

I 've got the following problem. I use DAO classes and I have an insert
query ( a query that insert records in the table,based on values,user
enters). When I call Execute on this query, values are succesfully added to
the table, but if I right after that open that table and begin to retrieve
it's records, one by one, I realize,that the newly added record is not
there. If I close the database and open it again,the record is there.
What should I call besides CDaoQueryDef's Execute to make records visible
right after inserting?



2. prohibit deletion of certain records in table

3. Recordset not refreshing until second time.

4. MN-MINNEAPOLIS-86311--ORACLE Financials-DBA Skills-Customer Support-Oracle Financials Specialist/DBA

5. input not shown until program restarted

6. Printing question

7. ADO Updates to SQL Server not Showing, though records affected shows true

8. Create Trigger - Insert, Update - not updating record on Insert

9. record not updated until table is closed

10. *.ASP files are not reflecting updates until the server is restarted

11. Access2k ADODC update not reflected until 500ms later

12. OCI app hangs on oclose for 60 seconds or until another db operation