Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread Selecting New Records In ElevateDB
Mon, Jul 2 2007 5:24 AMPermanent Link

Chris Holland

SEC Solutions Ltd.

Avatar

Team Elevate Team Elevate

I imported an existing table "Site" from DBISAM 4 in ElevateDB 1.04 build 4

If I try the following using the ElevateDB ODBC driver:

"SELECT * FROM Site WHERE Code=?"

Where Code is an Int32. (Autoinc)

The data is returned correctly for any existing sites that were
imported, but if I create a new Site and then try and select the new
site it fails with a blank OdbcException thrown.

The new site appears in the table using EDBManager, and looks fine.

Chris Holland
Mon, Jul 2 2007 2:26 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Chris,

<< I imported an existing table "Site" from DBISAM 4 in ElevateDB 1.04 build
4

If I try the following using the ElevateDB ODBC driver:

"SELECT * FROM Site WHERE Code=?"

Where Code is an Int32. (Autoinc)

The data is returned correctly for any existing sites that were imported,
but if I create a new Site and then try and select the new site it fails
with a blank OdbcException thrown. >>

Could you send me an example of what you're doing ?

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Jul 2 2007 3:02 PMPermanent Link

Chris Holland

SEC Solutions Ltd.

Avatar

Team Elevate Team Elevate

Hi Tim,

I tried to do an example but I couldn't export the file from the database.

I will try uninstalling all of th eElevateDB stuff tomorrow and
reinstalling to see if that helps

Chris Holland

Tim Young [Elevate Software] wrote:
> Chris,
>
> << I imported an existing table "Site" from DBISAM 4 in ElevateDB 1.04 build
> 4
>
>  If I try the following using the ElevateDB ODBC driver:
>
>  "SELECT * FROM Site WHERE Code=?"
>
>  Where Code is an Int32. (Autoinc)
>
>  The data is returned correctly for any existing sites that were imported,
> but if I create a new Site and then try and select the new site it fails
> with a blank OdbcException thrown. >>
>
> Could you send me an example of what you're doing ?
>
> Thanks,
>
Mon, Jul 2 2007 5:43 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Chris,

<< I tried to do an example but I couldn't export the file from the
database. >>

Just the code that you're using and the table structure would be fine.  You
can reverse-engineer the database in the EDB Manager under the Tasks menu
for the database.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Jul 3 2007 3:53 AMPermanent Link

Chris Holland

SEC Solutions Ltd.

Avatar

Team Elevate Team Elevate

I think it might be a file import problem so I need to send you the
actual file.

I have reinstalled ElevateDB and the backup is working now, so I will
post the backup and the test project into the binaries.

Chris Holland


Tim Young [Elevate Software] wrote:
> Chris,
>
> << I tried to do an example but I couldn't export the file from the
> database. >>
>
> Just the code that you're using and the table structure would be fine.  You
> can reverse-engineer the database in the EDB Manager under the Tasks menu
> for the database.
>
Tue, Jul 3 2007 5:34 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Chris,

<< I think it might be a file import problem so I need to send you the
actual file. >>

There was an issue with the restore - it was having problems with restoring
a single table and the catalog from a backup that included the catalog.  It
would give a compression error in such a case.

<< I have reinstalled ElevateDB and the backup is working now, so I will
post the backup and the test project into the binaries. >>

The issue with the parameters is the same as with your other project.  The
parameter lengths were not being handled properly for non-string/bytes
columns.  Both of your projects will work fine with B5.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image