Re: Simple Database close connection
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39128
interpreted = N
texte = Thanks, but the credit should go to an old friend who pointed out other reasons the 'modified' flag may get set.> -----Original Message----- > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On > Behalf Of Alex McCombie > Sent: Friday, October 05, 2001 2:04 PM > To: WebCatalog Talk > Subject: Re: Simple Database close connection > > > On 10/5/01 4:52 PM, Scott Anderson
wrote: > > > An internal modified flag gets set the first time the > cached database is > > changed via WebDNA (nothing to do with the file system). Another > > circumstance that might cause the modified flag to be set > is if the engine > > had to 'correct' a badly formatted database, i.e. rows that > did not contain > > the right number of columns. > Bingo! > > Well sort of... I guess the only way I could have known this > is through this > conversation. > > I discovered that the data feed had indeed 'added' an extra > column of data > to the database. Now since I use the .hdr file and since that > field was not > located in the text... Whalla.. > > So what you're saying is that webcat, in some way, modified > the db it opened > to accommodate the .hdr file description? In essence adding a > tab to the end > of each row? > > > Very nice catch Scott! > > > > The [refresh] tag would be a bit redundant in that the > [closedatabase] tag > > should accomplish the same thing (for a read only database). > In theory, but I happen to know that I will be dealing with data sets > (another project) that use databases in set format. Those > DB's will need to > be reverted back to the starting format after much editing. I > suppose I > could use the flush, move, open method for that. Of course an > option such as > [closedatabase db=/mydb&writeonclose=F] would be very cool. > > > In any case.. I have corrected the .hdr file, spanked the > client, and will > be checking on Monday (next data send) to see if the closedb > is going to do > the trick. > > Thanks for the detailed response. That's how we deal with these :-) > > Alex > > > > > > Alex J McCombie New World Media > Chief Information Officer Drawer 607 > 800/724.8973 Fair Haven, NY 13064 > Alex@NewWorldMedia.com http://OurClients.com > > Interface Designer WebDNA Programmer Database Designer > > > > ------------------------------------------------------------- > 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:
Thanks, but the credit should go to an old friend who pointed out other reasons the 'modified' flag may get set.> -----Original Message----- > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On > Behalf Of Alex McCombie > Sent: Friday, October 05, 2001 2:04 PM > To: WebCatalog Talk > Subject: Re: Simple Database close connection > > > On 10/5/01 4:52 PM, Scott Anderson wrote: > > > An internal modified flag gets set the first time the > cached database is > > changed via WebDNA (nothing to do with the file system). Another > > circumstance that might cause the modified flag to be set > is if the engine > > had to 'correct' a badly formatted database, i.e. rows that > did not contain > > the right number of columns. > Bingo! > > Well sort of... I guess the only way I could have known this > is through this > conversation. > > I discovered that the data feed had indeed 'added' an extra > column of data > to the database. Now since I use the .hdr file and since that > field was not > located in the text... Whalla.. > > So what you're saying is that webcat, in some way, modified > the db it opened > to accommodate the .hdr file description? In essence adding a > tab to the end > of each row? > > > Very nice catch Scott! > > > > The [refresh] tag would be a bit redundant in that the > [closedatabase] tag > > should accomplish the same thing (for a read only database). > In theory, but I happen to know that I will be dealing with data sets > (another project) that use databases in set format. Those > DB's will need to > be reverted back to the starting format after much editing. I > suppose I > could use the flush, move, open method for that. Of course an > option such as > [closedatabase db=/mydb&writeonclose=F] would be very cool. > > > In any case.. I have corrected the .hdr file, spanked the > client, and will > be checking on Monday (next data send) to see if the closedb > is going to do > the trick. > > Thanks for the detailed response. That's how we deal with these :-) > > Alex > > > > > > Alex J McCombie New World Media > Chief Information Officer Drawer 607 > 800/724.8973 Fair Haven, NY 13064 > Alex@NewWorldMedia.com http://OurClients.com > > Interface Designer WebDNA Programmer Database Designer > > > > ------------------------------------------------------------- > 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/
Scott Anderson
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:
suffix mapping for NT? (1997)
Thanks Grant (1997)
MacAuthorize order data fields WAS:How To question... (1997)
Quit revisited (1997)
Searching Records by Company (2000)
update on wn searching (1997)
WCS Newbie question (1997)
Summing fields (1997)
Roundup (2001)
Sendmail: bounced e-mails (2001)
Cart Numbers (1997)
Re:Help name our technology! (1997)
Problems getting parameters passed into email. (1997)
Problems reading files created by WC (1997)
Great product and great job ! (1997)
How flexible is Shipping? (1997)
Moment of Thanks (1997)
selectively replacing records within a [founditems] (2000)
DDEConnect and MSWord (1998)
expired beta (1997)