PDA

View Full Version : Install SQL tables



NewsArchive
05-15-2008, 01:48 AM
Perhaps wrong NG, but anyway.
IN TPS based programs, its easy to install some standard tables, e.g
months.tps contains the months names by simple file copying.

But when its MSSQL based, its another story.

OK, I have Capesoft FM3, so it should be possible with a new installation to
insert the file.
But updates...

Month names don't change so often, but my List & Label tables are changing
by every update.

Hints?

Edvard Korsbæk

NewsArchive
05-15-2008, 03:41 AM
Run a SQL script called say months.sql
containing something like
CREATE TABLE months
INSERT into this table
('January',...)
and just run it wherever, whenever...

--
Greetings

Johan van Zyl
http://www.medx.info
http://www.watzon.co.za
http://www.jvz.co.za
Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!
Teach a man how to surf the Internet and he will never bother you again.