NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitd13fe29

committed

I have a problem with Access97 not working properly when entering new

records using a sub form, i.e. entering a new order/orderlines or masteranddetail tables. The problem is caused by a SQL statement that Access97makesinvolving NULL. The syntax that fails is "column_name" = NULL. Thefollowing attachment was provided by -Jose'-. It contains a very smallenhancement to gram.y that will allow Access97 to work properly with subforms. Can this enhancement be added to release 6.5? <<gram.patch>>Thanks, Michael

1 parentfd80c10 commitd13fe29Copy full SHA for d13fe29

File tree

2 files changed

-2

lines changed

src/backend/parser
- gram.c
- gram.y

2 files changed

-2

lines changed

`‎src/backend/parser/gram.c`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -242,7 +242,7 @@`
`242`	`242`	`*`
`243`	`243`	`*`
`244`	`244`	`* IDENTIFICATION`
`245`		`- * $Header: /cvsroot/pgsql/src/backend/parser/Attic/gram.c,v 2.76 1999/03/07 03:34:06 momjian Exp $`
	`245`	`+ * $Header: /cvsroot/pgsql/src/backend/parser/Attic/gram.c,v 2.77 1999/03/14 05:14:59 momjian Exp $`
`246`	`246`	`*`
`247`	`247`	`* HISTORY`
`248`	`248`	`* AUTHORDATEMAJOR EVENT`

`‎src/backend/parser/gram.y`

Lines changed: 3 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -10,7 +10,7 @@`
`10`	`10`	`*`
`11`	`11`	`*`
`12`	`12`	`* IDENTIFICATION`
`13`		`- * $Header: /cvsroot/pgsql/src/backend/parser/gram.y,v 2.58 1999/03/07 03:34:10 momjian Exp $`
	`13`	`+ * $Header: /cvsroot/pgsql/src/backend/parser/gram.y,v 2.59 1999/03/14 05:15:08 momjian Exp $`
`14`	`14`	`*`
`15`	`15`	`* HISTORY`
`16`	`16`	`* AUTHORDATEMAJOR EVENT`
`@@ -3702,6 +3702,8 @@ a_expr: attr opt_indirection`
`3702`	`3702`	`{$$ = makeA_Expr(OP, "<", $1, $3); }`
`3703`	`3703`	`\| a_expr '>' a_expr`
`3704`	`3704`	`{$$ = makeA_Expr(OP, ">", $1, $3); }`
	`3705`	`+ \| a_expr '=' NULL_P`
	`3706`	`+ {$$ = makeA_Expr(ISNULL, NULL, $1, NULL); }`
`3705`	`3707`	`\| a_expr '=' a_expr`
`3706`	`3708`	`{$$ = makeA_Expr(OP, "=", $1, $3); }`
`3707`	`3709`	`\| ':' a_expr`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitd13fe29

File tree

2 files changed

2 files changed

`‎src/backend/parser/gram.c`

`‎src/backend/parser/gram.y`

0 commit comments