C
C#•16mo ago
moshimoshi

✅ Why wont these SQL queries work?

Creating a userview - this works. 
CREATE VIEW GoodCustomer
AS SELECT CustomerID, CustomerName,
MemberCategory,CountryCode
FROM Customers
WHERE MemberCategory IN (‘A’,’B’)
CREATE VIEW GoodCustomer
AS SELECT CustomerID, CustomerName,
MemberCategory,CountryCode
FROM Customers
WHERE MemberCategory IN (‘A’,’B’)
Update userview - doesnt work 
UPDATE GoodCustomer
SET MemberCategory = ‘C’
WHERE CustomerID = 1000
UPDATE GoodCustomer
SET MemberCategory = ‘C’
WHERE CustomerID = 1000
Insert userview: - doesnt work 
INSERT INTO GoodCustomer (CustomerID,
MemberCategory, CountryCode)
VALUES ( ‘5000',’C’, ‘USA' )
INSERT INTO GoodCustomer (CustomerID,
MemberCategory, CountryCode)
VALUES ( ‘5000',’C’, ‘USA' )
4 Replies
Jimmacle
Jimmacle•16mo ago
"doesn't work" is not specific
moshimoshi
moshimoshi•16mo ago
Can I ask for this query in SQLite: I have created a view successfully called Customer1998. When I run this query 
SELECT * FROM customer1998;
SELECT * FROM customer1998;
it gives me this error: Result: no such table: main.order details How can i Resolve this?
moshimoshi
moshimoshi•16mo ago
Regarding this, is this becoz of the view-defining condition?
moshimoshi
moshimoshi•16mo ago
Ah i managed to resolve this!!
Want results from more Discord servers?
Add your server
More Posts
❔ I'm trying to convert a Vector3 string to a Vector3 but the numbers returned aren't correct.``` // Converts a string to a Vector3. // Examples: 's' can be ".5,.5,.5" or "1". public ❔ ✅ Serializable attribute in UnityI am creating a class selection menu right now for game character. I have created two types: ```cs [Error during SignalR integration test: The 'InvokeCoreAsync' method cannot be called if the connectiI get the exception `System.InvalidOperationException: The 'InvokeCoreAsync' method cannot be called❔ ✅ Why is this true?I want to check as if ``file.Length`` less than 10000..but why do the expression is true, ``file.Len❔ struct inheriting from IEquatable<T>hi, what is the point for a struct to inherit from IEquatable<T> ? 🤔 have a nice day !✅ EF Seeding and RelationshipsHey everyone, I have a quick question. I'm reading through the EF documentation rn because I need to✅ Help with SQLite INSERT INTO C#Hey all, I'm running this code and I don't understand why there is no data being stored in my create❔ ListBox Text OverFlowI am using a list box to store messages on a message app. However if a message is of a certain lengt❔ Preventing a panel from overflowing + show scrollbar WPFI have a situation like this ```xml <StackPanel> <Grid> some buttons </Grid> <StackPanel> ❔ The helper method 'Problem()' isn't in my controller scope. Pls help!The helper method 'Problem()' isn't in my scope despite inheriting ControllerBase. When I scan the G