you can use a hidden db edit field and put a variable in the default value.
Then you can increment the date variable in the "on before insert" eep. Dan Goldberg -------------------------------------------------- From: "dbgeoinfo" <[email protected]> Sent: Wednesday, February 09, 2011 6:36 PM To: "RBASE-L Mailing List" <[email protected]> Subject: [RBASE-L] - RE: DUPLICATE DATE IN NEXT ROW Thanks: Jim. I'll do that. Anyone - any hints on part 1? Joe DB -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Friday, 4 February 2011 7:02 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: DUPLICATE DATE IN NEXT ROW Joe, To answer your second question. On the Form's On Before Start EEP set the variables you want to use to NULL. Ex: SET VAR vJobhrs DOUBLE = NULL SET VAR vJobrate CURRENCY = NULL James Belisle -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Joseph Drake-Brockman Sent: Friday, February 04, 2011 1:40 AM To: RBASE-L Mailing List Subject: [RBASE-L] - DUPLICATE DATE IN NEXT ROW HELLO ALL: I am using a scrolling DBGRID in a 2 part form. I use 7.6. How do I go about getting the date to increment by 1 day from the previous row when I insert a new row. It still has to be editable as a one day increment can be wrong (it might be the same day for example) but a one day increment is mostly ok. Best would to be two save buttons - 1 save-new row-repeat date 2 save, new row, increment date by 1 day. On another tack - how would I initialize eep variables so they do not throw up errors when I open the form. The Eep is very simple - just calculates the job amount from hours entered and rate entered. But it does not initialize until I enter 1 row of data. After that it's ok. I guess on open form eep???? Joe DB Drake-Brockman Geoinfo Pty Ltd 404 Great Eastern Highway Woodbridge, Perth, Australia, 6056 Tel / Fax +61 8 9274 5477 Mob 0427 525952 Email [email protected]
