A-Shell Development History

461 — 26-Jul-95

MK2C.C: Fix String and Unformatted termination incompatibility problems during INPUT LINE./ JRB

460 — 25-Jul-95

MK0.C: Add `-s' switch to force standalone mode under DOS and Windows./ JRB

MKE.C: C-ISAM error to A-Shell error translation fixed in isam_error() routine./ JRB

459 — 21-Jul-95

SQL.C: Use SQLTypeInfo() to obtain datasource-dependent string types for each ODBC SQL datatype. Held in a per-connection array./ JRB

New larger ODBC structure now allocated on global heap./ JRB

Support specification of all ODBC SQL data types in .ODC file via SQL: sub-clause./ JRB

Fix GPF fault if connection to datasource fails./ JRB

Column type information is now ALWAYS returned from the datasource, even if it is specified in the `.ODC' file./ JRB

458 — 20-Jul-95

SQL.C: Allocate and prepare one extra translation entry in xlttable which MAY be needed by a unique key field, eg. ROWID./ JRB

Default SQL numeric datalengths more appropriately for binary fields in ODBCcolumns2()./ JRB

457 — 19-Jul-95

MKX2.C: Implement MIAMEX function 40 subfunction 3 (return ODBC availability for an individual file)./ JRB

Implement C-ISAM function 21 - Clear down ODBC file./ PG

SQL.C: Preserve m1.EXT during ODBCODCload() and ODBCCDCload(). (Reports correct filename for errors in A-Shell) / JRB

Modify ODBCODCload() routine to support column definitions split over multiple lines./ PG

Re-structure and simplify ODBCODCload() logic./ JRB

Add ODBCdeleteall() to clear an ODBC table./ PG

Allocate one large global SQL text area for general use./ JRB

456 — 18-Jul-95

SQL.C: Add SQLgetdbmsinfo() to return datasource information./ PG

455 — 17-Jul-95

MKX2.C: Set filespec part of as.f entry during C-ISAM function 4 (allocate C-ISAM file)./ JRB

SQL.C: Use SQLTables() to determine if file exists in ODBCopen(). (MUCH faster that SQLStatistics. Based on PG ODBClookup())/ JRB

Add ODBCaddindex to add index to existing table./ PG

Reinstate global hstmtm (s) handle for ODBCcountrows()./ JRB

454 — 13-Jul-95

MKX2.C: Enhance C-ISAM function 4 to build ODBC files./ PG

Modify slightly to support build of both C-ISAM and ODBC files within the same PPN./ JRB

Enhance C-ISAM function 1 to support ODBC files./ PG

ODBC files within the same PPN./ JRB

SQL.C: Add ODBCODClookup() to check existence of `.ODC' file./ JRB

453 — 12-Jul-95

MK2C.C: Fix ODBCavailable() test in ODBC file open./ JRB

452 — 04-Jul-95

MK2C.C: In xab_CHAIN() default to chaining a `.RUN' file IF in literal mode, otherwise default to a command file./ JRB

451 — 21-Jun-95

MK2C.C: Handle ODBC files on FIND'NEXT and FIND'PREV./ PG

MKX2.C: Add C-ISAM function 20 to return whether file channel is opened as a C-ISAM file or an ODBC table./ PG

Enhance C-ISAM function 19 to read from ODBC files./ PG

Simplify C-ISAM function 19 for ODBC files slightly./ JRB

450 — 20-Jun-95

MK3.C: Return ?Illegal function value correctly in SPACE()./ JRB

SQL.C: Handle `.ODC' files where not all SQL columns are represented by AlphaBASIC fields./ JRB

Add ODBCLogInsertUpdate() to log parameterized SQL./ PG

Rename ODBCLogInsertUpdate() to ODBClogparamsql() and modi&y to get parameter data directly from xlttable structure./ JRB

449 — 05-Jun-95

SQL.C: Use TO_CHAR() to handle date/time key fields with WHERE./ PG

Add code to handle special unique field (e.g. Oracle ROWID) when no existing column is unique./ JRB

448 — 02-Jun-95

SQL.C: Use concatenation in multi-part key WHERE clause. (Limit concatenation only to the key specified in GET)/ PG

Only save `.CDC' files in ODBCopen()./ JRB

