insert to database dont appear in TQuery

From: yuda (yudal_at_netvision.net.il)
Date: 10/18/04 

Date: Mon, 18 Oct 2004 15:19:06 +0200

Hello,
I insert record with sql statment.
I try to call the records from the database and I see nothing.
after few actions such change the master record and call again the screen
with the records I see the record I inserted.
how can I force the system write the detail to the disk after I insert the
record. ?

thank you very much

yuda

Relevant Pages

  • Re: Autopopulate
    ... Because you have already queried the database once to populate the ... So in each tab I have the subforms set up with the fields in a 1 row ... I orginally wrote an SQL statment but I keept getting "The record has ... The DLookup was easy to use and it didn't create the "The record has ...
    (microsoft.public.access.forms)
  • Re: Dynamically Building SQL Statment
    ... Subject: Dynamically Building SQL Statment ... > statment that would be submitted to the database. ... How complex are your SQL strings likely to be? ... you have to think about how this generic class ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: WHERE 1=2 with performance nightmares
    ... it would be interesting to see what tdataset says to the database to ... "prepare" a sql statment. ... How could the tdataset possibly get ... you can get the metadata information you're asking for. ...
    (borland.public.delphi.non-technical)
  • RE: Creating a table in Basic
    ... data from production to archive. ... create a delete query that points to the archve database. ... dbsArchive.Execute (sql statment) ...
    (microsoft.public.access.formscoding)
  • RE: Creating a table in Basic
    ... Dim dbsArchive as Database ... dbsArchive.Execute (sql statment) ... To move the data from the table to the archive, create an append query. ... You will want to change that to UNC mapping because not all users ...
    (microsoft.public.access.formscoding)