Re: formulas.db ??
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17719
interpreted = N
texte = >We've had problems creating .db files with a text editor before (simple>text), and have had better luck with database helper, however it won't>allow us to create the formulas.db because it requires an SKU field.If Database Helper works for you, why don't you just use some other name for that SKU field? Then after the file is created with the wrong name for the SKU field, open it in SimpleText and replace the wrong name with SKU -- being very careful to NOT add or delete any tabs or carriage returns in the process.Most WebCat users probably just use a desktop database program to create their WebCat db files, then they export a tab-delimited text file from that desktop db program for WebCatalog to use. You can just as easily use a spreadsheet program for this initial database creation procedure ...There's no reason why SimpleText or any other text processor cannot create tab-delimited text files from scratch, you just have to be very careful -- to make sure you don't put too many or too few tabs and/or carriage returns into the SimpleText file -- and that you're putting them all in the right places. But that's why it's easier to let a desktop database or spreadsheet program do it for you ... because they cannot accidentally mess up the way humans sometimes do ... :)Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>We've had problems creating .db files with a text editor before (simple>text), and have had better luck with database helper, however it won't>allow us to create the
formulas.db because it requires an SKU field.If Database Helper works for you, why don't you just use some other name for that SKU field? Then after the file is created with the wrong name for the SKU field, open it in SimpleText and replace the wrong name with SKU -- being very careful to NOT add or delete any tabs or carriage returns in the process.Most WebCat users probably just use a desktop database program to create their WebCat db files, then they export a tab-delimited text file from that desktop db program for WebCatalog to use. You can just as easily use a spreadsheet program for this initial database creation procedure ...There's no reason why SimpleText or any other text processor cannot create tab-delimited text files from scratch, you just have to be very careful -- to make sure you don't put too many or too few tabs and/or carriage returns into the SimpleText file -- and that you're putting them all in the right places. But that's why it's easier to let a desktop database or spreadsheet program do it for you ... because they cannot accidentally mess up the way humans sometimes do ... :)Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Kenneth Grome
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:
[date format] w/in sendmail (1997)
Major bug report on rootbeer (1997)
E-mailer error codes (1997)
.tmp files (2000)
Protect vs Authenicate (1997)
Invisible file issue now a real 'bug' (1999)
webcat feature request (1997)
More! on [ShowCart] and GET vs. POST (1997)
Forcing a NEWCART (1997)
NT Version on IIS 4.0 (1997)
WebCatalog Mac 2.1b3 (1997)
Text data with spaces in them... (1997)
A question on sub-categories (1997)
[WebDNA] error on mirror site (2015)
[format xs] freeze (1997)
[WebDNA] Capitalize surprise (2012)
TeaRoom (1997)
[WebDNA] Authorize.net and [tcpconnect] (2016)
WebCat2 Append problem (B14Macacgi) (1997)
WebCatalog [FoundItems] Problem - AGAIN - (1997)