Re: Deleting associated records from 2 different databases
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 40110
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
Anup Setty
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:
[showif],[refferer],[include] in errormessages.db (2002)
What am I doing wrong? (2000)
[random] only for 1-100??? (1997)
Don't know if this is a sily question... (2003)
NEW NetProfessional Revealed (1998)
Problems with [Applescript] (1997)
Separate SSL Server (1997)
[numfound] for [listfiles] (1998)
Problem with updating to 2.1.1 (1998)
HTML Editors (1997)
Date Formats (1997)
Looping a variable name with [index] (1999)
Merging databases (1997)
WebMerchant 1.6 and https (1997)
off topic - dna snipets (1997)
NetCloak, FireSite and PIXO (2000)
international time (1997)
WC2/Mac -- Forms not submitting correctly with Mac browsers (1997)
printing twice? and fix (1997)
WebCatalog not running after upgrade (2000)