Specify DESC for descending order after EVERY column./ JRB

Handle WHERE qualification with multi-part unique keys./ JRB

Add ODBCbuildkeypart() to use NVL() where necessary when building key references./ JRB

447 — 01-Jun-95

SQL.C: Ensure all ORDER BY clause builds use ODBCbuildwhere()./ JRB

Enhance ODBCextractkey() to handle multi-part keys./ PG

446 — 31-May-95

SQL.C: Add code to handle maintain nullable / not-nullable info./ PG

Add fast-load `.CDC' calls to ODBCtablesize()./ PG

445 — 26-May-95

MK2C.C: Fix total output curruption bug in PRINT USING

444 — 19-May-95

MK2C.C: Lock ISAM header around isam_r_header() call when opening C-ISAM files. Prevents potential errors later./ JRB

443 — 18-May-95

MKX0.C: Add GETTRM.SBR (body of routine in MKX2.C)./ JDM

MKX2.C: Add GETTRM.SBR./ JDM

442 — 04-May-95

MKI.C: Fix multi-user access problems causing Link Structure Smashed under Unix./ PG

441 — 25-Apr-95

MK2C.C: Handle ODBC files on RELEASE'RECORD./ JRB

SQL.C: Allocate all other od structures on Global heap./ JRB

Add ODBCrelease() to release all locks./ JRB

440 — 24-Apr-95

SQL.C: Handle multi-part keys./ JRB

Allocate od structure on Global heap in ODBCtablesize()./ PG

439 — 21-Apr-95

MKE.C: Handle record not locked error correctly in odbc_error()./ JRB

SQL.C: Implement numeric, time, and date data type translations./ PG

438 — 31-Mar-95

MK2C.C: Fix memory corruption in xab_PRINT() outputting strings longer than winbfr (255 characters+\0 max)./ JRB

437 — 24-Mar-95

MK2C.C: Amend MIAMEX functions 20 and 21 (find first file and find next file) to return file date and time info./ PG

436 — 22-Mar-95

MK2C.C: In xab_CHAIN() default to chaining a command file if extension is not `.RUN'./ JRB

435 — 20-Mar-95

MK2C.C: Change MICROSOFT_C tests to !OS_GENERIC_UNIX./ JRB

434 — 17-Mar-95

MKX1.C: Fix memory corruption if V param not specified in DSPLY./ JDM

Don't truncate output in DSPLY.SBR if XMAX too small./ JDM

433 — 23-Feb-95

MKX1.C: Add option for string (MM/DD/YY or DD/MM/YY) output to RDATE.SBR./ JDM

432 — 20-Feb-95

MKI.C: Fix problem in shunt_dir() not always detecting when last entry in directory block is being deleted./ JRB

431 — 17-Feb-95

MKI.C: Logic for splitting directory blocks in isam_add() now identical to that under AMOS./ JRB

430 — 16-Feb-95

MK1.C: Call findend() in release() to free up any directory resources still in use (e.g. aborted DIR.LIT) - This is only a problem on some Unix variants./ JRB

429 — 13-Feb-95

MK2C.C: Handle ODBC files on DELETE'RECORD statement./ JRB

Return correct status code on C-ISAM DELETE'RECORD if no record is currently locked./ JRB

428 — 07-Feb-95

MK2C.C: Adjust demo message to appear only every 5 minutes./ JDM

MKX2.C: Fix problem with edit [192]. '*' was not being appended to the operating system name in GETJTB.SBR in demo mode./ JRB

427 — 06-Feb-95

MK1.C: Clear 1st file specification in as.f array in execute()./ JRB

MK2C.C: Prevent possibility of locking yourself out when opening the same file as C-ISAM and random'forced under DOS/Windows./ JRB

426 — 03-Feb-95

