hello,

 

I'm Dedy from Indonesia, Jakarta

I using FM pro11 for Video ID datebase.

First I have 9 Tables and many fields how to set if i want to seaching the Video ID in many tables?....

and i want to seaching or find start date to end date.

 

thanks 

 

 

regards

 

 

dedy

If you're storing a Video ID in all of your tables, you may have a structural problem. What are your tables, and how are they related to each other.

 

As for how to find records with a matching Video ID that are also within a specified date range within one table, you'd script something like this:

Enter Find Mode
Go to Layout [ ... ]
# Go to Layout is not needed if the script is already on the target layout
Set Field [Table::id_Video; Value:$id_Video]
Set Field [Table::date; Value: $startDate & "..." & $endDate]
Set Error Capture [On]
Perform Find []
Set Variable [$error; Value:Get ( LastError )]
Set Error Capture [Off]

thank you

 

can you help me about my database, because I don't understand about programing.

I Video Editor.

Thanks you for your support me

 

regards

 

 

Dedy

 

 

 

videodatabase-kbj.fmp12.zip

If you need more detailed help, have you considered hiring another developer for programming or coaching servies?

You can post an ad in our Services Wanted Topic Area too. Link