Find and Seaching the names

[D3D1]

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

[jbante]

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]

[D3D1]

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

[jbante]

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

[Lee Smith]

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