Search results for query: *

I have a field that is character containing dates... Ex: 19991102 I want to convert this to a date field... whats the proper syntak to convert this field to another fields of proper date?

I have a numeric field my database. The data is populated with any number from 0 on up. However, sometime the field is blank, containing no numbers at all. What syntak will isolate the blank records. Everything I try to do evalutes the blank record as being a 0. I dont want a 0 in that field...

I know there must be a simple method to adding a 10% screen to every other line in a simple report... but it is slipping my mind how to accomplish this.

HERE IS AN EXAMPLE OF THE ADDRESSES IN A FILE I AM WORKING ON............................................ 28829ORCHARD LAKE RD 25717POWER RD 28588NORTHWESTERN HWY 315MELFORD 30560BECK RD .............................................. What command or snippet is most useful for...

Hope you can help me. We lost an employee who is well versed in sql server 2000. I am assigned the task to rescue a job we have. He set up an web based program for us that incorporates the use of a database containing 8 tables. All the functions work well, the web site runs fine also. My problem...

I have project I developed that is to be placed on several laptops for use in the field. One laptop is a Compaq Presario 1255. My problem is the forms are developed for a screen resolution of 1024 X 768. The compaq is defaulted to 800 X 600. I tried to change the settings on the compaq, via...

I have a field on my form that the user enters Y/N a logical field. I have tried different approaches to make the field appear as Y or N when they enter it, even thought is acutally F or T. I dont want T or F to show.. I want Y or N to show. Whats the best way to mask a logical field?

I have read other posts about this error, but this still has me stumped. In my form I have a button entry.command.click the command is simply thisform.refresh I get 'field pharse' error when depressed the trace window always points to -->thisform.refresh What am missing or what to...

I have a simple query.... SELECT make, COUNT(make)as quantity; FROM master; INTO CURSOR TMP1 But If I want at the same time, the total percent of the quantity of make against records in the database IE: count(make)/reccount(). What can I add to this syntax Or do I have to run a second...

I understand that SQL statements are optimized when you include a WHERE statement as long as there exists an index on the fields you specify in the condition. Does it follow that this statement is not optimized? select * from mytable; inner join zfield2 on zfield2.thisfield=mytable.thisfield...

select city, zip from automaster where; abs(3956 * acos( sin(radians(39.762))*sin(radians(latitude)) + cos(radians(39.762))*; cos(radians(latitude)) * cos(radians(longitude-84.151)) ) ) <= 10 Is radians a recognized function in Foxpro?

Should the field distance be populated with a number from the following statement (as distance)? All I get is 0.000 All the other data is fine and seems correct. Just dont get the distance. SELECT *, ROUND((ACOS((SIN(val(passedzip.latitude)/57.2958) * SIN(val(passedzip.latitude)/57.2958)) +...

SELE 1 USE File1 ALIAS firstfile SELE 2 USE File2 ALIA secondfile INDEX ON MATCHCODE TAG match SET ORDER TO MATCHCODE SELE 1 SET RELATION TO MATCHCODE INTO B REPLACE ALL A.MYFIELD1 WITH B.MYFIELD2 for A.MATCHCODE= B.MATCHCODE **** Should't this statement update all file1 FIELDS from file2...

I have a rather large database that came from the county in print format. I've never liked county files. Anyway, when I import it into a dbf format, the first line looks likes this... rec 1 B02-002400302011-000 COMBS SUSAN S TRUSTEE LOT 577 500 0.360 4,000 (all...

Sometimes in the form designer (ver. 6.0) I can see the bottom part of the form. I have maximize and minimize set to true and windowstate set to 2-maximized. What am I missing in the designer that does this to me? Thanks

I have placed a button on a form that automates the sending of an email message to my mail box that requires no intervention from the user. My problem is that a message appears stating &quot;A program is trying to automatically send email on your behalf. Do you want to allow this?&quot; (yes/no)...

Lots to learn when dealing with forms I am still finding out. I have basic form (myform1) which contains read only data from a simple name,address,city,st,zip database. I placed a command button on the form called &quot;edit&quot; to access myform2. I have no tags set in the data properties...

I've read FAQ 184-1258 and tried the suggested code in the init area of my form.... I tried _vfp.visible = .f. and I tried ShowWindow = 2 MDIform = .f. ALwaysOnTop=.t. what happens with the second example above is the entire Foxpro session dissapears from the screen all together. All I want...

I used the forms wizard (v. 6.0) to generate the basic data entry screen. I know next to nothing about the underlying code it generates(so far). The form is fine except how the find function works when using the form. Its cumbersome requiring boolean when all I want is a box to pop up, fill in...

I am exporting a file that has to be comma delimited. NO quotes, just the comma. My fields are Nickname,fullname,firstname... etc My results are as follows ,Nickname,,,FullName,,,FirstName,,, Why am I getting extra commas where no fields exist and what command should I be using? Has anyone...