🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.delphi.database
Article #2105

Re: Access Violation using MSACCESS

#2105
From: Martin Ziemer
Date: Sun, 16 Aug 1998 00:00
16 lines
1316 bytes
Alan Buckle wrote:

> However after processing in excess of 18,000 records (18408 to be exact,
> not counting 'child' records ) I get
> Access Violation at Address 4E5FA1F6 in module 'IDDAO32.DLL'.
> I'm tearing my few remaining hairs out at this stage. Does anyone have any
> ideas ??

May be. Do You use SQL-constructs like "insert into ... values
('+MyString+...')'"? I got such an exception if there was a ":"
somewhere in MyString! I think the reason is that MSACCESS tries a
parameter substitution. It's generally more reliable if you use
TQuery.Params[] for such purposes.

Bye,
  Martin
Technical Details
Message-ID: <35D6DC76.7741@ferrocontrol.de>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <01bdc84f$8c9e0620$01000a0a@pentium1>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,276f600a65905796
X-Google-Attributes: gidffff5,public
X-Google-Thread: 115d96,276f600a65905796
X-Google-Attributes: gid115d96,public
From: Martin Ziemer <MZiemer@ferrocontrol.de>
Subject: Re: Access Violation using MSACCESS
Date: 1998/08/16
Message-ID: <35D6DC76.7741@ferrocontrol.de>
X-Deja-AN: 381649475
Content-Transfer-Encoding: 7bit
References: <01bdc84f$8c9e0620$01000a0a@pentium1>
To: Alan Buckle <buckle@euronet.nl>
Content-Type: text/plain; charset=us-ascii
Organization: ferrocontrol
Mime-Version: 1.0
Reply-To: MZiemer@ferrocontrol.de
Newsgroups: borland.public.delphi.database,comp.lang.pascal.delphi.databases