Re: Deleting associated records from 2 different databases

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 40116
interpreted = N
texte = Looks like Anup's fingers were a bit loose... fixing the syntax:[delete db=catalog.txt&eqAKUdata=xxx] [delete db=products.txt&eqAKUdata=xxx]- brianAt 1:11 PM 11/15/2001, Anup Setty wrote: >If I understand your question correctly, it is simple, just >have two delete statements one after another, > >[delte from db=catalog.txt&eqAKUdatarq=xxxx] > >[delete from db=products.txt&eqAKUdatarq=xxxx] > >HTH > >== Anup Setty > > >----- Original Message ----- >From: Gary Krockover >To: WebCatalog Talk >Sent: Thursday, November 15, 2001 12:26 AM >Subject: Deleting associated records from 2 different databases > > >> Hey all, >> >> I'm searching through the archives now with little luck. >> >> Situation: I have 2 databases, catalog.txt and products.txt. The >keyfield >> for both databases is AKU. Each database has different fields other than >the >> related AKU and product info is shown with a search and a lookup on the >2nd >> database. >> >> Question: Is it possible to remove the same AKU from both databases in >one >> stroke at the same time? Currently, the client has to delete the AKU from >> each database using different delete's. >> >> Thanks, >> GK >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to > >> Web Archive of this list is at: http://search.smithmicro.com/ >> > > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to > >Web Archive of this list is at: http://search.smithmicro.com/-- <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.com =>------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Deleting associated records from 2 different databases (Brian Fries 2001)
  2. Re: Deleting associated records from 2 different databases (Anup Setty 2001)
  3. Re: Deleting associated records from 2 different databases (Anup Setty 2001)
  4. Re: Deleting associated records from 2 different databases (Anup Setty 2001)
  5. Re: Deleting associated records from 2 different databases (Gary Krockover 2001)
  6. Re: Deleting associated records from 2 different databases (Gary Krockover 2001)
  7. Deleting associated records from 2 different databases (Gary Krockover 2001)
Looks like Anup's fingers were a bit loose... fixing the syntax:[delete db=catalog.txt&eqAKUdata=xxx] [delete db=products.txt&eqAKUdata=xxx]- brianAt 1:11 PM 11/15/2001, Anup Setty wrote: >If I understand your question correctly, it is simple, just >have two delete statements one after another, > >[delte from db=catalog.txt&eqAKUdatarq=xxxx] > >[delete from db=products.txt&eqAKUdatarq=xxxx] > >HTH > >== Anup Setty > > >----- Original Message ----- >From: Gary Krockover >To: WebCatalog Talk >Sent: Thursday, November 15, 2001 12:26 AM >Subject: Deleting associated records from 2 different databases > > >> Hey all, >> >> I'm searching through the archives now with little luck. >> >> Situation: I have 2 databases, catalog.txt and products.txt. The >keyfield >> for both databases is AKU. Each database has different fields other than >the >> related AKU and product info is shown with a search and a lookup on the >2nd >> database. >> >> Question: Is it possible to remove the same AKU from both databases in >one >> stroke at the same time? Currently, the client has to delete the AKU from >> each database using different delete's. >> >> Thanks, >> GK >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to > >> Web Archive of this list is at: http://search.smithmicro.com/ >> > > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to > >Web Archive of this list is at: http://search.smithmicro.com/-- <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.com =>------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Brian Fries

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Create Folder Question... (2000) unitshipcost vs shipcosts (1997) Emailer setup (1997) two unique banners on one page (1997) Help! WebCat2 bug (1997) Signal Raised Error (1997) 40,000+ items = mutiple dbs? (1999) OT: RAID Options (2004) WebDelivery downloads alias, not original ? (1997) Setting up WebCatalog with Retail Pro data (1996) Locking up with WebCatalog... (1997) Word Break (1999) WebDNA v5 Array Q (2003) emailer (1997) RE: ANother SHOWIF problem (1997) Line Feed Character Appended (1998) Searching (2004) t or f (1997) Country & Ship-to address & other fields ? (1997) Math inside [showif] (1998)