Recent content by 999Dom999

The answer: Procedure - leaving the Live DB in place 1: Restore the database to a separate location (no under the domino server data location) without including any NLO files. 2: Log on to a local admin client and turn off replication in the database replication settings 3: Place the data in...

My usual way of restoring emails was: Restore mail file to a different location, rename it. Open current and renamed mail files in Domino Admin Copy and paste the emails that were needed. Now I have DOAS, I have to do the same as above but copy it into the mail folder of the domino server due...

Thanks as my post above I figured it out, it was my mistake [sadeyes]

AHHHHH!!!!! Had nothing to do with the string. I was running a loop with an array holding database values, when it returned no results the array still held the info from the previous result set. If I hard coded the date I would always get the result I expected! D'oh so silly!!! That mind...

I'm creating a query its long so I won't post it all but this part in question. $first = date('Y-m-d', mktime(0, 0, 0, 10, 1, $y)); $last = date('Y-m-t', mktime(0, 0, 0, 10, 1, $y)); $dateQuery = " ITRAN.IT_DUE >= { d '$first'} AND ITRAN.IT_DUE <= { d '$last'} AND "; So $dateQuery outputs...

I'm simplifying my actual queries, but hope this gets across what I'm trying to do, here goes: QUERY 1 SELECT SA_MODEL,SALES_QTY FROM SALES RESULT MODEL SALES QTY ABC123 5 ABC124 5 QUERY 2 SELECT OUT_MODEL,OUT_SALES_QTY FROM TRANS WHERE IT_STATUS = 'A' AND IH_CREDIT = ' AND IH_STKSAVE = '...

Thanks Olaf for pointing me in the right direction!!!! By playing around with CAST I managed to get the first line working then I got the exchange rate line working. I think I can shorten it further but below was my final statement. My sore head has now gone! One more question is there a way...

Hi Olaf Thanks for your suggestions, both return 0 (Actually I just noticed it doesn't return a zero it returns nothing) if I remove the division it works. I can multiply it by 0.01 but then on the next line I need to divide by an exchange rate from the database. This line also returns...

Hi Mike Yes there is a GROUP BY and HAVING clause in the statement. In the ODBC version I just had just one column in the GROUP BY statement when using OLE DB I had to enter all non summed columns. I just read that this was changed in VFP8 http://support.microsoft.com/kb/813361 My statement...

I'm creating a web reporting app using PHP and connect to our VFP9 database with MS OLE DB Provider for VFP9. I was previously using ODBC but it couldn't do embedded select statements so switched to OLE DB which has more functionality but I'm getting problems with the exact same query that...

It is VFP9 but I was using ODBC to connect and ODBC-SQL is limited, I found out I can use OLE DB to connect instead this supports derived tables. I used Ian's example it needed a comma after charname and an Alias name after the close bracket and works perfectly! Thanks so much :)

I know its foxpro but I'm using sql queries they are just a bit limited with functionality offered by odbc sql, I really need an odbc sql forum but this is the closest I found. I tried with the AliasName but it still threw a syntax error. Thanks

Thanks Ian, I'm sure that would work but I'm using odbc SQL via PHP to a Foxpro Database and unfortunately its a bit limited in functionality. If I try to do a select statement inside a select statement it throws a Syntax error, even this simple test didn't work - Select * from (SELECT * FROM...

I have 2 tables with identical columns names. I have model numbers in each that I want return and if they are in both tables I want them to sum. I tried to use union but it just added the same model number twice. Any ideas how to achieve this below: Table 1 --------------- Model quantity...

Thanks for all your replies. First suggestion I couldn't get to work. Using the order by column no. worked a treat. The last one didn't work for me I had previously tried it but I'm using ODBC SQL in php to connect to foxpro db not sure if it fully supports everything. The final way was that...