Wednesday, August 20, 2008 Tip of the Day: Handling Milliseconds in Parameterized Update Statements
Section: Converting MS SQL or Oracle databases to R:BASE When converting MS SQL or Oracle databases to R:BASE Turbo V-8 or R:BASE eXtreme (version 9.0), or using parameterized update statements, it takes the hours, minutes, and seconds, but drops off the milliseconds. By default, the milliseconds are not set in the configuration file of R:BASE and OTERRO. However, if you wish to deal with milliseconds, you will need to add that option in R:BASE and OTERRO configuration files accordingly. Here's how: In Oterro configuration file (Oterro35.cfg, Oterro40.cfg, or Oterro8.cfg), change the TIME FORMAT (line 48) to HH:MM:SS.SSS and TIME SEQUENCE (line 49) to HHMMSSSSS. Additional ".SSS" are used to handle milliseconds. Example: TIME FORMAT HH:MM:SS.SSS TIME SEQUENCE HHMMSSSSS Based on the R:BASE version, follow the same routine for appropriate R:BASE configuration file(s). In addition, make sure that the CONNected R:BASE database settings are also configured accordingly. That's all there is to it. Razzak. P.S. Yes, I am having fun converting MS SQL databases to R:BASE!
