Recent content by Dean

Thank-you Thank-you Thank-you. Now if only we could get all provider supported datasets to offer this property (without having to override and code it ourselves).

I'm not positive (I have D6 Enterprise) but I think that in D6 the TClientDataSet is now in the Professional edition as well.

Found the problem, it's a really obscure one. Turns out when you put the database on an IBM-0S390 Mainframe it uses the EDCDIC character set. When the client uses ASCII, it causes all of the rowid's to get jumbled up, which in turn causes the ORA-01410 error when you try to use the ROWID that...

I figured as much, but I thought I'd let you know. Keep up the excellent work, as always.

A bit of a followup. We managed to get the exact same client - server configuration on our lab, and naturally there is no problem. So it looks like it's either some kind of configuration issue or maybe related to their platform (I forgot to find that out). Anyone know if there are any kinds...

I've had to split the package into 2 (one for design time which references the other runtime package) to get rid of the dependencies. Borland's made a bunch of changes to the OpenTools api which make it difficult to have the same design and runtime packages (if not impossible). I suspect that...

Hi there, A client is running into a problem when updating records in their database. They're getting a ORA-01410, which is an Invalid Row ID. This is the first time I've seen this, and it doesn't occur on any test machines. They're running 8.1.5 client against an 8.1.7 database. I've run...

Has anyone used D6 with Runtime packages and DOA? It seems that there are some dependencies with the doa34d6.bpl and a few borland bpl's that I think we're not allowed to distribute (dcldb.bpl, designide.bpl). I glanced through the help but couldn't find any information on this. Anyone have...

The Oracle monitor is a separate installation (I think) so I believe you'll get that error until you've installed it. If I was you I'd put a code snippit with both the above lines of code right next to each other and run it. That'll at least tell you if the Savepoint function is working...

If any commits have occurred (at all) then you won't be able to rollback to this savepoint. Throw the Oracle monitor on this particular code if you have it and you'll be able to see if a commit is occurring.

Seems to be related to when I have the Oracle monitor on. Times out with about 5-8 minutes of inactivity. [This message has been edited by Dean (edited 16 October 2000).]

Hi, I'm using Oracle 8.05 with DOA and occasionally if I leave my program idle for quite some time I get an end-of-file error. I asked my DBA if there's some kind of timeout on the server or client and he said no. Has anyone else seen this, and is there a way to deal with it?

You'd think I'd have learned by now to post stuff that I wasn't absolutely certain about.... Thanks for straightening that out for me.

Well, an example would be something like this... procedure SaveToDatabase; begin Server.StartTransaction; try //Each of these functions uses a different //TClientDataset... InsertIntoMainTable; InsertIntoCrossReferenceTable1; InsertIntoCrossReferenceTable2; //Now Apply...

Thanks Marco. I agree with the Boolean idea because there are some occasions where I'm iterating over a query and performance would benefit, and others where I'm just loading data once and want the cursor to go away when I'm done.