Click here to Skip to main content
15,902,733 members

Comments by kmoorevs (Top 20 by date)

kmoorevs 11-Mar-24 17:08pm View    
As others have said, given the field names you have provided, (check and key) it's highly likely that as others have said, you need to bracket the field names as these are pretty good candidates for reserved words. Different providers may have their own rules, but the safest bet is to not name your database fields with words that are likely to be sql/access reserved words.
kmoorevs 12-May-23 8:45am View    
Hello, can you provide some feedback? Did any of these solutions work for you?
kmoorevs 5-May-23 16:07pm View    
Have a look at my revised answer above. It seems to match the results you are looking for.
kmoorevs 2-May-23 9:57am View    
You are absolutely right! I misread the title/question.

Still, I think parts of this solution may be useful. I will give this another try later today as time permits.
kmoorevs 29-May-21 13:24pm View    
You should have read somewhere that sql top requires an order by clause. You don't mention which dbms this is against, but not all (such as mysql which uses a the limit keyword instead) will use the same syntax. Also it's not clear that you understand the use of parameters. It appears that you are trying to insert a variable where a parameter is expected. Either assign the variable to a parameter or better yet, simply concatenate the variable into the query...you don't even need to convert it to an int doing it that way.