MK2C.C: Fix bug in \--string\ format PRINT USING./ JDM

MK3.C: Fix day of week in DATE system function./ JDM

425 — 23-Jan-95

MK2C.C: Handle ODBC files on FIND # to same level as GET #./ JRB

424 — 19-Jan-95

SQL.C: Enhance unique / non-unique logic to perform re-SELECT when changing GET order on a non-unique key./ JRB

423 — 16-Jan-95

SQL.C: Load key unique/non-unique information from either .ODC file, or with SQLStatistics() from datasource./ JRB

Perform re-SELECT when changing GET order on unique key./ JRB

422 — 12-Jan-95

SQL.C: More accurate error reporting adding records in ODBCpu()./ JRB

421 — 10-Jan-95

SQL.C: Add ORDER BY clause to ascending fetches in ODBCget()./ JRB

Implement logging of all SQL to output file./ JRB

420 — 09-Jan-95

MK2C.C: Simplify seek() logic very slightly by setting random file blocking factor to zero if 512 divisible by record size./ JRB

MKX0.C: Perform minor optimizations and shorten xab_flock()./ JRB

Maintain cache of queue block numbers for records locked with FLOCK. Speeds up lock release process./ JRB

419 — 05-Jan-95

SQL.C: Handle fields not present in SQL table during preparation of INSERT INTO statement in ODBCprepsql./ JRB

418 — 14-Dec-94

SQL.C: Preserve case in descriptive sections of .ODC file./ JRB

Limit precision and length for very large data fields./ JRB

417 — 12-Dec-94

MKX2.C: Return key description for ODBC in CISAM.SBR function 14./ JRB

SQL.C: Add ODBCindexinfo() to return key definition of ODBC table./ JRB

416 — 07-Dec-94

MK1.C: Ensure mapbuf area does not span a segment boundary under DOS or Windows./ JRB

MK2C.C, MK3.C: lmapptr variables are now far *, not huge *./ JRB

Memory definition area NEVER crosses 64K boundary now./ JRB

415 — 05-Dec-94

MKX2.C: Extend CISAM.SBR function 14 to return ODBC index info./ JRB

SQL.C: Add ODBCkeyinfo() to return key status info of ODBC table./ JRB

414 — 28-Nov-94

MK1.C: Fix minor syntax errors when compiled under AIX./ JRB

AMSORT.C: Store record number in sequential merge files during random sort. Only way to guarantee no re-ordering./ JRB

Add some ctrlt() tests for Windows scheduling./ JRB

413 — 21-Nov-94

MK2C.C: Handle ODBC files on KILL statement./ JRB

SQL.C: Add ODBCkill() to drop ODBC table./ JRB

412 — 17-Nov-94

MK2C.C: Handle ODBC files on CREATE'RECORD statement./ JRB

MKE.C: Add ODBC_error() as ODBC equivalent to isam_error()./ JRB

SQL.C: Implement record insertion, and write translation code./ JRB

411 — 11-Nov-94

SQL.C: Add remaining data type translation code./ JRB

410 — 07-Nov-94

SQL.C: Add ODBCODC columns to return remaining column definitions from Data source driver./ JRB

409 — 04-Nov-94

MKE.C: Handle _d_iisq error for ODBC in ashell_error()./ JRB

408 — 31-Oct-94

MK2C.C: Handle ODBC files on GET'NEXT and searched GET./ JRB

SQL.C: Add code to handle ISAM Plus keys and key translation./ JRB

Add ODBCextractkey() to extract key from loaded record./ JRB

Add ODBCgetkeysize() to return C-ISAM key size./ JRB

407 — 28-Oct-94

MKE.C: Output error tracing information if TR_SYSERR set./ JRB

406 — 14-Oct-94

MK1.C: C-ISAM file information now stored in as.v.c not as.v.r./ JRB

Release resources associated with any open ODBC files./ JRB

MK2C.C: C-ISAM file information now stored in as.v.c not as.v.r./ JRB

Handle ODBC SQL files during open # for ISAM Plus./ JRB

