Hi All,
How do I say 'NOT EQUAL' in an SQL statement for FM 6.0 Pro
!= does not work!
Cheers
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...
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 ...
can we install oracle on windowsxp professional ?
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...
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 ...
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
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...
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...
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...
Hello all, I'm having trouble with a calculation that I need some help in (FM 9 Advanced). I have 4 fields:
A date field called "subscribed date" (ex. 7/31/2008)
A number field called "Pay...
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...
Hello:
I´d like change the design of the buttons of filemaker something similar to aqua in mac.Could you recommend me something.
Thank
SO I installed the Server Advanced on my web server and it works great with a database on that server. How do I get it to access a remote database? I'm assuming that I want to put the databa...
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 ...
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...
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?
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...
Can Filemaker Server 7 be configured to a non-standard Filemaker port (i.e. not port 5003)? I need to route requests to two separate internal servers.
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
I have a filemaker 3 database that I converted to filemaker 5 format using Filemaker Pro 6 on Win XP. I would like to convert the database to SQL Server. I have no experience using filemaker...
I have designed a Joke Database transformed from the Recipes Starter Solution in FileMaker Pro. I have a Form View, List View, Information Layout and Joke Card layout. The Joke Card layout is ...
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...
