Icetips News, Downloads and Blog Posts

I recently had a situation where a program had a file or a folder locked and I had no idea what program that might be! I needed to restore a folder from a Macrium backup but I didn't want to...

We will be out of the office for the next couple of weeks or so.  We are helping our daughter move.   We will be driving a lot and may not have a good internet connection most of the time, so...

We are moving and our office will be closed this coming week until at least October 24th.

We are going to be on vacation from today, September 10th to Wednesday, September 21st.  We are attending 50 year anniversary of friends of ours in Dublin, Ireland and are going to spend some...

Window Fixer Demo program. Created with Clarion 11.0 and WindowFixer 2021.06.157. Copy of the people.app with WindowFixer applied. Note that this is NOT an installer, but a compiled and code signed exe with the help and PDF documentation.

CWODBC

! Copyright 2002 by Dan Pressnell (dan_pressnell@yahoo.com)

!====================================
! cwODBC version 1.9
!====================================

! Changed in version 1.9
!   ---  Added sqlBuilder interface (see note at interface declaration)
!   ---  Fixed bug in GetColumnValue(columnsreturned+1) when using file structure with no fields.
! Changed in version 1.8
!   ---  Added SendQuerySilent method to send query with silent error handling
! Changed in version 1.7
!   ---  Added FillQueueWithResultByName method
!   ---  Queries that fill a queue (and the FillQueue... methods) now leave queue record 1 as the current entry when finished
! Changed in version 1.6
!   ---  Added method to get the database server name (different than prop:dbmsver)
! changed in version 1.5
!   ---  Added the method CreateAccessDatabase() so you can create a new blank Microsoft Access Database
!        file at runtime (subject to change!)
! changed in version 1.3
!   ---  Added SqlQuote and SqlLike as stand-alone procedures
! changed in version 1.2
!   ---  return values added for some procedures
!   ---  new methods added (see interface declaration)
! changed in version 1.1
!   ---  Attempt to fix situation where column count is 0 after first query


! This is freeware.  You are free to make any changes, but if you distribute this package, please distribute
! the original package as supplied by me.  If you think you have some good changes or additions, suggest
! them to me.

!  To use this package:
!
!     (1) put cwodbc.inc and cwodbc.clw in clarion's LIBSRC folder
!     (2) put odbc32.lib and Odbccp32.lib in clarion's LIB folder
!     (3) compile cwsql.prj
!     (4) put the compiled cwsql.dll in clarion's BIN folder, and cwsql.lib in clarion's LIB folder
!     (5) in your apps or projects, put this:
!           in global embeds before includes...
!                   INCLUDE('cwodbc.inc'), once
!           in the project settings, add the library file cwsql.lib

! See the sample code in the Sample1.prj project and source files

! No support is guaranteed, and there will be no templates for this package.  If you have comments or suggestions,
! I prefer that you use the newsgroups devoted to Clarion for Windows, so everybody can benefit, and I won't
! be swamped with private email.

! Be aware that with the release of Clarion 5.6, with ADO, much of this might become outdated technology, although
! I don't think so, because this package is very lean and fast, and I doubt ADO will improve on that.

There was some discussion on comp.lang.clarion last week about performance of REMOVE in terms of removing the page metafiles when a report closes.  The previewer uses the same method for removing...

Build 2021.09.411 Compatible with Clarion 4 - Clarion 11.1 Update to remove metafiles after use. See Version history documentation for more information.