Zeoslib Portal

Dear Mark, I must really say my best thank you for that kind of approach from you. I really appreciate your point of view. Your advice has just arrived at the very best time even possible !!! Two days before I started that procedure, cannot tell it momently, how long it will last. If you're interest...

Hello, I continuously receive various types of Exceptions all coming from TZDBLibMSSQL7PlainDriver.CheckError; mostly not derived down to any specific class, probably from the last line, but not always. I'm afraid the primary reason is the TODO comment at the beginning of the method. Can I expect th...

The following addition to MyZQuery solved the original problem. TMyZQuery = class(TZQuery) private procedure BeforeOpenHandler(DataSet: TDataSet); public constructor Create(AOwner: TComponent); override; procedure ExecSQL; override; procedure Open; // <- ADDED SOLUTION end; procedure TMyZQuery.Open;...

If you send me your program source My program is the intellectual property of my company. I'd need their permission to do that in a whole. But it's only an excuse, the real reason I'm not doing so is this wouldn't be workmanlike anyway, it would show me as being vocationally incompetent. Yesterday ...

Wild_Pointer wrote:is procedure TGPRSConn.FTPLoadCommands; executed from other than main thread ?

No.

Do you want to see the threads full code (~5 pages in 1280x1024) ?
All 4 threads have same code, same class, but 4 instances created with different parameters.
There's no FTPLoadCommands; call in that code.

It is very hard to find what is wrong when the program crashes once a week. Right. :x I have 20 different error log files, I created inspection points in code and write them out. See the last FileLog() call in the next code. try //Query:=ZQuery.Create(MainModule); //with ZQuery.Create(MainModule) d...

Hi, I'm on localhost. I'm sure you will succeed. Just see one more time if no connection object is used from 2 threads. No, I have separate 'dynamic' ZConnection objects created and connected in each thread before entering the main loops (I have 4 threads btw), all has only 1 instance of ZQuery usin...

Hi Wild_Pointer, So you say that Zeos 6.x.x is completely incompatible with multithreading, but 7.x is ? You say this function is implemented in versions 7.x above ? Am I understanding it right ? Well, I have decided to DO multithreading in my app, even if I found it's not possible with Zeos anyway....

Hello Zeos Folks, I want to know the community's general opinion about ZeosDBO (6.6.6 stable) and multiple threads. I have several threads each with its own ZConnection and ZQuery created dynamically, and have static ZConnection and ZQuery components put on the main form also. After several hours of...

Hi All !

SAME HERE !

SELECT * FROM MyUDFName(1); causes EZSQLException 'row data is not available' in a TZQuery.

Can I use the above solution for UDFs that return resultsets ?

Thanks, Peter

Really ?

Could you please tell me the basic steps that's needed ?

Thanks, Peter

SQL server compact has a file ext of .sdf.
Is Zeos able to read&write this format ?
A simple but serious yes or no would be enough.

Thanks.

Conversion ? Sorry, but I must contradict that. I give the SQL statement as a string. SQL server accepts the statement as a string. There's no need for Zeos to convert anything. Zeos is not in the position to be able to convert. What you probably point occurs inside the database server, but that pla...

[font=Courier New] TMyZQuery = class(TZQuery) private procedure BeforeOpenHandler(DataSet: TDataSet); public constructor Create(AOwner: TComponent); override; procedure ExecSQL; override; end; procedure TMyZQuery.ExecSQL; begin if Assigned(BeforeOpen) then BeforeOpen(Self); inherited ExecSQL; end;[...

I'm afraid it was a bad idea to give more details and partially answer my own question.