Recent content by AdamField

Hey R937, You mean split up the query in 2 and make 1: a Copy query that copy's the full table to the webserver 2: update the stuff_to_update into the article table 3: truncate the stuff_to_update on the webserver Tnx for the advice already Adam

Hey Guys, I'm stuck on this problem and hoping somebody can give me a step into the good direction on it. First i'll try to give you all a view on the situation Mysql Server1 (lets call him Webserver:p) Mysql Server2 (lets call that one LocalHost) Now i'm working with Navicat so that's my...

Hey All, I created a DTS local packages that makes 1 big table from 5 other tables. When i run the package from the local packages (execute package) IT pops up and runs perfect. The data in the table is also correct so no problem there. Problem starts when i right click the local package and...

Hey Guys, Like r937 said, i get this info from our account program (seperated program) but becouse that thing can't do 1/10 of the stuff we want it to do (it's flat file DBF files :p) we export to SQL on a daily base i can be 100% sure that all the DB's are the same. Still tnx for the example...

it's working with the union all :p and working like a charm Adam

Tnx Big time r937 Tested it out and it's working perfect, What would i need to do if i want to ad a 3e DB ? SELECT *, 'EDE' AS Filiaal FROM DBFact_EDE.dbo.hisarel UNION ALL SELECT *, 'ANT' AS Filiaal FROM DBFact_ANT.dbo.hisarel UNION ALL SELECT *, 'GEN' AS Filiaal From...

Hey Guys, i got a stupid problem with making a SQL View and becouse i have zero sql skills i'm trying here :p what i have is in total 5 DB's all the DB's have 10 colum's with info now i need to make 1 BIG view from those 5 db's but i need to get 11 colums now first 10 are the same as what is...

hey again, got the problem solved by somebody on CR forums and it was only a mather of placing the correct () arround the if then elses....

Hey Guys, Got a formula that is working in the simple form but the moment i expand it, it start's do go wrong This is what i have DB1 Backorkl : colums with info im using b_afwerk (boolean) b_relnum DB2 bomatch : colums with info i'm using...

Hey Ian, This exactly what i have now (3 copies of every report with diferent DB info). Bad thing is the guy before me made all those copies table dependant (aka db fields straight in the reports in stead of into a formula and grouping / working on the formula). This makes my job a bit more...

Hey Ian, I have to split them in diferent db's becouse all the numbers from invoices / orders / delivery's are the same number layout (090000001 / 090000002 / ...). The same for almost all other info (it would be a nightmare to rename all the column's in the SQL and rework XXX number of...

Hey Boboleft I presume that would be somthing like if {table.payment code} in ["prn", "prn1", "prn3"] and{table.trans date} > currentdate-90 then{table.amt} else 0 Greets Adam

Hey All, I'm stuck with quite a big problem and i hope this way will will get me a answer. I'll try to explain the problem as good as possible but feel free to ask more info if needed: First, the company i work for has 3 shops (lets call them shop1 - 2 - 3) and the program we work witch...

Hey Jhowardcarter, Would it be possible to tell us how you did it ? just curiocity Greets Adam

Hey Andrew, I'm using XI release 2 at the moment. I looked arround on the net and most of the program's are like 500+$ wich is a bit much i think. And that easy to make a program might not be so easy for me hehe. Greetings Adam Field