Click here to Skip to main content
15,902,445 members

Comments by Naikniket (Top 44 by date)

Naikniket 28-Jul-19 1:27am View    
Yes you are correct, but here my question is quite different. I want to show user a customized message if the foreign key constraint fails. That means while deleting a record, if the reference of that record exists in secondary table a message saying you have <number_of> record in <secondary_table_name>, delete it first.
Naikniket 22-Jul-19 6:45am View    
I am using this query
select * from pages_mst u
left join user_page_rights_mst up on u.id = up.fk_page_id
left join users on up.fk_userId = users.id

Which gives me all pages with null values as said, but if i want to see for specific user

select * from pages_mst u
left join user_page_rights_mst up on u.id = up.fk_page_id
left join users on up.fk_userId = users.id where users.id=1

Then it only shows the pages that are in permission table. not nulled records
Naikniket 13-Jul-13 7:27am View    
can you provide me any link?
Naikniket 17-Jun-13 8:03am View    
I have solved the issue... Thanks...
Naikniket 5-Jun-13 21:50pm View    
i have tried to find program data/users program data directory in to (file system on target machine>add special folder) but i cant find any option for program data or users program data. How to achieve this? And also i am using Application.StartupPath ("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Application.StartupPath & "\database name.accdb") to connect with databse. What changes will needed after doing this?