Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #37.0K
4 Posted Topics
In the column definition: default value = now()
What is the error-message? Maybe you have to put an extra spcace before the last line (" AND last_name = " & Session("last_name") & "")
[FONT=Courier New]SELECT * FROM emp emp1 WHERE TRUNC(emp1.doj) IN (SELECT TRUNC(emp2.doj) FROM emp emp2 WHERE emp2.rowid <> emp1.rowid)[/FONT]
I have the same kind of problem. The error message: The decimal field's precision is too small to accept the numeric you attempted to add. The oracle-field is: NUMBER(6,3) In Access the field is: Decimal (6,3). Can someone tell me how to solve this problem?
The End.