Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Paradox > Re: How to set ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 6 of 10 Topic 1298 of 1417
Post > Topic >>

Re: How to set up a table

by "Craig" <craig.futterman@[EMAIL PROTECTED] > Nov 9, 2007 at 05:14 PM

Larry and Steven,
Thanks for you replies.

I took a hybrid approach. (not a Prius) It seems to work quite well.
See below.

Thanks for you help.

Craig

t  =Time("07:00:00 AM")
i = 0
TC.edit()
;TC.insertRecord()
While True
   For j from 0 to 23  ;// # of hours in a day
      TC.insertAfterRecord()
      TC.MRNumber = stMR
      TC.DateOfOperation = d

          If j = 17 then
             i = i+1 ;// increments the day after MN
          ENDIF
      t2 = t + (3600000*j)   ;// increments the time by 1 hour (3,600,000 
seconds/hr)
      dt = Datetime(Strval(t2) +", "+ StrVal(d+i))

      TC.DayTime = dt
      TC.postRecord()
     If i = 4 and j =23 then
       quitloop
      ENDIF
   ENDFOR
      If  i = 4 and j =23 then
       quitloop
      ENDIF

 ENDWHILE
 




 10 Posts in Topic:
How to set up a table
"Craig" <cra  2007-11-09 12:28:35 
Re: How to set up a table
"Steven Green"   2007-11-09 12:38:50 
Re: How to set up a table
"Craig" <cra  2007-11-09 14:10:07 
Re: How to set up a table
"Larry DiGiovanni&qu  2007-11-09 15:09:49 
Re: How to set up a table
"Craig" <cra  2007-11-09 15:49:05 
Re: How to set up a table
"Craig" <cra  2007-11-09 17:14:57 
Re: How to set up a table
"Larry DiGiovanni&qu  2007-11-12 10:42:23 
Re: How to set up a table
"Anders Jonsson"  2007-11-12 17:36:47 
Re: How to set up a table
"Anders Jonsson"  2007-11-12 20:53:11 
Re: How to set up a table
Dennis Santoro <RDAPre  2007-11-11 15:33:13 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sun Oct 12 17:35:14 CDT 2008.