Re: [Firebird-odbc-devel] Firebird and MS Access

[Olaf K. <ola...@sa...>]

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

 

 

Von: Jorge Andrés Brugger [mailto:li...@da...] 
Gesendet: Mittwoch, 1. April 2015 13:51
An: fir...@li...
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
Fir...@li...
<mailto:Fir...@li...> 
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: jbr...@da... <mailto:jbr...@da...> 
Website: www.dasu.com.ar <http://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.