Format Date/Time Values for Access SQL in Delphi

Ever get the awful Parameter object is improperly defined. Inconsistent or incomplete information was provided JET error? Heres how to rectify the situation. When you need to create a SQL query against ​an Access database where a date (or a date time) value is used you need to make sure the correct formatting is used. For example, in a SQL query: SELECT * FROM TBL WHERE DateField 10/12/2008 you want to get all the records from the table named TBL where a general date field DateField equals 10/12/2008. Is the line above clear? Is that December, 10 or October, 12? Luckily, we are pretty sure the year in the query is 2008. Should the date part of the query be specified as MM/DD/YYYY or DD/MM/YYYY or maybe YYYYMMDD? And do regional settings play a role here? MS Access, Jet, Date Time Formatting When using Access and JET (dbGo - ADO Delphi controls) the formatting of the SQL for the date field should *always* be: Anything else might work in limited testing but can often lead to unexpected results or errors on the users machine. Heres a custom Delphi function you can use to format a date value for the Access SQL query. For January 29, 1973 the function will return the string #1973-01-29#. Access SQL Date Time Format? As for the date and time formatting, the general format is: This is: #year-month-daySPACEhour:minute:second# As soon as you construct a valid date time string for the SQL using the above general format and try it using any of Delphis dataset components as TADOQuery, you will receive the awful Parameter object is improperly defined. Inconsistent or incomplete information was provided error at run-time! The problem with the format above is in the : character - as it is used for parameters in parametrized Delphi queries. As in ... WHERE DateField :dateValue - here dateValue is a parameter and the : is used to mark it. One way to fix the error is to use another format for date/time (replace : with .): And heres a custom Delphi function to return a string from a date time value you can use when constructing SQL queries for Access where you need to search for a date-time value: The format looks weird but will result in the correctly formatted date time string value to be used in SQL queries! Heres a shorter version using the FormatDateTime routine:

Young African Americans - 919 Words

The increased number of newly diagnosed HIV cases among young males who have sex with men (MSM) are due to the epic behavioral activities of the young African American males who have sex with men. However, identifying health disparities, stigmas and barriers, and prevention interventions can help alleviate HIV among young African American males who have sex with men. Strategies to Alleviate HIV Among Young African American Males (MSM) To decrease or alleviate the HIV epidemic among young African American (MSM) there are three strategies that should be implemented among this population of young men. First, the health disparities among this population should be identified. Secondly, HIV stigmas and barriers that prevent young African†¦show more content†¦This position of the Black Church is a faith-based stigma that causes a barrier for this population, preventing them from seeking preventive interventions and early treatment. Unfortunately, young African American (MSM) are more likely than any other ethnic group to experience barriers to health care, such as getting appointments at private clinics, receiving outpatient health care, and antiretroviral care. HIV Preventions and Interventions The implementation of HIV prevention strategies such as Pre-exposure prophylaxis (PrEP) is a method in which individuals who practice risky behavior take a pill that will prevent them from becoming infected with HIV. Storytelling and new media activities is used to spark the interest of this population. â€Å"For example, Keep it Up! an interactive online program focused on healthy sexuality, relationships, and preventing HIV was recently found to be feasible and acceptable among diverse YMSM† (Macapagal, Birkett, Janulis, Garofalo, Mustunski, 2017). Subsequently, there was an increase of condom use by the young men who participated in this program. The intervention program called Popular Opinion Leader (POL) focuses on training individuals such as the young African American (MSM) to encourage members of his community to practice safer and healthier sexual behaviorShow MoreRelatedThe Death Of A Young African Americans1783 Words   |  8 PagesOver the last few year there hav e been many cases involving the death of a young African Americans being killed in ways that fellow black people would describe as vicious unreasonable manslaughter. The case involving Michael Brown occurred on August 9, 2014, in Ferguson, Missouri. Brown was eighteen years old, and was shot to death by Darren Wilson, a white Ferguson police officer. (Bucanan par. 1) After the trial, Wilson was set free as the jury saw him as innocent for his actions. Due to thisRead MoreEssay on The Cool-Pose of African American Young Men597 Words   |  3 PagesThe Cool Pose is described as the new ways African America males are learning how to cope with hardships involving race and discrimination. This reading explains how African-American men are learning that one can gain success through the use of violence, impatience, and hostility towards other individuals. The way they walk, talk, and express themselves, allow society to favor the young, impoverished black male. Not only does the cool pos e bring them a certain sense of success, but also it brandsRead MoreRapper Olutosin Oduwole, An African Americans Young College Students Essay2133 Words   |  9 Pagesletters were part of a notebook that police had found in a car when they searched it. Even though the lyrics are not appropriate and unpleasant to some people, this was simply an artistic form of expression. Aspiring rapper Olutosin Oduwole, an African Americans young college student, was taken to jury and was proven guilty for acts of terrorism, despite the fact that Oduwole told Jim Suhr from AP that â€Å"It was pieces of a rap song that was discarded — just something written, forgotten about, crumpled upRead MoreStudy on African American Youth and Young Adults with Incarcerated Fathers2164 Words   |  9 PagesThis paper proposes to address the psychological needs, behavioral factors, social factors surrounding a stratified sample of African American youth and young adults with incarcerated fathers. In d oing so, assessment measures possessing test-retest reliability to assess subjects’ mental health conditions, stress related behavior, socioeconomic status, and interpersonal relationships. Incarcerated fathers who are imprisoned for non-violent crimes and are opened to reconcile and/or improve their relationshipRead MoreSocial Justice, And The Demonization Of Young African American Men : Implications For Leadership871 Words   |  4 PagesIntroduction Today’s society cannot escape the deep rooted emotions and experiences related to racial tensions, specifically those concerning interactions between African-Americans and Caucasians. It seems as though young African American men are consistently, violently murdered by Caucasian law enforcement officers at epidemic proportions. These violent murders warrant miniscule rationale, and it is rare that perpetrating law enforcement officers receive repercussions for their treacherously negligentRead MoreThe Social Justice Issues Of The Media Of A White Officer Fatally Shot A Young African American Man1486 Words   |  6 Pagesthese issues. The way that the media portrayed certain groups of people further led to feelings or personal justification of racism and oppression. In Ferguson a main issue of racism came from the fact that a white officer fatally shot a young African American man. Among the beliefs of why this happened was that racial profiling was going on (Madrigal, 2014). Many believe that police officers are using too much of their power over minority groups with their use of unnecessary force (Sneed, 2014)Read MoreMalcolm X : A Young African American2089 Words   |  9 PagesEdom Bogale Research Paper Final Draft Mr. Mullen 6 - 7 - 12 MALCOLM X; EL-HAJJ MALIK EL-SHABAZZ Malcolm X was a young African American who was a militant leader of black independence against white supremacist America. Malcolm was born in Omaha, Nebraska in a small house that he shared with his six other siblings and two parents. Throughout his life he changes from an avidRead MoreGoing Up As A Young African American Girl856 Words   |  4 PagesGoing up as a young African American girl in Philadelphia was not always easy, however having a strong family structure, old fashion southern culture, and beliefs has molded me into the strong women that I am today. Now that I am a mother, following my family’s culture and beliefs are not always the easiest thing to do, because time has changed and I feel like I am forced to conform to the everyday social norms of America. Yes, growing up was not easy, but my family and youth kept me in the darkRead MoreGrowing Up As A Young African American Girl869 Words   |  4 PagesGrowing up as a young African American girl in Phila delphia was not always easy, however, having a strong family structure, old fashion southern culture, and beliefs have molded me into the strong women that I am today. Now that I am a mother, following my family’s culture and beliefs are not always the easiest thing to do. Times has changed and I feel like I am forced to conform to the everyday social norms of America, which makes me feel impuissance. Yes, growing up was not easy, but my familyRead MoreMy Grandmother s Building A Young African American Boy948 Words   |  4 PagesWhen I arrived at my grandmother’s building I saw a young African American boy. He was eight years old; his face dripped with tears and boogers. He felt shameful and embarrassed while he was standing in front of the entrance of the building. Only with his little underwear. I sympathized for the child with my eyes and thought what made him deserve this. There were also other times when I saw kids at the age of seven waiting for their transpo rtation to go to school with their face expression saying

Department of social work Essay Example For Students

