Post reply

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.

Name:
Email:
Subject:
Message icon:
Attach:
(Clear Attachment)
(more attachments)
Allowed file types: gif, jpg, png, txt, tpl, lng, ini, pvd, psf, ini, cfg, csv, zip, xml, pas, 7z
Restrictions: 4 per post, maximum total size 1024KB, maximum individual size 1024KB
Note that any files attached will not be displayed until approved by a moderator.
Verification:
Type the letters shown in the picture
Listen to the letters / Request another image

Type the letters shown in the picture:
How many words are in this question?:

shortcuts: hit alt+s to submit/post or alt+p to preview


Topic Summary

Posted by: rick.ca
« on: January 13, 2012, 10:38:16 pm »

Quote
The question is how to find out the right column and table names of the custom field (marked red)?

Assuming you understand SQL and know how to use the SQL tool (on the Help menu when the program is started with the -debug switch), you could get those using an SQL query tool like FlySpeed SQL Query.

Quote
Or is there an out-fo-the-box way to do what I am attempting to?

Not exactly "out-of-the-box," but you could export [A] with [Title], [Year] and/or [ID] (to match records) and import the A data to [B].
Posted by: skittle
« on: January 13, 2012, 09:43:33 pm »

Hi everybody,

I want to do following:

Take the information of movies field A and move it to the custom field B for every single movie I have in my database.

What I am thinking of is writing a short SQL like following:

UPDATE customfields_table C SET C.mycustomfield=(SELECT M.release FROM movies M);

The question is how to find out the right column and table names of the custom field (marked red)? Or is there an out-fo-the-box way to do what I am attempting to?