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 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...
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...
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 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 ...
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...
Hi Experts,
I am trying to create a payroll / leave system in Filemaker. The objective is:
1. Get daily time & attendance data from bio metric machine from remote offices
2. Import the ...
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?
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 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...
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'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...
(Using FileMaker Pro Avdanced 8.5v2)
I am working on a database that will act as a Purchase Order system. It has two tables:
1. Accounts
2. Purchases
"Accounts" contains two fields wi...
Is it possible to use a 32-bit ODBC driver in a Win 2008 64-bit OS machine ?
Is 32-bit emulation mode related in any way ?
Hi There,
I am trying to open a cash drawer in VB6 that is connected to a PRP-085lllT thermal receipt printer via RJ45 Telephone like cable. The printer is connected to the pc via usb.
...
how do i use custom dialog box when a user clicks "YES" then perform script 1 and "NO" to perform script2?
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 testing Filemaker Pro 10. I have 2 tables, Competitors (compeditorID,name, address, etc.) and Scores (compeditorID,event1,event2, etc.). I want to import a CSV file of scores (name, event...
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 have hidden the left navigation pane from users, but I need to let them know how many records they have found when they perform a FIND? is this possible?
thx..BobR
How do I cleanly import the data in over 1000 VCards (in Entourage Contact folder) into FileMaker?
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...