Free ODBC resources on close # for ISAM Plus./ JRB

MKX2.C: C-ISAM file information now stored in as.v.c not as.v.r./ JRB

SQL.C: Load Column definitions in ODBCload()./ JRB

Add ODBCopen() to prepare and bind ODBC file columns./ JRB

Add ODBCclose() to release resources./ JRB

405 — 10-Oct-94

MKX2.C: Add MIAMEX function 42 (Return first ODBC table)./ JRB

Add MIAMEX function 43 (Return next ODBC table)./ JRB

Add MIAMEX function 44 (End ODBC direcoty processing)./ JRB

SQL.C: Add ODBC connection and capabilities code./ JRB

404 — 07-Oct-94

MK0.C Pass 0 job number to qpurge() routine./ JRB

MK1.C: Change program name in instance block to lower case when returning to command prompt./ JRB

MK3.C: Enhance qpurge() to purge any job's queue blocks./ JRB

Mark deleted queue blocks as type Q_FREE./ JRB

MKX2.C: Add MIAMEX function 41 (Zap job quue blocks)./ JRB

403 — 06-Oct-94

MKX2.C: SETJTB.SBR now changes current drive./ JRB

402 — 05-Oct-94

MKX2.C: Return return code 0 after re-use of Q_IFLOCK block./ JRB

Assign correct owner to reused Q_IFLOCK block./ JRB

401 — 03-Oct-94

MKX0.C: rec moved before chan in flk structure(Boundary problems with QUTL.LIT under AIX)./ JRB

400 — 30-Sep-94

MK0.C: Initialize and clear down ODBC environment./ JRB

MK2C.C: Report correct PPNs for random file not found./ JRB

Implement ODBC interface in LOOKUP for .IDA/.IDX./ JRB

399 — 26-Sep-94

MKX0.C: Add IDTIM.SBR./ JDM

AMSORT.C: Prevent re-ordering during chunk_sort by preventing output split of identical-key records./ JRB

398 — 20-Sep-94

