Zeoslib Portal

I have found the reason why this is happening. When the result set is grabbed from the C connector DLL, at some point procedure TZAbstractRODataset.InternalInitFieldDefs; is called. in that method, there is this line: FieldType := ConvertDbcToDatasetType(GetColumnType(I)); When I call the SP, the co...

Hi all, I'm currenlty using 7.2a because I'm working with XE5 and I'm running into some strange issues. In short, I have a single table with an unsigned bigint field (ID), with two records: 2041403756142144128 2041403818419171840 I have one stored procedure which does nothing but: select ID from tab...

seawolf wrote:I think it's the right behaviour .. I mean How to know which tables are involved and their relationship?
mode

I was starting to expect exactly this and was hoping somebody here can acknowledge it, since I'd except to find more posts in the form about this.

It doesn't seem like database (mysql) specific problem so maybe I can help. What components are you using to achieve this? Can you post a little sample? Hi trupka, thanks for your reply. The setup is very simple, I have a global TZConnection: fZConnection := TZConnection.Create(Self); fZConnection....

With the risk of asking something very stupid :p

I'm trying to modify or add a record to a dataset returned by a stored procedure. I don't any errors, but the changes are just not stored in the database.

Can anyone tell me what I'm doing wrong?

Hi mdaems, thanks for your reply.

I'll make the changes and drop them here (in the patches sub forum), not sure when yet, a little busy with other stuff atm.

If that is the only reason and there is no additional functionality there which is used, I'd like to opt to remove it completely. If you don't catch the exception it's shown automatically, and if you do catch it you do it to avoid it's being shown. This construction is really quite confusing imho. A...

Hi seawolf, thanks for your reply.

That's very much like what I had in mind, but I'm a little reluctant since I can't see the point of the way things are currently done, I was hoping to get some insight in that before making any changes.

In ZIBEventAlerter.pas, there is a routing called HandleException(). It's called in the Execute() method as well as in the destructor. HandleException() will indirectly show all exceptions using SysUtils.ShowException (via DoHandleException). All in all it results in the following problem for me: tr...

I've hooked up wireshark, and found the following: The 'ping request' I send is 24 bytes long, which makes 78 bytes when you add all tcp overhead. The server response is 40 bytes longs, which makes 94 bytes including all tcp overhead. This is followed by a TCP ACK, although I think you shouldn't add...

From what I understand from the documentation, the actual command and the answer is just a couple of bytes. I don't know what the protocol overhead is though. I'll try to check it with a sniffer lateron, though I'm not sure if I can see what's what.

I'm doing some test with detecting connection problems while being connected to a FireBird database. I noticed the following in ZConnection.pas, which might be an issue: procedure TZConnection.Disconnect; begin if FConnection <> nil then begin DoBeforeDisconnect; ShowSqlHourGlass; try CloseAllDataSe...

I've implemented something which seems to come as close to a ping implementation for FireBird as possible. I'm not very into this, so I hope I didn't make any stupid mistakes :P Added to ZDbcInterbase6.pas: {** Checks if a connection is still alive by doing a call to isc_database_info It does not ma...