hydrazi
asked on
VB.Net Query Issue
Hello! I have been creating a .Net program that connects with a MySQL server to display large amounts of data in a Datagridview. I have gotten my program to function perfectly except for my queries. I was asked to query every field in a 38 field database and it has not been the most forgiving experience. My main issue is that some of the database field names have more then one word in them. As an example, [Order Received]. I cannot create queries for these multi-word fields. I am trying to do this using the Visual Studio Query Builder. If anyone is able to help on this situation I would greatly appreciate it.
~Hydrazi
Untitled.jpg
~Hydrazi
Untitled.jpg
ASKER
I did [ ] but I still got an error. Let me post the error and the info I put into the builder.
For the Order Received I typed LIKE [Orde Received] = @[Order Received] and I get a expression expected error
For the Order Received I typed LIKE [Orde Received] = @[Order Received] and I get a expression expected error
Why do you have a space in parameter name? I think that's the issue.
ASKER
Ill try removing the space.
I removed the spacing and it said "Cannot convert entry to valid date/time"?
I removed the spacing and it said "Cannot convert entry to valid date/time"?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I would type that in the builder?
I don't use the designer/builder so not entirely sure but try that.
Are you enclosing the multiword fields in [] ?