Is there a Now() or equivalent function in Filemaker Pro 7 (Mac) that would allow me to build a SQL query to select only records with a date of "right now" and 5 days before?
Right now I ha...
Hi All,
How do I say 'NOT EQUAL' in an SQL statement for FM 6.0 Pro
!= does not work!
Cheers
I have a calculation that takes this information from another field: 5/11/2006 10:27 AM
and converts it to: {ts '2006-5-11 10:27:0'}
Here's the calculation:
"{ts '" & Year (fDate_Modifi...
Hi, I would like to convert a filemaker pro database to a Ms Access one.
I export the records to Access.
Now I have a question about repeating field in Filemaker pro, when I convert the ...
This is what I am trying to do:
I have a file that contains countries, companys and email addresses, I have this file in .doc(MS Word) and .txt format.
I want to parse these information in...
can we install oracle on windowsxp professional ?
Hi everyone,
ive just downloaded file maker pro 9 trial version and it seems to be exaactly what i'm looking for. i have just one question.
can anyone tell me if once ive completed build...
I have records which are duplicates. I can easily find the duplicate records but how can I delete them while leaving one of the duplicates in the database .
thanks
I host a PHP Web site that is connected with FX.php to a FileMaker 8 Advanced data base. The database contain PDF stored in multimedia fields (fields that can contain files). I can make links ...
Can anyone explain whether FileMaker or Access is a better tool for a school database to track people, mailing lists, donations and pledges, fundraising campaigns, and assorted data like after...
The Edit/Sharing/FileMaker Network Settings will show me how many users are presently connected to the database, but not who (account name or IP address). How can I find this out ? It would be...
I haven't worked with FM for some time and I can't find this answer in the books/manuals I have....
I have a lookup field "Time Zone" that finds and displays the time zone name ("Eastern", ...
Hello,
I have set up a database in Filemaker Pro 8 on my Mac, and I want to query the records. I have experience with PHP/MySQL and also a little with MS Access querying. I thought it would...
I'm connecting to a FileMaker Server 9 database using a C# application so I can perform SQL actions on it but I want to integrate the domain account I'm using since I can have FileMaker recogn...
FMP v.8
Mac 10.4
Is there a way to hide a layout's scroll bars? I've always been slightly annoyed by the lack of graphical symmentry on any given layout. Even if my layout doesn't require ...
Hey I need to migrate FileMaker to SQL Server. Does anyone have _any_ experience with hooking to FileMaker through ODBC in order to pull data out of it?
I have one timestamp that represents the date and time the estimate is needed. I have another timestamp that represents completion of the estimate. How do I calculate and display in a friendly...
can I write a n execute SQL' statement to query into the field definition for a calculated field? If so, what is the format in the calculated field 'options' dialogue?
I'm using the solution outlined at: http://www.experts-exchange.com/Databases/FileMaker/Q_21732690.html to create a query to an SQL server. However, it doesn't seem to be working to get all th...
I've been all across the Internet today looking for an answer to this question and haven't found a satisfactory answer.
I'm using FileMaker 8 and I want to be able to change the background ...
I lost the username and password to a FileMaker 9 Server i was building. does any oone know the location of the user account and password file. Thanks
Yesterday, I upgraded to Pro 9 Advanced from Pro 9. Last night there was a ferocious thunderstorm which caused the server to restart. This morning the other person in is able to start Pro 9 wi...
I have imported a database from Excel where First and Last name are in the same field.
I would like to split the First and the Last Name in 2 different fields First Name and Last Name.
Does ...
Greetings,
I've found several questions about creating a file to open a remote filemaker db.
How do I modify that script so it opens a specific database instead of just opening the ope...
I am running a script to filter records by Year which works well. The only problem is that I have to enter the year in question in the actual script. What I want to be able to do is select a y...
