On 2/19/2016 10:37 PM, Michael Riley wrote:
> Forgot to mention it only happens to me when the EDBTable is connected to View2.

Michael,

Just tried it here at it runs fine in all configs - 32 and 64 and both
debug and release.

No AV and i see data - 6 rows of it (Sample 1 to Plan One 2016).

I created the 2 tables and view as per your previous email. Tim's sample
project i used did already refer the "View2" (EDBTable1 TableName
property).

Running Dlphi 10 Seattle with Subscription Update 1 (and the ModernTheme
Hotfix applied) as well as EDB 2.21 Build 1.

If there is anything else i could try let me know.

Has this PC had EDB components before (i.e. versions prior to 2.21?).
if yes then my only suggestion would be to uninstall and reinstall the
64bit EDB components (since they are separate from 32bit and only
consist of runtime components - IDE always uses 32bit design time
components since it's a 32bit app).

Raul

Michael


I don't know if its the same in the newer version of Delphi but can you add in debug dcus? One thing I have seen many times is that an AV can be caused by something at a different point to which its reported at. Usually using the debug dcus has identified the real culprit.

Raul mentioned MadExcept - its at http://madshi.net/index.htm There's a free version for non-commercial use (you can use it whilst developing but can't send out with compiled code). Its very easy to use and very good at spotting most things. Even if you can't interpret it you can post the output here and someone will be able to.

The other thing to try is setting breakpoints prior to where the AV seems to be occurring and see if the code runs past those.


Roy Lambert

Michael,

<< I am at a loss as to why ElevateDB throws an AV in 64-bit but Microsoft SQL Server Express does not. >>

I'm not sure where you're going with this, but the obvious reason is that they're completely different products.  Why would you think one has anything to do with the other ?

If you're using the .dcus that we ship, then they are created using the *initial* Delphi 10S 64-bit  compiler.  I haven't put the Delphi 10S Update 1 into our build system yet, so that's the issue you're seeing with the execution.

I've set you up with a temporary EDB-VCL-STD-SRC license, so you can just compiled against the source code in the meantime until the next EDB release is available. Uninstall the existing 2.21 and then install the EDB-VCL-STD-SRC version of 2.21.  Then, in your project's search paths (Project/Options), add a reference to the EDB source code (<InstallDir>\code\source), close the project options dialog, and then rebuild.  You should see the compiler building all of the EDB units as your project is compiled.

Tim Young
Elevate Software
www.elevatesoft.com

<<<
<< I am at a loss as to why ElevateDB throws an AV in 64-bit but Microsoft SQL Server Express does not. >>

I'm not sure where you're going with this, but the obvious reason is that they're completely different products.  Why would you think one has anything to do with the other ?
>>>

Because I thought it had something to do with the data structure itself. So, in my mind I was testing the same data structure against D10S Update 1, and my operating system. I was trying to understand why the base tables worked. Why the views without aggregates worked. Why the views with aggregates failed. Was it my operating system? Did I have a corrupt install of D10S Update 1?

<<
If you're using the .dcus that we ship, then they are created using the *initial* Delphi 10S 64-bit  compiler.  I haven't put the Delphi 10S Update 1 into our build system yet, so that's the issue you're seeing with the execution.
>>

I'd like to thank you for that explanation. It makes perfect sense now. That's all I needed to know.

<<
I've set you up with a temporary EDB-VCL-STD-SRC license, so you can just compiled against the source code in the meantime until the next EDB release is available.
>>

I appreciate that Tim, but it won't be necessary. I can wait for the next release.

Raul,

Thank you for testing things on your end as well. I "obviously" don't have the EDB source files and that is why I was getting different results than both you and Tim. Small little detail that I forgot to mention. Sorry.

Michael Riley
GySgt USMC (Ret)
www.zilchworks.com