Search results for query: *

i have created the view that will give me the p.id and p.date feild but this feild is a count of days from jan 1 0001 day one of the first year and i am not sure how to show it right in the view. also created a secound view that gives me r.id fname lname admit and ftype

9 and no errors

i need to create a view to comapare data from two different tables tbl1, will show r.id, fname,lname,admit,ftype tbl2 will show p.id,p.date now i need to see only recors where tbl1.admit=1 and tbl1.ftype = 'il'and where tbl2.date={?Date}and tbl2.id<>tbl1.id pluse the date feild is a numaric...

sorry but no the date feild is a numarical feild that must be coverted in to a date i am un sure how t do this in the pcc

i have had to ajust the date feild in crystal useing the formula below how dose ths affect the above example StringVar DT := {RM_AAOD_POS_In___295.Date}; Date ( Val (DT [ 1 to 4 ]), Val (DT[ 5 to 6 ]), Val (DT[ 7 to 8 ]))

ill give it a shot

i use pervasive sql here is how i created my view select P.Profile_ID ID, p.First_Name Fname, p.Last_Name Lname,p.Admitted_To_Facility admit,Ast_Facility_Type FType from PA_Profile_Master__1 p Where admit = 1 and FType = 'IL'

i am new to this so i will need a bit of hand holding

i use psql for my dbase i have created a view that gives reside id numbers fnames lnames admit and lvl of care i need to use crystal to get a list od numbers form the meal table for a singal date to be entered by the user and compare them to the list in the view and display the ones in the list...

i may be miss stateing what i am tryinng to do i want to stop all out goinng call other then 911 this would include on switch calls lolcal calls and ld call. i want to leave the ext in question with the ability to recive calls

need to block all out going calls even on switch exspet 911

i have an option 11c system. i need to setup a block for an ext so that only incomeing calls are allowed what options under class of service should i change?