Problem with string parameters

Problem with string parameters

Postby neoneksus » Tue 06 Jan 2009 09:06

Hi,
I am trying to modify win32 application to work on Oracle server with minimum code replacement. Aplication was designed for MySql in Delphi 2005.
I am using your dbx drivers for both connections to Database (dbxmysql and dbxpoda).
The problem with dbxpoda driver is that whenever i give the string parameter to query, open returns Error.

Example of the query:
qsql:=TSQLQuery.Create(application);
qsql.SQLConnection:= dbxpoda_connection;
qsql.sql.Add('SELECT * FROM INK_2008_PAYERS where OM=:OM');
qsql.Params.ParamByName('OM').AsString:='000000028';
try
qsql.Open;
except
on e:exception do MessageBox(0, pchar(e.Message), 'Error!', MB_ICONWARNING or MB_OK);
end;

The error is:
---------------------------
Debugger Fault Notification
---------------------------
Project C:\test\inkasso_oracle\inkasso.exe faulted with message: 'access violation at 0x028ec63d: write of address 0x00030f50'. Process Stopped. Use Step or Run to continue.
---------------------------

I would appreciate if you could help me.
neoneksus
 
Posts: 1
Joined: Tue 06 Jan 2009 07:45

Postby Plash » Fri 09 Jan 2009 09:18

We could not reproduce the problem. Please send to dbxoda*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.

Also specify the exact version of your DbxOda.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09


Return to dbExpress driver for Oracle