Department of social work Essay Master of Social Work- Year 2 Ethics Assignment Matriculation Number: 0235286 Exam Number: 3528633 Submission Date: 12th of December No of Words: 2713 All names have been made anonymous to protect the identity of individuals. Scenario David aged 11 was in residential care along with his 7 siblings. He had a severe history of abuse (sexual, physical and emotional) from a female relative. His stay in this residential setting was one of assessment no work at this stage was being carried out to address these issues. This child was restrained whilst shouting at his brother. This had been an extremely distressing day as three of his younger siblings had been placed with foster carers and these two boys were unsure where they would be going. They had quite a volatile relationship and it had been agreed by all staff that there would be a cool-off time enforced, to calm the children. On this occasion an argument occurred between my colleague and the young person, who we will call David. Unfortunately my colleague did not wait until she has changeover to be informed of the days events and immersed herself in this situation. In residential care the C.A. L.M (Crisis Aggression Limitation Management.) technique is used to support agencies in the management of aggressive and challenging behaviour. This is a very successful and highly regarded model of treatment and is accredited and registered.1 On this occasion my colleague did not have this level of training and used holding techniques, which were unsuitable for residential work. The restraint did not follow the C. A.L.M. physical restraint model. It also lasted for over an hour, which resulted in injury to staff. There was also no trained member of staff on shift and no one that was willing to assist in physical holding. At the beginning of this project, it was made clear who had the adequate training for restraints and those that did not. We were strongly advised not to intervene unless there was no alternative and/or immediate harm would have been caused to a young person or those around them. David became very emotional and his anxiety level increased as he thrashed around and screamed for the member of staff to get off him. He was heard shouting; this is what bad people did to me Even at this stage the restraint did not stop and was clearly upsetting him. I believe the upset was directly related to the holding measures as they were not appropriate or safe holds. Ethical Issues problems The ethical issues around in this scenario include the individual rights of David who should have been given the same rights as he would have at home, also the responsibility that my colleague had to adhere to agency policy and procedures. Ethical Issues around inequality i.e. the power balance between service provider and service user were huge and particularly threatening for David as most of the staff were woman with whom he had a tenuous relationship. In this case; mainly agency personnel staffed the unit. This in itself can have its own drawbacks. Having researched the recruitment practices for this particular agency for the purpose of this essay, and indeed having been recruited by them myself; the level of qualifications and skills required is high. However, on entering a residential unit it is rare that a member of staff will ask you if you are C.A.L.M trained. Ethically, some people due, to their own value base, will not restrain, as they believe it to be damaging to a child. A recurring problem for the social work department will be the staff shortages within the department requiring bank and agency staff to fill the gaps Even when staff have been trained, the training course for C. .u0d549393eee28239d7a72199e6579c01 , .u0d549393eee28239d7a72199e6579c01 .postImageUrl , .u0d549393eee28239d7a72199e6579c01 .centered-text-area { min-height: 80px; position: relative; } .u0d549393eee28239d7a72199e6579c01 , .u0d549393eee28239d7a72199e6579c01:hover , .u0d549393eee28239d7a72199e6579c01:visited , .u0d549393eee28239d7a72199e6579c01:active { border:0!important; } .u0d549393eee28239d7a72199e6579c01 .clearfix:after { content: ""; display: table; clear: both; } .u0d549393eee28239d7a72199e6579c01 { display: block; transition: background-color 250ms; webkit-transition: background-color 250ms; width: 100%; opacity: 1; transition: opacity 250ms; webkit-transition: opacity 250ms; background-color: #95A5A6; } .u0d549393eee28239d7a72199e6579c01:active , .u0d549393eee28239d7a72199e6579c01:hover { opacity: 1; transition: opacity 250ms; webkit-transition: opacity 250ms; background-color: #2C3E50; } .u0d549393eee28239d7a72199e6579c01 .centered-text-area { width: 100%; position: relative ; } .u0d549393eee28239d7a72199e6579c01 .ctaText { border-bottom: 0 solid #fff; color: #2980B9; font-size: 16px; font-weight: bold; margin: 0; padding: 0; text-decoration: underline; } .u0d549393eee28239d7a72199e6579c01 .postTitle { color: #FFFFFF; font-size: 16px; font-weight: 600; margin: 0; padding: 0; width: 100%; } .u0d549393eee28239d7a72199e6579c01 .ctaButton { background-color: #7F8C8D!important; color: #2980B9; border: none; border-radius: 3px; box-shadow: none; font-size: 14px; font-weight: bold; line-height: 26px; moz-border-radius: 3px; text-align: center; text-decoration: none; text-shadow: none; width: 80px; min-height: 80px; background: url(https://artscolumbia.org/wp-content/plugins/intelly-related-posts/assets/images/simple-arrow.png)no-repeat; position: absolute; right: 0; top: 0; } .u0d549393eee28239d7a72199e6579c01:hover .ctaButton { background-color: #34495E!important; } .u0d549393eee28239d7a72199e6579c01 .centered-text { display: table; height: 80px; padding-left : 18px; top: 0; } .u0d549393eee28239d7a72199e6579c01 .u0d549393eee28239d7a72199e6579c01-content { display: table-cell; margin: 0; padding: 0; padding-right: 108px; position: relative; vertical-align: middle; width: 100%; } .u0d549393eee28239d7a72199e6579c01:after { content: ""; display: block; clear: both; } READ: All About Me EssayA.L.M is not considered an essential skill to have for the job within residential work with young people. Children Scotland Act 1995 The Children (Scotland) Act 1995, incorporates provisions from the UN convention on the Rights of the child and also takes account of obligations under the European Convention on human Rights. The Children Scotland Act states that each child has the right to: . be treated as an individual. . Form and express views on matters affecting him or her; and . be protected from all forms of abuse, neglect or exploitation. Parents and local authorities have rights and responsibilities in achieving the balance of care. When considering David, we must look at the scenario in terms of the big picture and look not only at the code of ethics that applies to social service employees but also the statutory duties and obligations that we .