Hi again,
Ok, I've created a simple test case which reproduces the error...
Using...
Windows XP pro
Remobjects 6.0.43.801
AnyDac (latest version I beleive)
Delphi 2007
Firebird database
(I'll also post my small test case to the Binaries group)
procedure TClientDataModule.DataModuleCreate(Sender: TObject);
begin
// this line works with both MSXML and OpenXML...
// tbl_users.Where.AddCondition('usr_username', cEqual, 'ADMIN');
// dynamic where doesn't work when compiled with RemObjects_OpenXML ...
with tbl_users.DynamicWhere do
begin
Clear;
Expression :=
NewBinaryExpression(
NewField('USERS', 'USR_USERNAME'),
NewConstant('ADMIN', datString),
dboEqual);
end;
tbl_USERS.Open;
ShowMessage(inttostr(tbl_users.RecordCount));
tbl_USERS.Close;
end;
When using OpenXML, the error message is displayed: "An exception was
raised on the server: DOMElement is nil"
Hopefully you'll be able to reproduce this problem at your end.
Kind regards,
Graham
> Hi again,
>
> After further investigation it looks like it's something to do with the
> way I'm using the DynamicWhere...
> I've changed this to use the standard "Where" property (client-side) and
> everything works ok...
>
> If I find out what's causing it (most likely in my code!) I'll post it
> back here.
>
> Kind regards,
> Graham
>
> "Graham" <✉nospam.com> wrote in message
> news:hkmdh8$720$✉news.remobjects.com...
>> Hi there,
>>
>> A small number of our customers have been reporting the following error
>> message to us when they try to run our application...
>>
>> "Error creating MSXML Document class EOleSysError: The specified
>> module could not be found, ClassID: {<guid>}"
>>
>> I'm assuming this has something to do with the wrong MSXML libraries
>> installed so I decided to try and compile our app with the
>> "RemObjects_OpenXML" conditional define.
>>
>> This looked to work ok until the application tries to open a client-side
>> data table, then we receive the following error...
>>
>> "An exception was raised on the server, DOMElement is nil".
>>
>> If the OpenXML implementation is compiled into the application, then I'd
>> prefer to do things this way as I'm not then relying on any MSXML
>> libraries.
>>
>> Has anyone else experienced this? Any workarounds? I noticed in the RO
>> Change Log, this bug is mentioned...
>>
>> 4742: FPC. OPENXML raises an error 'DOMElement is NIL'
>>
>> Thanks for any help or information you can give regarding this.
>>
>> Kind regards,
>> Graham
>>
>
>