Link Child/Master fields in ADP do not work if not integer.

M

MNF

I'm upsizing MDB to ADP and have a form with subforms where Link
Master/Child fields are numeric but not integer-scale greater than
zero. The field is defined as numeric(28.2).
However Access doesn't recognize scale and generate incorrect SQL
statements, eg
exec sp_executesql N'SELECT * FROM "dbo"."PickSlipOverdues" WHERE
((@P1 = "PatronID"))', N'@P1 numeric(28)', 7
instead of correct , N'@P1 numeric(28.2)', 7.01
As a result join doesn't work and subform is not populated.
The parent form is bound to the table with primary field defined as
numeric(28.2), child subforms are bound to the view or select
statements that has the same link field definition -numeric(28.2)

Is any way to force MS Access XP to recognize scale or it is a bug?

Thanks,
Michael Freidgeim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Master/Child Link breaks when opening in Access 2007 0
Link Master and Link Child Problem 13
Using link child/master in an ADP with the subform 0
subforms getting requeried unnecess 1
Master - Child links not working in 2007 0
Link Child and Master Fields - error 2
SQL INSERT trigger side effects not always displayed in ADP front end without refresh 4
A subform Link Child Fields, Link Master fields problem (newbiequestion) 6

Top