Quantcast

Firebird and MS Access

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Firebird and MS Access

Olaf Kluge

Hello @ll,

 

I have already a big Problem with this combination, msaccess (all versions) and firebird 2 (testet with 2, 2.1, 2.5) and the actually odbc driver.

 

First the constellation:

 

Table a

Primary Key year and number, so 2015 1, 2015 2, unique with main data for orders, one field is the number of the supplier, so 1 = supplier a from Germany, 2 is supplier b…

 

And there is a table 2

 

Foreign key Year and Number to Table 1, ID primary key and unique. There can be some more than 1 positions for every order, 1 to n relation.

 

I have already tried some things, so I have create the number not with (select max(nr)+1) but now with a generator.

 

The Problem: If the last order has the same supplier-id like the new created, MS Access shows me in some cases the Orderpositions in the subform (table 2) from the order before (with the same supplier-id).. And this at the point of refresh. So there is a new position createt, I have now three (if the order before have had 2), If I delete the order positions, I delete all positions, already the 2 from the order before.

 

Is there a workaround to solve this issue? In Access there is a main form with a subform, connectet from year and number to year and number.

 

Thanks a lot

 

Best regards.

 

Olaf

 

 


------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Firebird-odbc-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Firebird and MS Access

Jorge Andrés Brugger
Olaf:

First of all, please go to http://www.comicsanscriminal.com/ ;)

Then, why do you think your issue is related with ODBC driver?

Regards

El 01/04/2015 06:31 a.m., Olaf Kluge escribió:

Hello @ll,

 

I have already a big Problem with this combination, msaccess (all versions) and firebird 2 (testet with 2, 2.1, 2.5) and the actually odbc driver.

 

First the constellation:

 

Table a

Primary Key year and number, so 2015 1, 2015 2, unique with main data for orders, one field is the number of the supplier, so 1 = supplier a from Germany, 2 is supplier b…

 

And there is a table 2

 

Foreign key Year and Number to Table 1, ID primary key and unique. There can be some more than 1 positions for every order, 1 to n relation.

 

I have already tried some things, so I have create the number not with (select max(nr)+1) but now with a generator.

 

The Problem: If the last order has the same supplier-id like the new created, MS Access shows me in some cases the Orderpositions in the subform (table 2) from the order before (with the same supplier-id).. And this at the point of refresh. So there is a new position createt, I have now three (if the order before have had 2), If I delete the order positions, I delete all positions, already the 2 from the order before.

 

Is there a workaround to solve this issue? In Access there is a main form with a subform, connectet from year and number to year and number.

 

Thanks a lot

 

Best regards.

 

Olaf

 

 



------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/


_______________________________________________
Firebird-odbc-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

-- 
Jorge Andrés Brugger
Departamento de Informática
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Teléfono (0297) 446-4444 int. 103
Correo electrónico: [hidden email]
Website: www.dasu.com.ar

"No te pongas en el lado malo de un argumento simplemente porque tu oponente se ha puesto en el lado correcto" (Baltasar Gracián)

--
Antes de imprimir este mensaje, piense si es verdaderamente necesario hacerlo.

------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Firebird-odbc-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Firebird and MS Access

Olaf Kluge

it is an approach that I try to dissolve the problem somehow

 

 

Von: Jorge Andrés Brugger [mailto:[hidden email]]
Gesendet: Mittwoch, 1. April 2015 13:51
An: [hidden email]
Betreff: Re: [Firebird-odbc-devel] Firebird and MS Access

 

Olaf:

First of all, please go to http://www.comicsanscriminal.com/ ;)

Then, why do you think your issue is related with ODBC driver?

Regards

El 01/04/2015 06:31 a.m., Olaf Kluge escribió:

Hello @ll,

 

I have already a big Problem with this combination, msaccess (all versions) and firebird 2 (testet with 2, 2.1, 2.5) and the actually odbc driver.

 

First the constellation:

 

Table a

Primary Key year and number, so 2015 1, 2015 2, unique with main data for orders, one field is the number of the supplier, so 1 = supplier a from Germany, 2 is supplier b…

 

And there is a table 2

 

Foreign key Year and Number to Table 1, ID primary key and unique. There can be some more than 1 positions for every order, 1 to n relation.

 

I have already tried some things, so I have create the number not with (select max(nr)+1) but now with a generator.

 

The Problem: If the last order has the same supplier-id like the new created, MS Access shows me in some cases the Orderpositions in the subform (table 2) from the order before (with the same supplier-id).. And this at the point of refresh. So there is a new position createt, I have now three (if the order before have had 2), If I delete the order positions, I delete all positions, already the 2 from the order before.

 

Is there a workaround to solve this issue? In Access there is a main form with a subform, connectet from year and number to year and number.

 

Thanks a lot

 

Best regards.

 

Olaf

 

 




------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/




_______________________________________________
Firebird-odbc-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel



-- 
Jorge Andrés Brugger
Departamento de Informática
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Teléfono (0297) 446-4444 int. 103
Correo electrónico: [hidden email]
Website: www.dasu.com.ar
 
"No te pongas en el lado malo de un argumento simplemente porque tu oponente se ha puesto en el lado correcto" (Baltasar Gracián)


--
Antes de imprimir este mensaje, piense si es verdaderamente necesario hacerlo.


------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Firebird-odbc-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Loading...