No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
2 Posted Topics
I am facing a query performance problem. While connecting to MySQL database through different Users methodology. Tell me does connecting by IP address user has over head. Like connecting using user@locahost or user@host-ip-address Is there any performance-wise difference by connecting using any of this user. I am getting a massive …
Kindly try this If CabRego is numeric [CODE]"Select MAX(Acc_id) as MAX_ID from AccDtl where Acc_Date='" & Me.DTPCollDate.Text & "' and CabRego =" & Me.cmbcabs.Text[/CODE] Else [CODE]"Select MAX(Acc_id) as MAX_ID from AccDtl where Acc_Date='" & Me.DTPCollDate.Text & "' and CabRego =" & Me.cmbcabs.Text & "'"[/CODE] now get MAX_ID column. Hopefully this …
The End.