jc6's articles:

Items(45) /5 Next >> Last >|

Parsing Date 3 64 (1/27/2009 7:48:30 PM) comp.databases.filemaker I have a date field. But the vendor is sending over a date in this format 20090116 meaning Jan 16 2009 What kind of script can be written to parse that out correctly. Thanks in Advance JC ... jc

Round Function #2 2 53 (1/20/2009 10:50:13 PM) comp.databases.filemaker I have a field named "weight" if the weight = 223 I need it to round up to 225. If the weight is 322 I need it to round down to 320. I want it to round to the nearest 5 pound up or down no matter what th... jc

Simple Log File 2 44 (11/2/2006 8:38:22 PM) comp.databases.filemaker I have created a text field name "log file" I am trying to capture errors in scripts by "set field" if something goes wrong. I have seen it whereby each time a script runs, the Log File field "appends" itself... JC

Send Command Line message 1 73 (10/19/2006 3:10:19 PM) comp.databases.filemaker I have a program and this is the path to the program. c:\Program Files\NCH Swift Sound\IVM.exe Their manual says that it will accept the following command to add a number to the dialing list. IVM.exe -outbou... JC

right word, left word formula 3 73 (10/10/2006 9:55:08 AM) comp.databases.filemaker Having trouble making this work. I am trying to convert Smith,John B to John Smith what I am doing works fine as long as there is no middle initial. thanks JC Lewis ... JC

Dialing Phone Numbers 1 56 (10/5/2006 10:07:42 PM) comp.databases.filemaker I have a company that sends me an xml file each time a telephone call comes into a business. So I create a record from that in the database. Is it possible to have Filemaker dial the number back that just ca... JC

Work Days 1 69 (8/30/2006 1:43:04 PM) comp.databases.filemaker Using the following calc for find work days between 2 dates: WorkDays (number result) = Int ((EndDate - StartDate)/7) * 5 + Mod (EndDate - StartDate, 7) - If (Mod (EndDate - Date (1, 3, 1904), 7) < Mod (StartD... JC

odbc #2 6 64 (8/18/2006 10:16:42 PM) comp.databases.filemaker I have a program that needs to connect to Filemaker 7 using odbc to collect data. How do you set up that connection? I have read FM take on it, but it seems to be in the vein of FM getting data from another s... JC

Importing Data FM8 VS FM7 1 49 (8/16/2006 12:46:52 PM) comp.databases.filemaker I have a database with about 6000 records. Granted there are a lot of summary fields in the database. However; I have noticed that if I use FM8 to import the records from the old db to the new, I can watch ea... JC

Import Data 1 72 (8/2/2006 3:05:07 PM) comp.databases.filemaker I am importing a .csv file by script. Something I have done a thousand times. But, this time I cannot get the "update matching records" to come up as an opiton. The only option that is not greyed out is the ... JC

jc6's replies:

Items(17) /2 Next >> Last >|

Linking Filemaker to Word/ Customizing Donations 2.0 4 46 (9/5/2006 3:02:51 PM) comp.databases.filemaker I am currently working with Filemaker Donations, which has a semi-great Mail Template so we can send mail directly from the database. The great part is that it handles some of the complicated things, such as r... gfiorillo (2)

Asking again 5 42 (9/20/2006 9:43:09 PM) comp.databases.filemaker cause I'm sure it's been asked before and answered, but I can't find it: Is it possible to open a remote file via the internet NOT using FMIWP, Citrix, psAnywhere or other apps. Is it a matter of port assign... sailor5336 (90)

Password Problem - PLEASE HELP! 7 57 (9/28/2006 3:22:09 PM) comp.databases.filemaker Hi everyone. I'm new to the group, so please have pity on me :) I'm trying to establish a password in filemaker pro 8.5. But everytime i try and use my password, i receive an error. Here are the steps i'm t... martinandsons (3)

right word, left word formula 3 73 (10/10/2006 9:55:08 AM) comp.databases.filemaker Having trouble making this work. I am trying to convert Smith,John B to John Smith what I am doing works fine as long as there is no middle initial. thanks JC Lewis ... jc6 (65)

Simple Log File 2 44 (11/2/2006 8:38:22 PM) comp.databases.filemaker I have created a text field name "log file" I am trying to capture errors in scripts by "set field" if something goes wrong. I have seen it whereby each time a script runs, the Log File field "appends" itself... jc6 (65)

fmp8.5 leaves process running, then wont restart 2 74 (11/4/2006 12:08:37 PM) comp.databases.filemaker Hi All, FMP8.5 If I close FMP down, it seems to leave a process running (winXP, ctrl alt del, see the process running.) this prevents FMP from running again. I have to kill the process before I can run agai... Citizen10Bears (73)

FM Server 8 not recognizing files 2 56 (12/16/2006 8:33:39 PM) comp.databases.filemaker I'm trying to get FM 8 server to host my database that I recently converted to 8.5 from 6. There are appx. 15 different .fp7 files that I need to serve. For some reason, FM server only recognizes 2 of these fil... PiratesArr (2)

Within a Script: Change Perform Find to Constrain Found Set 11 79 (1/22/2007 7:02:44 PM) comp.databases.filemaker I have to re-work several existing scripts in a medium sized database. My issue is that I would need to change numerous Perform Find script steps to Constrain Found Set script steps. Example of what is there: S... voices.imh (66)

Round Function #2 2 53 (1/20/2009 10:50:13 PM) comp.databases.filemaker I have a field named "weight" if the weight = 223 I need it to round up to 225. If the weight is 322 I need it to round down to 320. I want it to round to the nearest 5 pound up or down no matter what th... jc6 (65)

Parsing Date 3 64 (1/27/2009 7:48:30 PM) comp.databases.filemaker I have a date field. But the vendor is sending over a date in this format 20090116 meaning Jan 16 2009 What kind of script can be written to parse that out correctly. Thanks in Advance JC ... jc6 (65)