Hello,
You can try that :
SELECT ID FROM data WHICH Name LIKE 'DAVI*';
It's the solutions I find in a the next site :
http://www.fgcu.edu/support/office2000/access/queries.html
bye
Sylvie...
sylvie36
Last Activity: Aug 2 '06, 05:43 PM
Joined: Jul 24 '06
Location:
-
Hello,
Trying by used the next name Sites_Union_Con trols because I'm not sure that you can have a name with blanc characters
Good luck
Sylvie...Leave a comment:
-
Hello,
To my mind you can try to add some quotes to the line 28 which is the line on error as next :
* SET SQLSTRING = 'SELECT sum(cast('|| v_col_name || ')) into' ||v_total|| ' from ' '||' V_TAB_NAME
Because if you don't put quotes || is a type of argument for the function V_TAB_NAME which isn't the case.
Good luck
ByeLeave a comment:
-
Hello,
When you see the error message you have the number of the line which is not ok. It's the 28's one so it's the next one :
And the message is sample. You can't used || has an argument so you need employed quotes ' ' for puting it as commantary and not as a type of argument of the function V_TAB_NAME
* SET SQLSTRING = 'SELECT sum(cast('|| v_col_name || ')) into' ||v_total|| ' from ' || V_TAB_NAME...Leave a comment:
No activity results to display
Leave a comment: