Search results for query: *

Hi, I need to validate values of 2 dates on the form before submiting it.I used IsDate function to check if values are dates but I have a problem how to check that dateEnd is later then dateStart.I tried: if document.entry.dateStart.value < document.entry.dateEnd.value but it is not working...

Hi, I have a form with a few input boxes.I want to be sure that required text boxes are filled before submiting form so I have a client side validating in place.When user try to submit form without filling required box,I also want image of arrow to show and point to blank box. I tried few...

Thank you

I have a form with some input elements and 2 list.One list display list of codes I need to display brief explanation based on selected choice.My list is : <select name=&quot;Code&quot;> <option>KTOL <option>POUF <option>YUH <option>TRAM <option>DTM <option>OTHER </select> I have OnChange...

Hi, I have 2 questions: 1.I need to extract decimal portion of the number,multiply it with 0.6 and add it again .Example: 6.45= 6 + (45*0.6)=6.27 2.What function is used to substract dates Thanks, Lyn

Hi, I have a numeric field that need to be converted to time - actually this field show time ex. 15.45 is 15:45.Is there a function that can do this and if not is there a function that can replace a &quot;.&quot; with &quot;:&quot; Ex. Fun(15.45) should return 15:45 Thanks in advance Lyn

So if I create trigger on Order table and include message,it's going to be visible on each machine running front-end and not only on front-end where order is entered.Yes or No? Thanks Lyn

Hi , On a recent presentation of a new (custom made) database managment system(back end can be SQL,VFP,Oracle front end made in Visual C++)I saw nice thing:If new Order is entered everyone is getting MsgBox saying something like &quot;We have a new Order&quot;. Is this possible to do with VFP...

Thanks guys, I really appreciated yours help Lyn

Hi, I need help solving this problem: I need to go trough the table and for OrderID and OrderLine (I pass as a function arguments) loop as long as Sum of RelQTY is Less or equal then QTY(I pass as a third argument) and when this happend ,returnd value of RelDate field of a record.Ex: OrderID...

Hi, Recently I had to do similar thing but in Visual FoxPro so I got this function that you call with your start and end date ** Date1,Date2 are arguments to this function** ldStartDate= IIF(Date1> Date2,Date2,Date1) ldEndinDate = IIF(Date1=> Date2,Date1,Date2) lnNumberOfDays = ldEndinDate -...

Thanks guys, Lyn

Hi, I need help solving next problem: I need to calculate Sum of the QTY from the Table1and store it in a variable.Table1 has OrderID,orderline,reldate,QTY fieldsIt looks like: Order orderLine reldate QTY 111 1 3/1/01 20 111 1 4/1/01 10 111 1...

Hi , I need to add 2 more fields to a table but in Table Designer title bar I have Name of my Table Table1.dbf(ReadOnly).&quot;Insert&quot; new fields command appears dimmed.I checked properti of the Table1.dbf file-it's archive.What could be a problem? Lyn

Hello friends, I'm ashamed to ask this question but I need to (I guess being beginner in VFP gives me that right).So here comes the question:Where do you declare a function? I have my little project that have only one form where user enter information in the boxes and command button which has...

Hello everyone, I have two dates:start date of job(jstart) and end date of job(jend).I need to calculate time needed to finish the job,so I have (jend-jstart).That gives me time in days which is OK but that also include weekends which should't be.So my question is how to eliminate Saturdays and...

Hi , Can someone tell me why my .exe program doesn't work if I save it in location other then location of project.When I build .exe and save it in the same location as project file it works fine.When I save it in another location,after I run it I get Open File box to locate table I used. Thanks, Lyn

Hi , I forget to ask one more question: Because of the denied access to database tables,I need to copy tables to another location in order to work on them (make reports).Some table are very big and copying takes time.Is there another way :can tables be compared and new record added insted...

Hi , I made .EXE file but when started, it closes immediately.I read about similar problem someone posted month ago but I can't find that message. Thanks, Lyn

Hi, I posted my problem earlier but now I have new question( I decided different approach): I have set of records in one cursor(fields are order,orderline ,part,orderdate,QTY).If 2 records have the same order and orderline fields (those records following each other -I sorted them by...