Re: formulas.db ??
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17723
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.We've used 3 different text editors on 3 different platforms and 3 different programmers, with all of us being very careful, but we all get the same result.>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 ...We'll try this, seems kind of round about though.>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 .We create these types of files daily in our UNIX environment, that's why it's so troubling. Maybe we're looking in the wrong place for the problem.ThanksMarkMark Mesenko -Webmaster- Internet Connect Services 2700 Radio Way Missoula, Montana 59802 406-541-4952 webmaster@montana.com http://www.montana.com/ics http://www.montana.com/showcase
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.We've used 3 different text editors on 3 different platforms and 3 different programmers, with all of us being very careful, but we all get the same result.>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 ...We'll try this, seems kind of round about though.>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 .We create these types of files daily in our UNIX environment, that's why it's so troubling. Maybe we're looking in the wrong place for the problem.ThanksMarkMark Mesenko -Webmaster- Internet Connect Services 2700 Radio Way Missoula, Montana 59802 406-541-4952 webmaster@montana.com http://www.montana.com/ics http://www.montana.com/showcase
Mark Mesenko
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:
OK, here goes... (1997)
ftp to webstar (2001)
attachment (2000)
or command (2003)
Image download problem (2001)
Encrypt question. (2000)
Locking up with WebCatalog... (1997)
ConverChars (1999)
Possible Bug in 2.0b15.acgi (1997)
FTP upload TCP Connect (2003)
email [title] (1997)
Nested tags count question (1997)
WC2b15 File Corruption (1997)
Database location (2002)
WebCat b15 Mac plug-in (1997)
Help!!!! Purchases not going through! FIXED! (1997)
Hiding HTML and breaking the page (1997)
It gets better... posting problems + Webcat 3.0.7 available -did anyone know? (2000)
[WebDNA] Browser types (2010)
Round up prices (2000)