Hi!
I think my queries started to act strange.
First problem is when I select several fields from a table and then go to SQL, it always has a comma and a * at the end of the first row.
For example:
SELECT Id, FieldX, FieldY, *
FROM...
Normally it should be:
SELECT Id, FieldX, FieldY
FROM...
If * and comma are deleted from SQL, everything works fine. It is just there as default.
Second problem is if I want to add number, or data value from a form to a query, it returns funny squares or other funny symbols. I have to create additional control on a form, to copy problematic data format to string and then successfully use it in query.
As I remember it was not happening before. All my prior queries are without “comma *” end. Not absolutely sure about second problem, but I think I was able to use any data format from a form in a query. What is wrong??? Did I turn some feature ON, or OFF???
Thanks!
I think my queries started to act strange.
First problem is when I select several fields from a table and then go to SQL, it always has a comma and a * at the end of the first row.
For example:
SELECT Id, FieldX, FieldY, *
FROM...
Normally it should be:
SELECT Id, FieldX, FieldY
FROM...
If * and comma are deleted from SQL, everything works fine. It is just there as default.
Second problem is if I want to add number, or data value from a form to a query, it returns funny squares or other funny symbols. I have to create additional control on a form, to copy problematic data format to string and then successfully use it in query.
As I remember it was not happening before. All my prior queries are without “comma *” end. Not absolutely sure about second problem, but I think I was able to use any data format from a form in a query. What is wrong??? Did I turn some feature ON, or OFF???
Thanks!