Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 5th, 2004, 04:38 AM
Authorized User
 
Join Date: Sep 2003
Posts: 83
Thanks: 0
Thanked 0 Times in 0 Posts
Default comparing CLOB fields

Hi everyone,

I am using Access to compare records between a SQL Server database instance and Oracle. I have the tables linked and most of the comparisons work fine. I am using joins on the table and comparing each column.

However, I have columns that have Memo fields and Access does not let me compare these fields. Also, it does not do any comparisons between the date fields.

Is there a way to compare these MEMO and date fields using some VB script. I have not used VB scripts much and would appreciate some help.

Thanks,
Pankaj







Similar Threads
Thread Thread Starter Forum Replies Last Post
Asp/Oracle-Clob Thiago Classic ASP Databases 2 January 26th, 2009 09:03 AM
Retrieving clob oracle with php roxusername PHP Databases 0 October 30th, 2006 02:02 PM
comparing date/time fields on form validation Lucy Javascript How-To 1 June 20th, 2006 09:22 AM
Trouble with comparing date fields JimmyNeutron Access VBA 3 February 22nd, 2005 09:14 AM
ASP UPDATE CLOB mamasagarika Classic ASP Databases 0 December 2nd, 2004 07:14 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.