CAPTCHA
Image CAPTCHA
Enter the characters shown in the image.
This question is for testing whether or not you are human.
  • Create new account
  • Reset your password

User account menu

Home
The Hyperlogos
Read Everything

Main navigation

  • Home
  • My Resumé
  • blog
  • Howtos
  • Pages
  • Contact
  • Search

Crystal Reports: Aristocrat OASIS Stored Procedures

Breadcrumb

  • Home
  • Crystal Reports: Aristocrat OASIS Stored Procedures

Aristocrat OASIS' stored procedures require some input in order to function properly. The most important elements to understand are the date specification, the iLockKey value, and the iApplication_ID.

OASIS stored procedures expect date/time values to be specified in the following format: "YYYY-MM-DD HH:MM:SS.mmm" where YYYY is the four-digit year, MM is the two-digit month, DD is the two-digit day, HH is the hour (24-hour time), MM is minutes, SS is seconds, and mmm is microseconds (thousandths.) All of this information must be provided but you can pretty reliably use 00.000 for the seconds and microseconds. There is a space between the date and time.

iLockKey is a locking value to make sure no one else is changing data, probably. However, we're not changing anything anyway. Set iLockKey to -1 when you are asked for it.

iApplication_ID is mostly used for logging, and tells what application is accessing the stored procedure. You can find a list of Application IDs in the OASIS data table CDS_APPLICATION.

database
howto
crystal reports
  • Log in or register to post comments

Footer menu

  • Contact
Powered by Drupal

Copyright © 2025 Martin Espinoza - All rights reserved