Hi Everyone
I have a very very basic question.... I would like to do 'validation rule' in SQL Server the same as I can do in MS Access. More precisely I would like Score INT field to be between 1 and 5 only.
How can I do that in SQL Server 2005?
Many thanks in advance
Emil
emsik1001
Last Activity: May 1 '10, 07:05 AM
Joined: Dec 7 '07
Location:
-
MS Access Validaiton rule in SQL Server
-
Thanks for the replies I'm glad my logic is still working ;)
C was my guess after eliminating the rest however I was wondering if they don't mean using a subquery in the INNER JOIN (or others) which I think it can be used this way. Which for me it kind of mean join tables.
Regards
Emil -
Subqueries cannot (multiple choice)
Hi
I have done an access test and there is one question that where currently all answers seems to incorrect for me. (only one is incorrect).
Q: Subqueries cannot:
a) use group by or group functions
b) retrieve data from a table different from the one in the outer query
c) join tables
d) appear in select, update, delete, insert statements.
I would appreciate explanations...Last edited by NeoPa; Apr 18 '09, 05:39 PM. Reason: I see this as a request for clarification after a test question, rather than help with homework or assignment - hence valid -
Hi
Thanks I didn't understand what you exactly mean but finally I was able to find instructions how to add my IP address to the user table in MySQL so I can connect remotely--- didn't work first time but after
flush priviliges;
worked perfectly
ThanksLeave a comment:
-
I'm using admin with password which seems to have access to everything.Leave a comment:
-
How to connect remotely to Linux/MySQL using MySQL Query Browser
Hi
http://dev.mysql.com/doc/query-brows...onnection.html
I'm trying to connect from my Windows based PC to a dedicated server which is running on Linux system.
I type server host and port 3306 user name admin + password and default schema and I get access denied message.
I use putty to connect to the server using IP and port 22 and it connects to the server.... -
Demon hosting how to use it (odbc/MySQL)
Hi
I have pretty basic question for someone who uses http://www.demon.net/
My customer wants a PHP web page; very basic one which I can do for him but I have no idea how to set up ODBC connection (I want to use Access format database) on his account. I can do that with fasthosts quite easily but I cannot find anywhere this option on his demon account.
p.s. How do I use MySQL with demon? do I need... -
Thanks changing the property to false and using .matchfound did the job!!
Will save me a lot of timeLeave a comment:
-
Yes it is logical but I need something with user friedly explanation.
The thing is that several hundred people will be using this solution and I doubt my customer will want to answer their question what "invalid property value" mean, so ideally I need something to display a proper message box. I have tried before update but the error appear before this event.
Regards
EmilLeave a comment:
-
how to avoid "invalid property value" in a combo box when empty
Hi
I have a few combo boxes where the match is required.
When I select a value and then delete it and go to another control then I get very user unfriendly message "invalid property value".
I want to allow to go to a different controls if the value is empty and if the value is not in a drop down box I want to either display a user friendly msgbox or clear the drop down box value.
... -
Just an update
I have used this property to get the path but unfortunately my dataset has been using a different path.
After reading some forums I changed publish status to data file and used this property Application.Use rAppDataPath to get the path and now my updates and dataset are synchronized.
Regards
EmilLeave a comment:
-
Thanks that is what I was exactly looking for!!Leave a comment:
-
VB.net - How to install it with other files
Hi
I would appreciate if someone could point me in the right direction.
I'm developing a small application which includes MS Access database in it.
When someone install it I need to know where the database was installed so I can update the connection string. Currently I use OnceClick VB 2008 feature and it doesn't alow me to specify the folder.
On Vista PC I have also some issues... -
VB.net which methods to use?
Hi
I want to create a small vb.net application which will issue simple SQL scripts mainly INSERT and UPDATE based on text boxes or selections. Majority of them effect only 1 record at a time.
I know how to use ADO (recordsets) but I have no idea how to use ado.net and update tables directly. (I have tried dataset, table adapters etc but I couldn't update the database I was able to update only the disconnected dataset)... -
Hi
I have created a table + query and used your DELETE script went to query design view clicked run and it worked.
I suspect your already try to change DELETE to SELECT to see if the query is selecting the proper data in your database?
I'm sorry but I cannot see a reason why it doesn't work. I will send you a private message with my email address if you want to send a sample of your db and I will be able...Leave a comment:
-
Hi
Ask your friend to convert it to Access 2000 format (using 2003) and see if it works on your pc :)
Hope it helps
EmilLeave a comment:
-
Hi
Using 2003 and 2007 can cause strange 'unexpected errors'. (at least my experience)
I would create a copy of the db and try to re-construct the subform drop down box using Access 2007 and see if it resolves the issue.
Regards
EmilLeave a comment:
-
Hi
I undestand that you have a form with the fields from the table and you want to add 'combo box' control from the toolbox and in the wizard (which should appear) you selected 'I want the combo box to look up the values in a table or query'+ correct table and field. but it still doesn't work?
Is that correct? ... I'm just trying to understand where the problem lies.
Regards
EmilLeave a comment:
-
Hmm interesting
I haven't come across this before and I would think that if youry query is not somehow set up as read only then you should be able to do that.
I don't have a solution for that so I hope other members will be able to help more then I.
Regards
EmilLeave a comment:
-
Hi
I normally put STOP before the code I want to check then run it and use F8 to check the code step by step in majority of cases it resolves my issues straight away.
Hope it helps
EmilLeave a comment:
No activity results to display
Leave a comment: