Devart Forums

Hi i have the same error when using TPgsSql with simple params like

InsertExternal='insert into fexternals '+
'(labowner,ip,server,analyserid,analysername,isactive,maxracks,startrack,maxrackpos,barcode,path,alerter,labname,tguid)'+
'values (:a,:b,:c,:d,:e,:f,:h,:g,:k,:l,:s,:x,:labname,:tguid)';

AddExternal.sql.text:=InsertExternal;

AddExternal.Params[0].value:=QComports.FieldByName('labowner').value;
AddExternal.Params[1].value:=common.Hostaddress;
AddExternal.Params[2].value:=common.Hostname;
AddExternal.Params[3].value:=QComports.FieldByName('analyserid').value;
AddExternal.Params[4].value:=QComports.FieldByName('analysername').value;
AddExternal.Params[5].value:=QComports.FieldByName('autoopen').value;
AddExternal.Params[6].value:=QComports.FieldByName('maxracks').value;
AddExternal.Params[7].value:=QComports.FieldByName('rackstartnumber').value;
AddExternal.Params[8].value:=QComports.FieldByName('maxrackpositions').value;
AddExternal.Params[9].value:= QComports.FieldByName('barcodepriority').value;
AddExternal.Params[10].value:= '\\'+common.Hostname+'\Data' ;
AddExternal.Params[11].value:=QComports.FieldByName('uploaddata').value;
AddExternal.Params[12].value:= QComports.FieldByName('labname').value;
AddExternal.Params[13].value:=QComports.FieldByName('tguid').value;
try
if not AddExternal.Prepared
then
AddExternal.prepare;

AddExternal.Execute;
except
On E:EXception do
Begin
if E is EdAerror then
errorlb.Caption:='Database error '+E.Message
else
errorlb.Caption:='General error '+E.Message
End;
end;// except

raises exception "there is no parameter $1"
if i replace AddExternal with a TPGQuery with same params values there is no problem
i am using DELPHI XE10.4.2 Sydney, PGdac version 6.4.3 on Windows 10
this was not happen with prior versions like 6.3.1 Delphi XE10.3.3 on Windows 10

Unit PgAccess was compiled with different version of CLRClasses.Marshal

I have the same error by my database is running on 64bit windows Postgresql version 11
if options sequences is disabled then entire schema seems to finalize work, also the on error event is not working...
i have not test the restore option yet

with this command my backup is working
@echo off
for /f "tokens=1-4 delims=/ " %%i in ("%date%") do (
set dow=%%i
set month=%%j
set day=%%k
set year=%%l
)
set datestr=%month%_%day%_%year%
echo datestr is %datestr%

set BACKUP_FILE=D:\Lis.backup_%datestr%.backup
echo backup file name is %BACKUP_FILE%
SET PGPASSWORD=*****
echo on
bin\pg_dump -h localhost -p 5432 -U postgres -F c -b -v -f %BACKUP_FILE% postgres

I have install all last Versions of SQLite Data Access Components Professional version 3.4.9 and Unidac express edition version 7.4.11 for Delphi RIO 10.3 and get and error message
[dcc32 Fatal Error] Mdata.pas(9): F2051 Unit SQLiteUniProvider was compiled with a different version of LiteConnectionString.TLiteConnectionStringBuilder

Any Idea to help me

Hi to everyone
I wonder why no corresponding interesting for a DBA tool for Interbase-Firebird like others (Dbforge versions)

Thanks
Vagelis Bekyros

Hi i have remark the same problem only if you refresh the dataset your generator wheel appear

Hi Alexp
OdacTools for our company was the Total solution for Oracle connectivity
i have wrote Testimonials with name Evangelos Bekyros

Thanks again for this great products

Vagelis Bekyros

Thanks for your post (I wrote a few server procedures to pass my problem)

Imaging what wheel be happen with 500 client users...

I am working with a simple table with a datatype BFILE as like the sample in OdacDemo (Bfile)
when a try to open the table a get an error "OCI function is not linked"
I use direct link Odac version 9.4.14 for Delphi7 (no client tools for Oracle)
Thanks Vagelis Bekyros

Hi
The same problem is during Bakcup inside the application ???
I compile the same code with previous mysql version and was working fine

Hi
Fisrt sql generator dont srcipt Sql updates, ?????????? is the result
Second in previous version Longblob field in my Pictures was working NOW i lost connection from MySql server , i test the same code with simple a test.db table and one blob field with the same jpeg Image 1.4Kb was saving correctly
I cannot go back to previous version because i use ODAC and SDAC versions
Thanks Vagelis

Thanks for the reply perhaps you have right because i use D7 lite Version ???

Strange situation ????
I am testing D5,D7 D2010 with Odac 6.90.0.53 with direct connection
(options.direct:=true)
With D5 and D2010 is working fine
with D7 i am getting Ora-12571 error on same PC with Windows7

Lisdatabase.connectstring:=privdamos/23241@damos:1521:damoslis