DSLfuel

A case is open until a closed action appears in the Actions database.

I have a Case Tracking database that has a portal linked to an Actions database. When a customer opens a new case an Open action is created in the portal and consequently in the Actions database. On the Case Tracking database I have a field that lists the status of this particular case. I want to fill this field in the with the current status but still be able to index the field as people need to search by this. I'm not sure how to get this field to list the most current status without using a calculation field. I could write a script to lookup the value but I'd have to constantly be running the script so that the field never contained the wrong status. Any help is appreicated, thanks...

This solution worked perfectly thanks. The search is much faster too...

I do know that you can easily query FM with VB code to get values out of databases. You can also trigger scripts within FM through VB code. However, if you ever want to set values in FM through VB then you're screwed unless you like writing 200-page INSERT SQL commands (FM ODBC support sucks!). Here are two links that have *some* info on VB/ODBC/FileMaker. www.filemaker.dk/support/tips/jlw99.pdf www.kipwmi.com/fm/tips/doscript.htm Also search the Microsoft Knowledge Base for FileMaker and you should find one article regarding connecting to FM. I've been letting everyone I know not to ever waste money on FM support by asking them questions regarding VB and FileMaker. All support techs just blame Microsoft for all of FM's ODBC problems and close your support cases. Someday they may create useful ODBC drivers...

I'm trying to find a way to perform two actions in one script: Action 1(Already works): Search for all records w/in a specific date range and that contain a certain critera within each records portal. Action 2(The problem): Once I know how many cases there are that meet this critera I want to know how many of the portal rows within each case have a certain criteria. I actually need the number (i.e. portal for record 1 contains 5 occurances of a particular word, record 2 contains 1, and so on for each record in the set I've found). There is probably a much easier way to do this than what I'm doing so any help is appreciated.

I've got a VB program that currently opens an ODBC connection to FileMaker and finds a particular record. The program then pulls the feild data out of the database and performs particular functions. I'd like to start using the same program to create new records and change field values. However, the feild values aren't changing when the program runs, even though I can see that the feilds are being accessed line by line. Has anyone else run across a similar issue. Here is the code I'm using to access FM: Set cn = New ADODB.Connection Set rs = New ADODB.Recordset Set cm = New ADODB.Command cn.Open "Provider=MSDASQL.1;Data Source=FMTest;database=myDatabase.fp5 cn.CursorLocation = adUseServer rs.CursorType = adOpenStatic rs.LockType = adLockBatchOptimistic rs.Open "Select * from myDatabase where myDatabaseValue = '" & strDCN & "'", cn rs.fields(ContactEmail).value = "byteme@aol.com" I can get the value out of the field but can't set it using the same code. Ah the simple joys of ODBC and FileMaker...

I've got a VB program that currently opens an ODBC connection to FileMaker and finds a particular record. The program then pulls the feild data out of the database and performs particular functions. I'd like to start using the same program to create new records and change field values. However, the feild values aren't changing when the program runs, even though I can see that the feilds are being accessed line by line. Has anyone else run across a similar issue. Here is the code I'm using to access FM: Set cn = New ADODB.Connection Set rs = New ADODB.Recordset Set cm = New ADODB.Command cn.Open "Provider=MSDASQL.1;Data Source=FMTest;database=myDatabase.fp5 cn.CursorLocation = adUseServer rs.CursorType = adOpenStatic rs.LockType = adLockBatchOptimistic rs.Open "Select * from myDatabase where myDatabaseValue = '" & strDCN & "'", cn rs.fields(ContactEmail).value = "byteme@aol.com" I can get the value out of the field but can't set it using the same code. Ah the simple joys of ODBC and FileMaker... (We don't allow duplicate posts of the same topic. I'm closing this thread. -bd) [ February 25, 2002, 06:15 PM: Message edited by: LiveOak ]

I'm trying to run FileMaker Server 5.5 from a Windows 2000 Server but I'm getting a service-specific error 21. I've tried reinstalling the OS and restarting the box but the service refuses to start. Any help is appreciated.