G Guest Aug 25, 2007 #1 I just upsized to a Data Project and my user prompts aren't working. What's the correct syntax for SQL? Thanks
I just upsized to a Data Project and my user prompts aren't working. What's the correct syntax for SQL? Thanks
G Gary Walter Aug 26, 2007 #2 okschlaps said: I just upsized to a Data Project and my user prompts aren't working. What's the correct syntax for SQL? Click to expand... Without much detail, a WAG might be that your SQL is still using "*" wildcard, which you need to change to "%"
okschlaps said: I just upsized to a Data Project and my user prompts aren't working. What's the correct syntax for SQL? Click to expand... Without much detail, a WAG might be that your SQL is still using "*" wildcard, which you need to change to "%"
G Gary Walter Aug 27, 2007 #4 Hi okschlaps, Use a stored procedure. Views (equivalent to "queries" in Access) do not support the "bracketed user input" syntax (to my knowledge). good luck, gary okschlaps said: No, no wild cards. Just a simple [Enter Invoice Number]. Thanks Gary Walter said: Without much detail, a WAG might be that your SQL is still using "*" wildcard, which you need to change to "%" Click to expand... Click to expand...
Hi okschlaps, Use a stored procedure. Views (equivalent to "queries" in Access) do not support the "bracketed user input" syntax (to my knowledge). good luck, gary okschlaps said: No, no wild cards. Just a simple [Enter Invoice Number]. Thanks Gary Walter said: Without much detail, a WAG might be that your SQL is still using "*" wildcard, which you need to change to "%" Click to expand... Click to expand...
G Guest Aug 27, 2007 #5 Ahh, that explains it. Good to know. Thanks. Gary Walter said: Hi okschlaps, Use a stored procedure. Views (equivalent to "queries" in Access) do not support the "bracketed user input" syntax (to my knowledge). good luck, gary okschlaps said: No, no wild cards. Just a simple [Enter Invoice Number]. Thanks Gary Walter said: : I just upsized to a Data Project and my user prompts aren't working. What's the correct syntax for SQL? Without much detail, a WAG might be that your SQL is still using "*" wildcard, which you need to change to "%" Click to expand... Click to expand... Click to expand...
Ahh, that explains it. Good to know. Thanks. Gary Walter said: Hi okschlaps, Use a stored procedure. Views (equivalent to "queries" in Access) do not support the "bracketed user input" syntax (to my knowledge). good luck, gary okschlaps said: No, no wild cards. Just a simple [Enter Invoice Number]. Thanks Gary Walter said: : I just upsized to a Data Project and my user prompts aren't working. What's the correct syntax for SQL? Without much detail, a WAG might be that your SQL is still using "*" wildcard, which you need to change to "%" Click to expand... Click to expand... Click to expand...
