Recent content by EKC

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...