Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM ODBC Driver » View Thread |
Messages 1 to 6 of 6 total |
Selecting New Records In ElevateDB |
Mon, Jul 2 2007 5:24 AM | Permanent Link |
Chris Holland SEC Solutions Ltd. 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent Link |
Chris Holland SEC Solutions Ltd. 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent Link |
Chris Holland SEC Solutions Ltd. 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Wednesday, April 17, 2024 at 10:35 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |