Example #1
0
 public void OracleSequence(string tableName, string fieldName, ref int value)
 {
     JCursor cursor = new JCursor(this);
       cursor.Format(string.Format("select {0}Seq.NextVal from dual)", tableName), 0);
       cursor.Run();
       cursor.Read();
       value = cursor.GetInt(0);
 }
Example #2
0
 public void PostgreSQLSequence(string tableName, string fieldName, ref int value)
 {
     JCursor cursor = new JCursor(this);
       cursor.Format(string.Format("select nextval('{0}_{1}_seq')::int", tableName.ToLower(), fieldName.ToLower()), 0);
       cursor.Run();
       cursor.Read();
       value = cursor.GetInt(0);
 }
Example #3
0
 public DBHandler(JConnect connect)
 {
     this.connect = connect;
       cursor = new JCursor(connect);
       fields = null;
       rowSize = 0;
       noRows = 32;
       noFields = 0;
       maxRows = 0;
       Lookup = "";
       UsId = "UsId";
       TmStamp = "TmStamp";
 }