Search results for query: *

...time frame and I noticed that every line item was getting duplicated for every location we had due to my join statement. I changed it to select * from V__salesWsmsa left join V__inv_cats on V__salesWsmsa.part = V__inv_cats.part and V__salesWsmsa.part.location = V__inv_cats.location and...

...a single part and the query was able to complete (returning 1796 rows of data) but when I try to run it for everything then thats when it is unable to complete. The query I tried is... select * from V__salesWsmsa left join V__inv_cats on V__salesWsmsa.part = V__inv_cats.part Thanks, Stan

Hey Mirtheil, Thanks for the reply. I'm using Pervasive 11.3, I tried bypassing the view and linking to the table directly but that didn't have any effect either. Other joins that I have done have worked but just not this one so I was thinking that maybe I was using the wrong join at first...

...to link 2 different tables that have a matching linked field. I used the following queries to make sure that there were matching fields.. select * from table1 where cust = 27070 (returns 2738 rows - showing customer sales data) select * from view1 where cust = 27070 (returns 1 row -...

Thanks a ton for the help, I'll try it out!

Hi all, Recently started up in a new role that is using Pervasive DB to go along with their ERP system. They have a cpl servers running Pervasive fictitiously named ABC and ABCWEB. All of the main data from the ERP program is entered into server ABC Database GLOBAL but reports off of an...

...code128$(chaine$) 'This function is governed by the GNU Lesser General Public License (GNU LGPL) 'V 2.0.0 'Parameters : a string 'Return : * a string which give the bar code when it is dispayed with CODE128.TTF font ' * an empty string if the supplied parameter is no good...

Hello, A friend of mine was using Sage Accpac v6 and now wants to switch to Sage Accounts 50. He is using a SQL 2008 database on a Windows 2008 server. Is there any way to import everything? I tried exporting customer records from Accpac 6 to import into Accounts 50 but I am worried that there...

Heya, Everything taking note of any type of remote IP address, either IIS logs, webpages with Request.ServerVariables("REMOTE_ADDR") or programs like our chat program that show remote users IP addresses are all coming up with our WAN IP address instead of the remote users IP. Everything...

Heya, Our company has an optional field created under AR for "BusinessType". We would like this optional field in CRM so we can create groups based on this field for mass maling, but unfortunately I don't know enough about database administration to make it happen. I guess I am looking to get...

Thanks ettienne for as valuable post as always, and a more genuine thanks to tuba, ill try and convince him to give it up.

Thanks for the reply, but if I'm going to tell the owners that I can't convert their data, they are going to want to know how much work it is to convert. Can you give me an outline of the process? Thanks

Hey all, At the end of every fiscal year, my company creates a new "Year End" database so if they need to see anything with the way things were at that time, they have a static, different company with that information in it. We have just upgraded to Sage Accpac ERP v5.6 and our Live data, 2008...

I spoke too soon.. I put the subreport in Details A and the formula with the shared variable in Details B and it works as long as there is there is new data in the subreport to passover, but if there isnt anything new, it carries over the total from the previous row until there is new data. Is...

That worked! Thanks!

...I have made a subreport with the formula... whileprintingrecords; shared numbervar contractitemprice:= {ICPRICP.UNITPRICE}-({ICPRICP.UNITPRICE}*({@Contract Price Level})/100) it gives me the results im looking for in the subreport, but then when I try and pass the data on to the main report...

Thanks to everybody! I was able to get the system up and running, with all the renovations being done to our warehouse, I guess the cable from the star talk got damaged, because after i replaced it, it stopped giving me the "not initialized" message and let me get in to change the info from the...

@Curlycord As I had stated in my original message, it does not ask for a password. it says it is an inactive feature. @bob thanks, i will read up on it and find my own answer.

My company has recently purchased a blg that had a Star Talk flash system in it with sw: version 1.7. Right now, if we have it plugged in to a phone box that has "voice mail" written on it, anybody who phones will go straight to an old ccr system setup by the previous tennant. After searching...

Thank you so much. Exactly the information I needed and it was nice and quickly given as well. All without making me feel like a dumbass. I was able to remove the epos line from my csapp table, install acdev and now all is hunky-dory again. Thanks!