MK3.C: qadd() and qdel() re-coded to be `failsafe'. (corruption of used / free queues impossible even if process dies during qadd() or qdel())./ JRB

397 — 19-Sep-94

MKX0.C: For speed, mark deleted FLOCK record lock queue blocks as type Q_IFLOCK for quick reclamation./ JRB

396 — 08-Sep-94

AMSORT.C: Fix ?Insufficient memory error from edit [118]./ JRB

395 — 07-Sep-94

Remove bubble sort option. Quicksort algorithm enhanced to use logical record number as last key, therefore it does not re-order identical keys unnecessarily. (Still potential problem during chunk_sort) / JRB

394 — 05-Sep-94

MKX0.C: Allocate (variable) message memory for COMMON.SBR from A-Shell memory partition./ JRB

393 — 05-Sep-94

MK0.C: Initialize as.memcom for COMMON.SBR area./ JRB

MK2C.C: Disable compiler optimization around xab_LET(). (Causes compiler error under M/S C8.00c/c++ 1.5)./ JRB

Use as.memcom to indicate end of usable memory./ JRB

MK3.C: Use as.memcom to indicate end of usable memory./ JRB

392 — 02-Sep-94

MK2C.C: Support negative start position in LET String[S,E] substring assignments./ JRB

MK3.C: Fix problem with [S,E] substrings when S negative./ JRB

391 — 22-Aug-94

MKX2.C: Lookup SYS:??????.INI in PRTCHK.SBR to check existence./ JRB

390 — 15-Aug-94

MK2C.C: Fix more DOS segment boundary problems in xab_PRINT()./ JRB

SQL.C: Add ODBCppn() to return Data source for a given PPN./ JRB

389 — 12-Aug-94

MKX2.C: Add MIAMEX function 40 (Return if ODBC available)./ JRB

388 — 09-Aug-94

MK0.C Wait for key to be pressed after setup error./ JRB

MK3.C: Use memcpy() in implementation of RIGHT() to handle nulls./ JRB

MKX0.C: Only return RTNCDE from FLOCK.SBR if specified./ JRB

387 — 05-Aug-94

SQL.C: Begin writing as an API between ISAM Plus & ODBC. (Currently for A-Shell/Windows only)./ JRB

DMSQL.C: Write it as ODBC equivalent of DMISAM. (Primarily for A-Shell/DOS & A-Shell/Unix)./ JRB

386 — 29-Jul-94

MK3.C: Disable compiler optimization around bitwise_40bit(). (Causes compiler error under M/S C8.00c/c++ 1.5)./ JRB

385 — 27-Jul-94

MK2C.C: Fix problem with 5-byte binaries in xab_LET()./ JDM

384 — 22-Jul-94

AMSORT.C: Fix another boundary problems (DOS/WIN16) when sorting large sequential files - fprintf is not HUGE./ JRB

383 — 18-Jul-94

MK0.C: Set assumed node count to one if in demonstration mode./ JRB

Check for infinite loop in QFLOCK during clear_instance()./ JRB

MK3.C: Check for infinite loop in QFLOCK during qpurge()./ JRB

MKX0.C: In FLOCK action 2, call qlock BEFORE qread of header./ JRB

382 — 15-Jul-94

MK2C.C: Lock ISAM header around r_isam_header during OPEN./ JRB

MK3.C: Change instr() to match over null characters./ JRB

MKX0.C: Insert missing host2word() call in XLOCK mode 0./ JRB

381 — 11-Jul-94

MKX2.C: Only return host spec in MIAMEX function 3 if _fs_toh. (Prevents need to specifiy host spec parameter)./ JRB

Convert rad50 word to host format in x_pack()./ JRB

Do not match password file (AS_PS) in wildmatch./ JRB

Add MIAMEX function 39 (Delete directory)./ JRB

380 — 08-Jul-94

MKX2.C: Add MIAMEX function 38 (Create directory)./ JRB

379 — 06-Jul-94

MK0.C: Do not assume getecho() returns 0/1 (only zero/non-zero)./ JRB

MKX2.C: Append `*' onto OS name in GETJTB.SBR in demo mode./ JRB

378 — 01-Jul-94

MKX0.C: Add call to x_eztyp()./ JDM

MKX2.C: Add MicroSabio EZTYP.SBR front-end to ezspl()./ JDM

377 — 22-Jun-94

MK2C.C: Improve error reporting on file open (input) if no [,0]./ JRB

On random file open, ensure file is closed if error occurs after call to ropen() (e.g. during lock test)./ JRB

376 — 16-Jun-94

MK2C.C: Only cast to (ulong) in xab_LET() if 4-byte +ve binary./ JRB

375 — 13-Jun-94

MKX2.C: Add MIAMEX function 36 (Return AMOS-hash mode)./ JRB

Add MIAMEX function 37 (Set/reset AMOS-hash mode)./ JRB

374 — 10-Jun-94

MK2C.C: Fix GPFs and segmentation faults when files not open for random or ISAM/ISAM Plus operations./ JRB

373 — 06-Jun-94

MK3.C: Use getecho() in place of m0 test./ JRB

MKX2.C: Use get??() routines in place of direct m0 test./ JRB

372 — 01-Jun-94

MK0.C: End console redirect mode on ^C./ JRB

MK2C.C: Change (long) cast in xab_LET() for binaries to (ulong)./ JRB

371 — 20-May-94

MKX2.C: Add MIAMEX function 35 (Set console redirection mode); (Currently set page mode only)./ JRB

370 — 13-May-94

MKX2.C: Automatically add `-n' switch to xcall HOSTEX,"ashell.."./ JRB

369 — 06-May-94

MK0.C: Request new license if using NETUNIQUE / NETSINGLE console device formats./ JRB

Use static string (env_var) for putenv() of MIAMEFILE. (MS C 8.0 only stores pointer in environment table) / JRB

368 — 03-May-94

MKX0.C: Do not echo unprintable characters in ACCEPT.SBR./ JDM