Search results for query: *

ettienne, thank you very much! I found the problem after record a macro. I should use "PRIUNTPRC" instead of "UNITPRICE".

I added a line for testing after assigning the value msbox OEORD1detail1Fields.FieldByName("UNITPRICE").value and it gives right value. But after run the program, it still only pulls the default price from item pricing set up, not overwritten by the value I tried to assign it to.

Thanks, sorry about the typo. I didn't get any error message. It just didn't come in...

Hi All, I am using VB6 to import order entry from SQL to Accpac pervasive. Other fields come in ok, say, item number, qty. Only, unit price, I cannot make it to come in from SQL. I have tried all kinds of data type for the field, CStr, CDec, CDbl, none of them worked. Sample line of code...

Hello, I am new in Accpac API web development area. I followed the sample to create a very simple .net web to write new order entry to Accpac Pervasive DB. I am using Accpac 5.4a with all service packs and MS studio .NET v2002. My development environment is Windows XP. I stuck on the first...

r937, Period is in Date format. Thanks!

Hello, Could anyone help me on writing a SQL statement to get the following data? Originally, I have a data set: Key | Period | rowValue 1 | 2003/01 | 5 2 | 2003/02 | 8 3 | 2003/03 | 20 4 | 2003/04 | 10 5 | 2003/05 | 7 ... And want to have a desired dataset: Key |...