Zeoslib Portal

Hi ALL, I am using zeos8 (git pull from this date) + lazarus 3.2. So, When I create memtable (Lista_Atual) with calc field, I can´t do memtable.[append/edit/...] because will trigger access viollation, if I remark as comment field qtde_solicitada_com (calculated field) no error will be displayed. tr...

Thanks for helping.

Windows is a mess, cp450 on terminal, win1252(ansi) on UI and need to be careful with editors, Delphi save our code (and strings) as Ansi, Lazarus save as unicode, so... Windows is not for amateurs.

Hi, Jan. No, I dont dev console application, not yet. Initially was cCP_UTF8, but when I found problems with Query.sql.text, I try a lot of combinations, and so... at final point I found this conbination: ClientCodePage=WIN1252 ControlsCodePage=cGET_ACP. RawCharacterTranslitarateOptions.encoding:=en...

Reply my self,

Change
RawCharacterTranslitarateOptions.encoding:=encDefaultSystemCodePage;
SQL:=true;

Now, it´s works!

ZConnection has ClientCodePage=WIN1252 and ControlsCodePage=cGET_ACP. Database FirebirdSQL v5. Zeos 8.0.0-beta. Lazarus 3.2. No error with accents in insert or update operations, data inside database are fine, but when I try do get using query as: select a.* from almox a where (exists( select * from...

firedac can use both parameters and macros, they are very similar. But, macros can be used anywhere, including replacing verbs and keywords. It would be a great idea to have something similar on Zeos. Parameters on the other hand can only be used in values. FirebirdSQL will compile and cache them fo...

Good that already exists implamentation, just waitting for code.
I will wait for a good soul, still there, I will handle with carefull prepared queries.

aehimself wrote: ↑09.01.2024, 20:50

Code: Select all

procedure TZAbstractRODataset.Prepare;
begin
  Prepared := True;
end;

Prepare queries need to submit sql code to a server previously and returning true of false from server to proceed. Some times, we do manually: if not query1.prepared then query1.prepare; Because another instante in same workstation or different point of network already prepared. Since BDE, IBX, IBO,...

Hi ALL, I´am using Zeos8 from git repo with Lazarus 3. Since starting using zeos8, I dont know why, but when I prepare my querys, if statement is wrong (sintax, field, whatever) never trigger an exception, prepare always is fine, exception will appear only when execute it. Is there any option to tur...

Hi All, I´am trying to use zMemtable as Delphi Client Dataset, but it´s my first time with Zeos 8 Memtable, how Can I Create a dataset in runtime memory, create index and find key fields? I create this sample, but something is wrong, can you help me? Follow: // sample zMemTable1.FilterOptions:=[foCa...

Yes, all of them refuse to connect using Win10, maybe is different using old windows versions. Just BDE may something different using Win10, because connect without any error. I think because BDE uses dblib correctly and others no way to use it, maybe prefer ctlib or newer and in win10 there is a hi...

Yes, I need to found this versions:
MSSQL 6.5->7.0->2000->2005->2008R2

not peace of cake found them, but I will try.

This version MSSQL Enterprise Manager does not generate SQL Script for data, only meta. But there is a transfer data utility to another MSSQL. I will try if MSSQL 2019 can import it from this transfer or from backup/restore.

Well, not good. I try ct.dll and sybdb.dll with zeos8 and result is: System Error, (OS Code 193 I see another files like to bsqlodbc.exe, maybe to create another ways via ODBC, but I not understand how to execute them. :( Maybe if I have this DLLs more than 10 years ago, but I´am not lucky. I keep s...

What is FreeDTS? It´s free to use? How to install in Windows enviroment? There is no FreeDTS in protocol of zconnection (zeos8). Hmm - I see several possibilities: Continue to use the BDE for migrating the data. Read the data using the BDE and write it to Firebird using Zeos. Use Zeos 7.2 for connec...