Re: Deleting associated records from 2 different databases
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 40114
interpreted = N
texte = oops!! I had spelling mistake as well as syntax ;(Just got back from lunch break, been playing pool at lunch!== Anup----- Original Message -----From: Brian Fries
To: WebCatalog Talk Sent: Thursday, November 15, 2001 1:43 PMSubject: Re: Deleting associated records from 2 different databases> Looks like Anup's fingers were a bit loose... fixing the syntax:>> [delete db=catalog.txt&eqAKUdata=xxx]> [delete db=products.txt&eqAKUdata=xxx]>> - brian>> At 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 otherthan> >the> >> related AKU and product info is shown with a search and a lookup onthe> >2nd> >> database.> >>> >> Question: Is it possible to remove the same AKU from both databasesin> >one> >> stroke at the same time? Currently, the client has to delete the AKUfrom> >> 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/-------------------------------------------------------------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:
oops!! I had spelling mistake as well as syntax ;(Just got back from lunch break, been playing pool at lunch!== Anup----- Original Message -----From: Brian Fries To: WebCatalog Talk Sent: Thursday, November 15, 2001 1:43 PMSubject: Re: Deleting associated records from 2 different databases> Looks like Anup's fingers were a bit loose... fixing the syntax:>> [delete db=catalog.txt&eqAKUdata=xxx]> [delete db=products.txt&eqAKUdata=xxx]>> - brian>> At 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 otherthan> >the> >> related AKU and product info is shown with a search and a lookup onthe> >2nd> >> database.> >>> >> Question: Is it possible to remove the same AKU from both databasesin> >one> >> stroke at the same time? Currently, the client has to delete the AKUfrom> >> 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/-------------------------------------------------------------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:
Separate SSL Server (1997)
Sort Order on a page search (1997)
quick setheader questions... (2000)
WebCatalog for guestbook ? (1997)
Webcat no longer supported? (2006)
easiest way to check for a non-alphanumeric character? (2000)
Looping control (1997)
formvars available in formulas.db? (2000)
Emailer S-L-O-W-N-E-S-S (2002)
Unix Webcat Permission - Suggestions (2000)
'Document Contains No Data' (1999)
mass mailing (1998)
MacAuthorize hub, no modal password dialog? (1997)
Document Contains No Data! (1997)
2.0 Info (1997)
Format of Required fields error message (1997)
[browsername] not working? (1997)
BR (1997)
Not really WebCat (1997)
version 2 for NT (1997)