Keep getting the error:"Conflicting expression data types"

[lemow]

Hi,

From "PatRec", when I click on "View patient record", this is what I am trying to achieve, when patient lastname is entered, if there is no match, it just exits, if there is one match, it retrieves it, but here is my problem: when there is more than one patients with that lastname, it asks for date of birth and should retrieve it accordingly. However, it keeps giving me the error:"Vie.find(ctod(bdate))", I have tuned the code here and there, made sure my index_set("Birthdate") is defined in the table... but still have no clue why I keep getting this error. Your feedback is much appreciated. Attached is forms and tables needed to see what I am doing. "Vie" is the form that is retrieved... I am sure most of you would know once looking at the code on "View Patient Record".

[Stan Mathews]

Re: Keep getting the error:"Conflicting expression data types"

Hi,

From "PatRec", when I click on "View patient record", this is what I am trying to achieve, when patient lastname is entered, if there is no match, it just exits, if there is one match, it retrieves it, but here is my problem: when there is more than one patients with that lastname, it asks for date of birth and should retrieve it accordingly. However, it keeps giving me the error:"Vie.find(ctod(bdate))", I have tuned the code here and there, made sure my index_set("Birthdate") is defined in the table... but still have no clue why I keep getting this error. Your feedback is much appreciated. Attached is forms and tables needed to see what I am doing. "Vie" is the form that is retrieved... I am sure most of you would know once looking at the code on "View Patient Record".

Try your attachment again. I find the patient and prescription tables. There is no vie form based on either. When viewing the patrec form based on the patient table, entering a bogus name, there is an error "Vie = form.load("vie").

Perhaps there is a set upon which vie is based?

In the code for the button to view patient history I did notice you have

vie.index_set("Birthdate")

followed by

query.filter = ....
query.order = "Patient_fi+Patient_la"
...

The setting of the query order and running of the query is overriding the index_set(). IOW the form in then in firstname lastname order, not birthdate. Move that line (vie.index_set("Birthdate")) to just before

Vie.find(ctod(bdate))

[lemow]

Re: Keep getting the error:"Conflicting expression data types"

Hi Stan,

Thanks for your reply. Yes, the form vie is based upon a set (I am surprised it's not here!). Your post:"IOW the form in then in firstname lastname order", what does IOW mean? I did move the line (Vie.Index_set("Birthdate")) as you suggested but still got the same error!

[Tom Cone Jr]

Re: Keep getting the error:"Conflicting expression data types"

what does IOW mean?

"In other words"

[lemow]

Re: Keep getting the error:"Conflicting expression data types"

After changing the index for the set with only "Dob" for Order, it didn't give any error, however it didn't point me to the right patient! how can I do this in a way that if there is more than one patient with same lastname, then it would do query based on birthdate? Thanks.

[Stan Mathews]

Re: Keep getting the error:"Conflicting expression data types"

when there is more than one patients with that lastname, it asks for date of birth and should retrieve it accordingly

when there is more than one match you will have to query for the lastname and the birthdate combined to retrieve the correct record. Attach your set and tables (right click on the set in the control panel and zip from there) now that you have gotten rid of the conflicting data types.

You might try changing

query.filter = "Dob = ("+var->birthdate+"}"

to

query.filter = "Patient_la = "+quote(var->lastname)+".and. Dob = {"+var->birthdate+"}"

[lemow]

Re: Keep getting the error:"Conflicting expression data types"

Stan,

I did as you suggested but somehow, it's not querying right!
As you note in the code under "View Patient Record", there are 2 sets of query, once at the top for Patient lastname and once when there is more than one record (with same lastname). I am wondering if I should have one set of queries instead of 2? The reason I ask this is because it seems that no matter what I put for query.filter and query.order of 2nd section (when qfind>1), it doesn't change its behavior... As always thank you.

[lemow]

Re: Keep getting the error:"Conflicting expression data types"

I realized you may need to have the actual set in question, see attached. As you note, when you enter:"Kelly" as patient lastname, it points to the correct record, however, if you enter:"Rosen", after it asks for date of birth, you can either enter:"11/03/1952" or "05/28/1983"... when entering "05/28/1983", you see that it's not pointing to the right birthdate! Thanks.

[Stan Mathews]

Re: Keep getting the error:"Conflicting expression data types"

I realized you may need to have the actual set in question, see attached. As you note, when you enter:"Kelly" as patient lastname, it points to the correct record, however, if you enter:"Rosen", after it asks for date of birth, you can either enter:"11/03/1952" or "05/28/1983"... when entering "05/28/1983", you see that it's not pointing to the right birthdate! Thanks.

You were/are querying the prescription table for the patient last name and dob, neither of which should be in there. Those fields are patient specific and belong only in the patient table.

I changed the patient_re field in the patient table to character type to match the patient_id type in prescription. I changed the linking field for the set to be patient_re <-> patient_id. Never a good idea to use last names (any names) as a linking field.

I changed the fields on the vie form to refer to patient table patient_fi, patient_la, dob. I see no reason these should be in the prescription table either.

I think my attachment does what you want.

[lemow]

Re: Keep getting the error:&quot;Conflicting expression data types&quot;

Thank you Stan. Now I see what was wrong... I am going to try your changes on my side and let you know. You have been a great help.