Due to enormous amounts of spam, the forum has been set to read-only mode.



Reply to topic  [ 2 posts ] 
Batch / Service program. 
Author Message

Joined: Thu Aug 02, 2007 12:35 pm
Posts: 30
Location: DK Nordsjaeland
Post Batch / Service program.

Hi.

What about a program for general use (All your programs) to use for modify / edit / move all records in the database.

An exampel.

I want to move data from video/custom2 to contenta/custom2

Right now, it's a timeconsuming work, but with a batchprogram, it's just start the process and then use the time om other things.


Tue Nov 13, 2007 1:03 pm
Profile
Site Admin
User avatar

Joined: Fri Nov 22, 2002 3:52 pm
Posts: 13748
Post Re: Batch / Service program.

balcom wrote:
Hi.

What about a program for general use (All your programs) to use for modify / edit / move all records in the database.

An exampel.

I want to move data from video/custom2 to contenta/custom2

Right now, it's a timeconsuming work, but with a batchprogram, it's just start the process and then use the time om other things.

Yes, a function to move data between fields is definitely something that hopefully will be added in a future version.

However, you can actually use the SQLUpdate add-on to move data from one field to another. To move data from Video.Custom 2 to Contents.Custom 2:

1. Backup your database :!: :!: :!:

2. Download from run http://www.fnprg.com/dl/sqlupdate.exe

3. Click the ... button and select your database file.

4. Run this sql update query:

Code:
UPDATE ContentsCustom, VideoCustom, Contents, VideoCustom INNER JOIN Contents ON VideoCustom.VideoID = Contents.VideoID, Contents INNER JOIN ContentsCustom ON Contents.ContentsID = ContentsCustom.ContentsID SET ContentsCustom.Custom02 = VideoCustom.Custom02 WHERE ContentsCustom.Custom02 = ""


5. And finally to clear the video.custom 2 field:

Code:
UPDATE VideoCustom SET Custom02 = ""

_________________
Fredrik Nordbakke
www.fnprg.com


Tue Nov 13, 2007 2:34 pm
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 2 posts ] 

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.