[AccessD] invalid number of arguments

Make that

qryPedro1
INSERT INTO tblDEBITEUR (DebID, Postadres, Woonplaats)
SELECT Clng(Nummer) As DebID, Adres As PostAdres,
Plaats As Woonplaats FROM DEBSTM WHERE DEBSTM.DebID
NOT IN (SELECT tblDEBITEUR.DebID FROM tblDEBITEUR)
IN 'C:\Wife.mdb'


(Note : IN 'C:\Wife.mdb' is either at the end
or after DEBSTM, I can't test it at the moment)

----

Michael R. Mattys
Mattys MapLib for Microsoft MapPoint
http://www.mattysconsulting.com



----- Original Message -----
From: "Michael R Mattys" <mmattys at rochester.rr.com>
To: "AccessD" <AccessD at databaseadvisors.com>; "Pedro Janssen"
<pedro at plex.nl>
Sent: Wednesday, June 29, 2005 4:28 PM
Subject: Re: [AccessD] invalid number of arguments


> Pedro,
>
> I'm really sorry, I didn't see your message.
> See below for what I was thinking about.
> It isn't tested, of course, but I think it will do
>
> Michael R. Mattys
> Mattys MapLib for Microsoft MapPoint
> http://www.mattysconsulting.com
>
>
> > explain the issue with the append query.
> > When there are new values in the commercial database,
> > how does the append query [know] which items are new
> > to append to the tblDebiteur.
>
> Commercial DB
> > DEBSTM
> > Nummer        = Text  (but al Id's are numbers)    =  Primary Key
> > Adres
> > Plaats
>
> In your autoexec, run this query:
>
> qryPedro1
> INSERT INTO tblDEBITEUR (DebID, Postadres, Woonplaats)
> SELECT Clng(Nummer) As DebID, Adres As PostAdres,
> Plaats As Woonplaats FROM DEBSTM WHERE IN DEBSTM.DebID
> NOT IN (SELECT tblDEBITEUR.DebID FROM tblDEBITEUR) IN
> 'C:\Wife.mdb'
>
> Your Wife's DB
> > tblDEBITEUR
> Add AutoNumber Field Here - It has no meaning, it is an index
> > DebID         = Number   (Long Integer)
> > Postadres
> > Woonplaats
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com