Search results for query: *

Thank you Thank you Thank you. You are a God. I spent four hours trying to fix this and your simple response was the answer I needed.

Hi, I created a main report that passes a variable to the subreport. Main report: shared stringvar strShowValue2; strShowValue2:=strShowValue2+totext({@v_percentage})+"^"; I pass this to my subreport and it shows in subreport as: {?Pm-@v2_ShowValue}= 0.00^0.00^95.04^0.00^...

Hi, I seem to have problems aggregating data and then storing the data into a temp table for later viewing: Ex: select ticketnum, sum(priceextension) total into "#table1" from TICKHISD where ticketnum=457117 group by ticketnum trying to view the temp table: select * from "#table1" result...

After some research, I believe we are using PCC since I sometimes get an erro with PCC.exe. I've tried to create another stored proc that aggregates and stores to a temp table then aggregate that result and store to a another temp table to see if the result set would be divided by 100 twice...

The version I'm using is 8.60.192.030. I'm creating the stored proc through the Data Manager and executing the stored proc by calling it. the salary field is a currency field. I'm not sure what you mean by (PCC, ODBC Test). I've since reduplicated this many times and have found that if you...

Hi, I have been working for the last two hours trying to figure out why this was happening in Pervasive 8. table employee (simplified table) ID salary A 100 A 100 A 100 simplified version of stored procedure my stored proc: select ID, sum(salary) Total from employee group by...

Hi, I went through every single IV table to try and find the table that contains the data for the DOCTYPE field in IV30300. I know that DOCTYPE can be 1, 2, 3, 4, 5, 6, 7, and 11. But does anyone know which table actually links to that field to identify the data in DOCTYPE FIELD? Thanks in...