Search results for query: *

How do I get those employees who were 60 years old at date of hire? the date format is: 2002-10-16 00:00:00.000 Here's that I have and it is returning everyone: SELECT hire_date ,birth_date ,RTRIM(last_name) AS LastName ,RTRIM(first_name)AS FirstName ,empno FROM empper WHERE...

I'm getting the following error message: Msg 8120, Level 16, State 1, Line 1 Column 'empper.emp_id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. Here's my code ... what am i doing incorrectly? Thanks .... SELECT...

I've created a table of contents many times before. This is what I have done: 1. I have identified my "title" as "Heading1" 2. I have identified my "subtitle" as "Heading2" 3. I have identified my "sub-subtitle" (not sure if that's correct wording, but hopefully you will get the point) as...

I am in the process of learning to use vb.net. I have an ansi sql database that I want to connect in my vb.net solution. I tired several times but have been unsuccessful. My laptop that I am using is not using a SQL server. Do I need a sql server access in order to access the dbf in vb.net...

Can someone help me with the SET NEAR ON command. The following code works, but it will not return a record that has "Fred Flinstone" in the field, "task". The end result tells me that there are no records found. Here's the code for the Find button: SET NEAR ON IF m.find = 1 AND NOT...

After I created my frontend, I started to enter data. I even hit the save button. When I close out and reopen the db again, the data disappeared. Why has this happened? Please help. Thanks,

How do I write code to extract the year only from a date field such as: 01/01/2004 Thanks,

.... write a code for a push button to "add a new record"? Thanks! Stacy

Help! Why do I get a "mismatched case structure" error? Here's the code: SET CENTURY ON *set defa to j:\testing\document DO CASE CASE m.go=1 DO medata.spr IF m.go1 !=1 RETURN ENDIF CASE m.go=2 CLOSE DATA CLEAR READ RETURN END CASE

Help. I am doing a demographic report. I have to count how many males that are white, black, asian, etc. Here's the code that did not work: COUNT FOR(Demoact.sex="1" and demoact.white="1",1,0) Would you help me write this correctly? Thanks a million! Stacy

What is wrong with the following code? I do not want to show any clients that have a termdate: NOTE: the beginning date = m.begdate & the ending date = m.enddate SELECT *; FROM itatmp; WHERE entertdt_a <= m.enddate; AND (termdate <> m.begdate OR empty(termdate)); INTO table parttmp

My end user sent me the following: Can you assist me with a solution? (my form is setup as a tabular form) "If we are on any tab other than the first one ("provider-training location"), and we scroll to a different record, the next record defaults back to the first tab. In other words, there...

How do I update tables checking the "modified" date in the file manager in the main working directory vs. the "modified" date in the reports folder in another directory? EX: here's the path to the main systems files: c:\abc\ourdata here's the path to the reports menu in another directory...

How can I get a bmp to show clearly in FoxPro 2.6? Thanks!

How do I insert data into a column of numereous records? Thanks

Help! I have 131 fields that I am trying to export into Excel from Chrystal Reports 8.0. I have increased the paper size to 11x17 (oversized) and I am still missing 4 columns of data (on the left side). I changed the font to 8 pts. What are your suggestions?

Help! I have 131 fields that I am trying to export into Excel from Chrystal Reports 8.0. I have increased the paper size to 11x17 (oversized) and I am still missing 4 columns of data (on the left side). I changed the font to 8 pts. What are your suggestions?

Hi. I need help. I am joining 2 tables together by whereby I need at lease 75 fields just from one table. After writing the code, I received an error msg, &quot;Required clause not present in command&quot;. So as a result, I am re-writing the code, line by line, sometimes, code by code and...