Unable to get data from database.
SELECT Q.ACCOUNT_KEY, Q.PATIENT_KEY, Q.QUOTEMEDSHEADER_KEY, MIN(Q.QUOTEMEDS_KEY) FROM QUOTEMEDS Q WHERE Q.DOCUMENTNO = GROUP BY Q.ACCOUNT_KEY, Q.PATIENT_KEY, Q.QUOTEMEDSHEADER_KEYUnable to get data from database.
Select pd.Name, pd.Address1, pd.Address2, pd.Address3, pd.Address4, pd.Address5, pd.Address6, pd.Number, pd.vatno, pd.Telephone1, pd.Fax, pd.BankName, pd.BankBranchNo, pd.BankAccountNo, pd.BankAccountName, practitioner.PracticeNo, practitioner.FirstName as PractitionerFirstName, practitioner.Surname as PractitionerSurname, t.Title_Desc as PractitionerTitle, tt.Title_Desc as PatientTitle, ttt.Title_Desc as DepTitle, account.Account_Key, member.FirstName as PatientFirstName, member.Surname as PatientSurname, dependent.IDNumber, dependent.Birthday, member.Phone1, member.Phone2, member.Cell, member.MembershipNo, dependent.FirstName as DepFirstName, dependent.Surname as DepSurname, member.VatNo as PatientVatNo, scheme.Scheme_Name as MedAidName, account.DefaultAddress, address.Address1 as PatAdd1, address.Address2 as PatAdd2, province.Province_Name, town.Town_Name, address.PostalCode_Key, QM.DOCUMENTNO, Q.HFUSERS_KEY, QM.TXDATE, MEMBER.BIRTHDAY from QUOTEMEDSHEADER Q LEFT OUTER JOIN ACCOUNT ON ACCOUNT.ACCOUNT_KEY = Q.ACCOUNT_KEY left outer join Practitioner on practitioner.Practitioner_Key = Q.PRACTITIONER_KEY left outer join PracticeDefault pd on pd.PracticeDefault_Key = practitioner.PracticeDefault_Key left outer join Patient member on member.Account_Key = account.Account_Key and member.Patient_Key = 0 left outer join Patient dependent on dependent.Account_Key = account.Account_Key and dependent.Patient_Key = 0 left outer join Title t on t.Title_Key = practitioner.Title_Key left outer join Title tt on tt.Title_Key = member.Title_Key left outer join Title ttt on ttt.Title_Key = dependent.Title_Key left outer join address on address.Address_Type = account.DefaultAddress and address.Account_Key = account.Account_Key and address.Patient_Key = 0 left outer join Province on province.Province_Key = address.Province_Key left outer join Town on town.Town_Key = address.Town_Key left outer join MedicalAid on medicalaid.MedicalAid_Key = account.MedicalAid_Key left outer join Scheme on scheme.Scheme_Key = medicalaid.Scheme_Key left outer join QuoteMeds qm on qm.QuoteMeds_Key = where Q.QUOTEMEDSHEADER_KEY = '';Unable to get data from database.
SELECT MESSAGE1, MESSAGE2, MESSAGE3 FROM QUOTEMESSAGE WHERE QUOTE_KEY =Unable to get data from database.
SELECT COUNT(*) AS RECORDCOUNT FROM "RDB$RELATION_FIELDS" WHERE "RDB$RELATION_NAME" = 'SYSTEMDEFAULTS' AND "RDB$FIELD_NAME" = 'ENCRYPTPDF'