Enhance search function

[quote user="kgmamman"]

[:O] Never used the PHCP so far

[/quote]

This is the only way to show which patient is "owned" by which doc.

>Now i get the point. All the while my impression was who ever entered the details owned the patient.

That would mean the receptionists would own all the patients![]

I can think up one potential method to populate the PHCP field with the "correct" surgeon. It would depend on if each patient had the surgeon's name "somewhere" in a consult note. It would assume that only that surgeon's name appeared in the patient's files.

Method: search through consult notes for a patient for the surgeon's name. If the surgeon's name was Firstname Lastname ... search for Lastname .... and if it exists ... change that patient's PHCP to Lastname.

There isn't a way to query on this field at present.

But a 3rd party tool like Crystal Reports could build the report for you.

I was envisioning it might be doable in IBOconsole.

IBOconsole allows you to enter sql queries .. but it does not construct them for you.

So, you need a QBE tool.

Just a plug for open source -- Sun Report Builder is relatively new to the OpenOffice suite. It's an extension that's installed to "stock" OpenOffice. Looks a lot like Access, does grouping, etc, and has a QBE tool. "Stock" OpenOffice Base does have a QBE tool, but they have improved it in recent releases.

Jerry, have you actually used it to query the Synapse database?

If so, how hard was it?

I haven't used an RDBMS to connect to remr.fdb at all yet (other than isql when we were working on the Synapse LivePC). I have used OpenOffice BASE for other projects, however. It's QBE tool works pretty much just like Access. My main criticism of BASE so far (I haven't used it with OpenOffice 2.4 at all) is that the HSQLDB database engine works fine and is fast, but the OpenOffice Writer as a report and form tool is very slow. I haven't used Sun Report Builder yet, but have read about it and It's supposed to be OK - I'm hoping its' significantly faster than OO Writer. I will try it soon and report as to how well it actually seems to work with Synapse.

Might be interesting to bundle a customized version of OO with Synapse.

I see an "all files" in the drop down.

Firebird doesn't use the file extension ... so you could rename it as long as you also change your System DSN in the ODBC manager.

Actually I would have thought Crystal Reports would allow you to use the DSN rather than open the database directly.

This means you either would create a DSN on one of the client PCs, or run it on the Server.

Disclaimer: never used CR

Actually I would have thought Crystal Reports would allow you to use the DSN rather than open the database directly.

This means you either would create a DSN on one of the client PCs, or run it on the Server.

Disclaimer: never used CR

I downloaded OpenOffice.org 2.4 and connected okay to the Synapse database.

I was able to build simple queries but I think I am going to have to do some reading to see how joins are done.