Re: Append results from ADODataset

From: George Kuascha (gkhokie_at_hotmail.com)
Date: 02/13/05 

Date: Sun, 13 Feb 2005 16:45:10 -0500

Clarification .... I'm looking for a simple way to do this with SQL
statements and a wildcard. All fields match in both tables.

"George Kuascha" <gkhokie@hotmail.com> wrote in message
news:420fb52c$1@newsgroups.borland.com...
> How would I append an existing ADOTable with the results of an ADODataset?
> I'm using MS Access 2000 and D6
>
>

Relevant Pages

  • Re: How can one make a wildcard key for a chain statement in rpgle?
    ... If you have the SQL precompiler, ... Then do a SETLL on the lib result. ... If library is a wildcard, SETLL by library using the wildcard ... turn librarywc on if wildcard for library ...
    (comp.sys.ibm.as400.misc)
  • Re: Parameterized query problem using Access Database in VS.NET2005
    ... You can also change the LIKE expression to a parameter so the SQL would look ... WHERE AuthorName LIKE @NameWanted ... case) concatenated with the wildcard character. ... instance if I wanna look for those customer names that start with J in an ...
    (microsoft.public.dotnet.framework.adonet)
  • updating
    ... I'm trying to build a shopping cart app using a db the part I'm stuck ... I've got it set up to check whether the size and colour fields match ... the same colours and size so, only update the quantity field, if they ... //create sql insert ...
    (microsoft.public.inetserver.asp.general)
  • Re: finding a string in a file
    ... You want to get a list of all files that contain the string 'sql' in the ... But this is faster because it doesn't spawn a grep for each file: ... The command doesn't normally see the wildcard at ... If you want to pass a wildcard to a program you need to escape it. ...
    (comp.os.linux.misc)
  • Re: access sql question
    ... > to FIELD b in REC2. ... If fields match I need to combine (sum) numeric ... I am new to SQL and am having difficulty. ...
    (microsoft.public.access.queries)