Recent content by DVFS

I am very familliar with SQL databases and am using FileMaker 5.5 for the first time. Is there any way to issue commands to query or modify large chunks of data? I am looking at the ScriptMaker from the menu but that appears to be some kind of Macro creator. I'm just not familliar with what...

When trying to open sent internet e-mails from history I occasionally get the message "Body of E-mail Unavailable". Does anyone know why this occurs and how to correct it? Thanks

I am having a problem getting the correct settings to allow users to view, edit and delete their own histories but only have access to view another users. When I take the check out of Access to Others History it sets it so they can't even view another users histoty. Please tell me the correct...

Yes I realized I had an error in the statement after I posted it. However, this is exactly what I needed to know. Thank you very much for your help!

BTW, I am using MS SQL 7

Hi, I am new at using SQL and I made a very simple query to pull a few fields from 2 different tables. Now I need to add a field from a 3rd table but I am not sure how to link them. My statement so far is: select key1 as 'ASI#', contact1.Company, contsupp.contact as "Type", contsupref as "Web...

I have a problem with a report I am doing where I need to get complete totals for codes but I am getting them separated by my groups. I have them grouped by Activity Code, Reference Code and then Result code. I would like the report to turn out like this - Activity Codes 1 - (count) 2 -...

Is there any way that you can set a margin down the center of the report so data can continue and still stay on one page? I have 1 very narrow column that is just showing some quick totals and it is using 3 pages. They could easily fit on one page if I could make a margin. Thanks Joe

Both samples worked great, I appreciate the help.

Duplicate records ignoring primary keys. Sorry.

What is a quick SQL query to simply show me a list of duplicate records that exist in a database?

I am using Crystal Reports 9 and when I go to the Visual Linking screen not all of my tables come up with the color coded index markers indicating my indexes. They do infact have indexes but the markers only seem to appear randomly. I tried browsing to an external index but they still do not...

I am having the same probelm. This only occurs with users connecting to Goldmine via VPN. It doesn't matter what user logs in, it still happens. Auto roll-over is disabled but this still occurs. I'd prefer to avoid rebooting the server. Does anyone have any other ideas what might be causing this?

Hi am am trying to get this string to date conversion working. When I check it it tells me there is no errors in the formula. However when I run the report I get "Bad date format string." Here is what I am trying to use: if {Contact1.ACCOUNTNO} startswith "A" then...

When I am trying to run a report linked with 2 DBF files I get the error xBase error: Bad User Specified Key Expression. Does anyone have any idea of what this is and how to correct it? Thanks, Joe