Search results for query: *

If there is any more information I could provide to help diagnosing this issue, please let me know.

Hello, I am told this function was working then seemed to stop. User calls in and gets VM Press 0 routes to Ext 201 and receives, "currently on the phone message" If I dial direct to ext 201 internally or externally, no problem. From Call Rerouting Table - 19: Station Dial 0 routing...

In between replies I have been trying many, many things and changing things quickly, working to find a acceptable solution. Definitely not twiddling my thumbs waiting for replies Olaf. Since I do recognize various SQL dialects, testing in access does have its benefits for me in this situation...

First and foremost, I am here with eyes wide open. I do believe I am not doubting the help. I am grateful. I simply failed to remove [] from my post. This is mostly because I was testing the query in MSaccess linked to DBF's and the [] are supported. As many people do I edited my code to...

Mike: I did read your post well, thank you. I was not sure how to utilize the cursor, perhaps it would work in Cold Fusion as well, I just did not expand on that idea. The brackets came over from e semi-functioning version of this query in MSAccess. I believe in Access and VFP ODBC, brackets...

I updated using Borislavs example, fixed few small errors but still getting a syntax error. SELECT a.item , a.ionhand , b.lonhand , b.orderpt , b.lonordr , getQuery1.MatAllocated , getQuery1.MinReqDate FROM icitem10 a INNER JOIN iciloc10 b ON a.item = b.item INNER JOIN (SELECT...

Thanks guys, here is more information I should have provided initially. Query1 & Query2 are names I just placed in this post for easier reading, they cannot be referenced by the query as coded now. This query was working in MSaccess with linked tables but issues with full outer join and...

I have a tricky query I cannot seem to come up with a good solution for. The first query functions. Second needs works. I would like to make this a single query, need help with that. The WHERE statement in Query2, not sure how to handle this as well. Query2 should be the result set. Code...

Turns out LIKE() only supports * and ? and NOT # for digits. At least in my environment which is Cold Fusion and FoxPro ODBC Driver. Any suggestion for testing for digits? item = 30400M01 IIF(LIKE('#####M##*', item),PADR('yes',3),PADR('no',3) ) AS myResult myResult from this is "no", as you...

All the input is a huge help, thanks again. This is my first time dealing with FoxPro. So the final problem Im dealing with is using the field alias's ( myGroup myDiv myProdType ) in the evaluation and result expression of the IIF. I was able to get around the evaluation portion by just using...

Thanks all, this has been a HUGE help. It is so close to totally working now. On my last IIF if the test is false I would like to set myDept AS [myGroup] [myDiv] [myProdType] but get an error: Function name is missing Is this a VFP function limitation or syntax issue? Any thoughts on getting...

ok, thanks thats a huge help to know. So I have it working now with this statment: ,IIF( (SUBSTR(aa.item, 1, 1) = '7') = 1, 'Homo', 'Not Homo') AS TEST Is there a better way to do a string comparison? I need something similair to the LIKE operators , #, ? , * etc.. For instance I need...

cannot seem to isolate this one...if I change the LIKE to = it works. Error: Missing comma SELECT aa.wono ,IIf(aa.item LIKE '7*' ,'Homeopathic','not homo') AS TEST FROM (((ppwohd10 aa INNER JOIN (icitem10 bb LEFT JOIN tblProductTypes dd ON bb.itmclss = dd.ItemCode) ON aa.item = bb.item)...